First, enable BCT (Block Change Tracking). For syntax, please refer to: http://dbaexpert.com/blog/?p=33
One time only to establish the baseline full database backup, you need to perform a level 0 backup of the database using the AS COPY syntax to the FRA:
backup incremental level 0 AS COPY tag DBATOOLS_backup_cp_full_102607 format ‘/u01/app/oracle/admin/DBATOOLS/bkups/%U’ (database);
backup AS COPY skip inaccessible format ‘/u01/app/oracle/admin/DBATOOLS/bkups/%U’ (archivelog all delete input) ;
Now, perform a level 1 incremental backup of the database and archivelogs. Please pay particular attention to the TAGs. It will serve as the essence to performing the merge:
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘DBATOOLS_backup_cp1_full_102607′ format ‘/u01/app/oracle/admin/DBATOOLS/bkups/%U’ DATABASE;
backup AS COPY skip inaccessible format ‘/u01/app/oracle/admin/DBATOOLS/bkups/%U’ (archivelog all delete input) ;
The level 1 backup from the previous night will be merged with the level 0 backup using the TAG syntax prior to performing the new level 1 backup:
recover copy of database with tag ‘DBATOOLS_backup_cp1_full_102607′;
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘DBATOOLS_backup_cp1_full_102707′ DATABASE;
backup AS COPY skip inaccessible (archivelog all delete input) ;
Posted by Charles Kim @ DBAExpert.com