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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.