Wednesday, November 7, 2007

Scenarios (My topics at Oracle Forums)

My database in ArchiveLog Mode and I created a table TEST, Later I made the whole database backup (RMAN Full DB backup). After that, I deleted the table TEST, and restored from full database backup. Surprisingly, there wasn't table TEST. Why?

Read at oracle forums, and how experts helped me in recovering TEST table.


Recovering dropped table from Backup. (User Managed Backup & Recovery)

Lost all Online Redo Log Files.

Loss of one data file and all controlfile
So If datafile and all controlfiles are lost, then we can recover the controlfile and database though we can not recover the lost datafile. ( HOT BACKUP Scenario)

(To be Continued)