Quick And Dirty Backup and Recovery Test Procedure

Posted by Vasudev Seeram on April 21, 2005 Leave a comment (0) Go to comments

Step 1. Shutdown the TEST instance:

./oratest/scripts/stopTEST.sh

Step 2. Backup the directory /oratest/oracle and all it subdirectories.

Step 3. Rename the directory /oratest/oracle to /oratest/oracle_backup

Step 4. Restore from backup /oratest/oracle

Step 5. Verify Recovery by Comparing file sizes between oracle and oracle_backup

Step 6. Start the TEST instance:

./oratest/scripts/startTEST.sh

Step 7. Log on to TEST instance and TEST functionality.

Step 8. Remove directory /oratest/oracle_backup

TriniDBA