Improve RMAN backup speed in the production environment ---- start block tracking

Environment]
 
AIX (5300-08), Oracle10g (10.2.0.1.0-64bit)
 
[Goal]
 
Due to the large data volume in the production environment, we want to speed up rman backup.
 
[Method]
 
Start block tracking
 
Operation]
 
SQL> alter database enable block changetracking using file '/home/oracle/block. trc ';
 
Database altered.
 
SQL> select filename fromv $ block_change_tracking;
 
FILENAME
 
--------------------------------------------------------------------------------
 
/Home/oracle/block. trc
 
---- If you want to disable block tracing, execute the command
 
SQL> alter database disable block changetracking;
 
[Description]
 
Because Incremental backup is performed on the site, the database will query which data blocks have changed each time the Incremental backup is performed. Before oracle10g, all blocks are scanned, that is, all blocks are scanned before each Incremental backup. Scan all the blocks to find out which data blocks have changed. Because there are many large data files on the site, it will take a long time. After oracle10g, the block tracking technology is added. If a block changes, it will write the changed information to a log. In this way, when performing Incremental backup, by directly reading the log, you can find out which blocks have changed, avoiding full block scanning, thus effectively saving time consumption. The disadvantage is that some resources are consumed, but the backup speed is greatly improved, which is less than the resource consumption. Therefore, block tracking policies can be used.

-------------------------------------- Recommended reading --------------------------------------

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------