As part of the SOX requirements do any of you have standards for testing your DB restores? Obviously some of you are government and health care have some different requirements. But how often do the rest of you test your DB restores and do you have this scheduled yearly or quarterly? We perform offsite DR testing once a year for our two critical systems and go live with our systems from our offsite location. But for our other systems I only get a chance to test them when we perform Oracle upgrades and hardware upgrades. Just wanted to get some ideas or suggestions. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How often to test DB restores??
- Thread starter OHWS
- Start date
i have a cronjob that runs few times each morn, that manually backups the NBU catalog to disk on a separate server. As for user databases we restore whole databases quite frequently as we have to use tapes to refresh our test boxes due to our SAN/Flashsnap processes taking too long to shift data round/resynch etc. But we would still restore the odd database every few months just for peace of mind
Rich
Rich
- Status
Similar threads
- Locked
- Question