Re: Oracle: how to demonstrate successful restore?

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 25 Jan 2006 11:19:45 -0800
Message-ID: <1138216785.401161.123210@g44g2000cwa.googlegroups.com>

There are many ways to do this, it depends on what you are trying to test. Just being able to open the database is one measure!

Here is an example of a very simple restore test for an incomplete recovery:
Database is running in archivelog mode.
1) Perform backup of database
2) Update test table with sysdate (make sure to record the exact date including minutes/seconds) and commit

3) Wait a certain number of minutes
4) Record sysdate
5) Update test table with new sysdate and commit
6) Shutdown database
7) Restore backups and roll forward to sysdate in step 4
8) Query test table and make sure the last updated date is the value in

step 2 and not the value in step 5

For a complete recovery, verify that the test table has a last updated date found in step 5.

Regards,
Daniel Fink Received on Wed Jan 25 2006 - 13:19:45 CST