With this new feature RMAN backups can be split into multiple pieces. Suppose you want to backup your system tablespace and spread the backups to three different backup locations. You can do so through the following query. RMAN> run { allocate channel c1 type disk format '/dest1/%U'; allocate channel c2 type disk format '/dest1/%U'; allocate channel c3 type disk format '/dest1/%U'; backup section size 200M tablespace system; } In the above query the backups of the system tablespace will be done to three different locations with backup chunks of 200M each. After backup you can find your datafile number for the tablespace system by using the following command: RMAN> report schema; Then the backups of a particular datafile can be checked by using the following command: RMAN> list backup of datafile 1;
Search This Blog
Monday, January 2, 2012
Oracle 11g Feature Multisection Backup.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment