oracle rman bct block change tracking - ghdrako/doc_snipets GitHub Wiki

Oracle offers faster incremental backups through its BCT feature. When BCT is enabled, each modified data block is recorded in a binary file outside the database. RMAN refers to the file to identify the data blocks that are candidates for incremental backups, which improves the overall time required for incremental backup.

Enable BTC

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
-- or create and maintain the BCT file in a specific location,
SQL> ALTER DATABASE BLOCK CHANGE TRACKING USING FILE '<location/filename>';

Once BCT is enabled, initiate a full database backup before an incremental backup is performed.is really important to have a valid full database level 0 backup before executing an incremental level 1 backup with BCT.

After we can do cumulative incremental buckap

# RMAN daily cumulative incremental database online backups
RMAN> run
{
    allocate channel ch1 type 'SBT_TAPE';
    BACKUP
       INCREMENTAL LEVEL=1 CUMULATIVE
       FORMAT 'bk_u%u_s%s_p%p_t%t'
       DATABASE PLUS ARCHIVELOG;
    release channel ch1;
}