Q

Testing production database recovery

This Content Component encountered an error
I'm quite new to Oracle and I have a question regarding backup and recovery. I hear, from lots of sources, that you must test your backups regularly because you may not be able to recover due to some problems. I understand that I can practice recovering from different scenarios in my test system, but how can I test the recovery part on a production database? Wouldn't this infringe on the business?
Unless your business can schedule a time to do production testing of disaster recovery, then you'll have to be satisfied with testing your process on a test system. You should be able to take all your production backups and restore them to test without problem. If your business is not 24x7 or if you can somehow create a time (even if it's just once a year) to do a full-scale test on your production system, that is optimal. Otherwise, you're doing all you can by periodically running recovery scenarios on your test system.
This was first published in October 2003

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close