I would like to know if a datafile recovery is possible in this case:
I make a cold backup of my database. My database is running in ARCHIVELOG MODE. And all the log files are available.
Start the database, Mount it and then open it.
Create a tablespace DUMMY which has one associated datafile: d1.dbf.
Create a table t1 in DUMMY tablespace.
Insert 3 rows into it.
6. Perform log switch.
Alter system switch logfile;
7. Finally delete d1.dbf datafile using UNIX rm command. There is no backup for this datafile as it got created after the coldbackup. Assume that we cant get this file in any possible way.
//My database is still running. Delete operation was performed using another terminal.
8. If we run a select statement>>> "select * from t1;" we will get an error saying that the d1.dbf datafile is missing.
9. Can we regenerate this datafile from archivelogs? Or what needs to be done so that on issuing the select I can get back all the three rows I inserted.
How about the same situation while the back up was done using RMAN?
Will anything change if the backup was hot backup instead of cold backup in step 1?