RMAN Incremental Backup tips

Original article address:RMAN Incremental Backup tips

Incremental Backup greatly reduces the cost of Oracle backup time, but this mechanism may be cumbersome

In versions 10 GB and later, you can use the Incremental backup of RMAN to roll the image copy of data files to the specified time point. This new feature provides the following benefits:

① use Incremental backup to regularly update the image copy of the data file, and the updated image will be rolled to an updated status (that is, the latest SCN) before the update) this may reduce the recovery time
② After Incremental backup and when Incremental backup is used again, it will avoid another full backup
use the following statement to roll forward copy an image of a data file:
u01/APP/Oracle/backup/GRID/data01.imgcopy:
RMAN> recover datafilecopy '/u01/APP/Oracle/backup/GRID/data15.imgcopy ';
or the equivalent command is as follows:
RMAN> recovery copy of datafile 15;
when Incremental backup is used, we need a mechanism to bypass unchanged blocks. For a common tablespace, insert operations will insert new blocks. the "Hotspot" Area of the data file
block change tracking can maximize the benefits of Incremental backup, use the append prompt during insert, or use a lower pctused value for the table/index. to ensure that all new rows are inserted to the new block
This reduces maintenance costs, because the block change tracking mechanism only needs to track new blocks
simple block change tracking syntax:
alter database enable block change tracking using file OS _file_name;