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

Avoiding hot backup for online redo logs

Why does Oracle advise against backing up online redo logs with a hot backup?

Why does Oracle advise against backing up online redo logs with a hot backup?

The problem with hot backups is that the files being backed up are active and are being modified during the backup. This can result in the backup of that file being inconsistent. A method of resolving that inconsistency is needed in order to be able to use that file. If you are backing up an Oracle datafile, the backup copy can be inconsistent.

The method to resolve these inconsistencies is to use the redo information in the online redo logs and archived redo logs to reconstruct the inconsistent datafile. Unfortunately, there is no such mechanism to resolve any inconsistencies in the online redo logs. You can backup the online redo logs, but they can be inconsistent and should not be used for recovery.

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