How do you verify the completeness of a restoration drill?
tsangsirOct 14 2010 — edited Oct 19 2010One responsibility of the DBA is to ensure the database backups are usable. Running the restore / recover commands in rman is easy. However, how would you verify the correctness of the restoration? Or do you believe that when rman says it's Ok and oracle merrily open the database, then it's OK? And how about point-in-time recovery (which seems even more difficult to verify)?
(Even though this is a generic question, here is the a database version if needed as basis of discussion:
Oracle: 10.2.0.4
OS: RHEL 4
)
Edited by: thtsang on Oct 15, 2010 11:06 AM