Wednesday, 14 August 2013

What is Inconsistent Backup

A backup in which some of the files in the backup contain changes that were made after the files were checkpointed. This type of backup needs recovery before it can be made consistent. Inconsistent backups are usually created by taking online database backups; that is, the database is open while the files are being backed up. You can also make an inconsistent backup by backing up datafiles while a database is closed, either:
Immediately after an Oracle instance failed (or all instances in an Oracle Real
Application Clusters configuration)
After shutting down the database using SHUTDOWN ABORT
Note that inconsistent backups are only useful if the database is in ARCHIVELOG
mode.

No comments:

Post a Comment