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