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

Can we restore archive logs to a cold backup?

I would like to implement a backup strategy involving a nightly cold backup. I would also like to run the database during the day in archive log mode so that I will be able to recover my database up to the point of failure. There isn't much documentation on this. Is it possible to restore archive logs to a cold backup or is a hot backup necessary?

I would like to implement a backup strategy involving a nightly cold backup. The database doesn't need to be up at night. I would also like to run the database during the day in archive log mode so that I will be able to recover my database up to the point of failure (instead of last night's backup). There isn't much documentation on this. Is it possible to restore archive logs to a cold backup or is a hot backup necessary? If it is possible, would the recovery process work the same way?

Archive log mode is required for hot backups; however, hot backups are not required for databases running in Archivelog mode. You can still perform cold backups with a database running in Archivelog mode. These are not mutually exclusive.

When you restore datafiles from your backup (cold or hot), try not to restore the control files if at all possible. The control files contain the most current SCN along with information about the archived redo logs. This information can make rolling forward (the recovery process) much easier.

I would highly recommend looking at Oracle Backup & Recovery Handbook by Velpuri & Adkoli on Oracle Press. It has many recovery scenarios for you to practice such as the one above.

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