Database Backup and Recovery (MOSC)

MOSC Banner

Block change tracking with recoverable copy of database

Hi, I've read that bock change tracking can only contain 8 bitmaps, so after a level 0 backup i can only have 7 incremental backups, after that the first bitmap corresponding to level 0 is overwritten.

What happens when you use the oracle recomended backup strategy, for instance:

RUN {

 ALLOCATE CHANNEL disk_iub DEVICE TYPE DISK;

 RECOVER COPY OF DATABASE WITH TAG daily_iub;

 BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY DATAFILECOPY FORMAT '/home/oracle/bkp/database/%b' WITH TAG daily_iub DATABASE FORMAT '/home/oracle/bkp/backupset/%T%U';

 RELEASE CHANNEL disk_iub;

}

Everyday we take a level 1 backup, so we are going to overwrite the level 0. Is that correct? or when you do the recover is like taking a new level 0 and that creates a new bitmap?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center