If we had a tablespace, TEST_TABLESPACE, which consists of three files: TEST1.dbf, TEST2.dbf and TEST3.dbf, and someone accidentally used the Unix command "rm" to delte the file TEST2.dbf, what else would you need inorder to recover all the data that was present in TEST_TABLESPACE at the time that TEST2.dbf was deleted ? Thank you in advance.
asked Jan 06 '10 at 10:30 AM in Default
That would put you in a recovery situation.
The first thing you would do is fire the person who removed the file :)
What you would do next would be based on your backup/recovery plan. Do you have one?
Do you take weekly offline backups, or do you take daily incremental ones?
Hopefully you're running in ARCHIVE LOG mode, if not, you're going to lose all of the changes made to that file since your last backup.
answered Jan 06 '10 at 11:08 AM