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

Do I need to back up the online redo log?

I am learning Oracle backup and recovery, and I am confused on whether to back up the online redo log file or not.

I am new to Oracle. While I am learning Oracle backup and recovery, I am confused on whether to back up the online redo log or not. Is there anyone who can explain to me for what kind of situation we need to back up the online redo log file? Or, if we don't need to back up the online redo log file at all, why? Any reply and assistance will be greatly appreciated.
You do not need to backup the online redo log under any circumstances. In fact, Oracle's RMAN utility does not backup the online redo logs no matter which backup you attempt. There are three primary reasons why you do not back these up (and if you do back them up, do not ever restore them). First, all information in the online redo logs will be found in the archived redo logs, eventually. Second, unlike hot backups of database data files, there is no mechanism in place to resolve any inconsistencies when backing up a live online redo log. The backup simply cannot be trusted. Three, the online redo logs should be multiplexed. If you lose one, you have another copy.

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