Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backup/Restore Testing Regimen

453674Mar 26 2012 — edited Mar 26 2012
I am coming up with a list of scenarios to test our backups. Here are the scenarios that I can come up with. Can you guys think of more?

1. Whole database restore to current
2. whole database restore to point in time
3. missing datafile
4. missing control file
5. restore dropped table to current
6. restore dropped table to point in time


Also, I plan to test back ups as often as I can but of course this will depend on the workload one has, but how often do you guys think recovery tests should happen? monthly? quarterly?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2012
Added on Mar 26 2012
2 comments
447 views