Q
Problem solve Get help with specific problems with your technologies, process and projects.

Using backup of standby database

I thought rather than shutting down my primary database for a cold backup, I'd do a backup of the standby database. Is that backup valid?

I have my databases on Oracle 10.1.0.2. I have maintained a standby database in another location using log transport service. I thought rather than shutting down my primary database for a cold backup, I'd do a backup of the standby database. Is that backup valid? If for that backup period there were no changes to the primary database? Thanks in advance.
The first thing I'd do is to change my backup to a hot backup. There is very little reason to perform a cold backup, especially in Oracle 10g. So you do not have to shut down your database to perform a backup.

You can shut down your standby database and back this up. Restoring this database would result in a restored standby database, but you could convert it to the primary if needed. As with any backup solution, you should also test your various recovery scenarios using this backup method to ensure that (1) it works for your situation and (2) you know how to recover when you do have a failure.

Dig Deeper on Oracle database backup and recovery

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close