Certification Completion
ORACLE BACKUP AND RECOVERY
WHAT IS BACKUP AND RECOVERY IN ORACLE · Backup Strategy - Whole DB backup - Partial DB backup · Backup Type - Full DB backup - Incremental DB Backup · Backup Mode - Online( Inconsistent ) DB backup - Offline ( Closed/Consistent ) DB Backup Consistent and Inconsistent Backups A consistent backup is one in which the files being backed up contain all changes up to the same system change number (SCN) . This means that the files in the backup contain all the data taken from a same point in time. Unlike an inconsistent backup, a consistent whole database backup does not require recovery after it is restored. The only way to make a consistent whole database backup is to shut down the database with the NORMAL , IMMEDIATE , or TRANSACTIONAL options and make the backup while the database is closed. The important point is that you can open the database after restoring a consistent who
Comments
Post a Comment
Welcome to the Oracle DBA Blog.
Stay Hungry Stay Foolish