Last modified on 5 April 2013, at 05:56

RAC Attack - Oracle Cluster Database at Home/Database Backups


We will configure backups to take full advantage of the cluster by running in parallel.



  1. Configure the RMAN default channels and parallelism.

    RMAN> configure device type disk parallelism 2 backup type to compressed backupset;
    RMAN> configure channel 1 device type disk connect 'sys/racattack@rac1';
    RMAN> configure channel 2 device type disk connect 'sys/racattack@rac2';
    RMAN> show all;
    


  2. Take a complete hot backup of the entire database.

    RMAN> backup database plus archivelog;
     
    Starting backup at 04-MAY-09
    current log archived
    channel ORA_DISK_1: starting compressed archived log backup set
    channel ORA_DISK_2: starting compressed archived log backup set
    ...
    Finished backup at 04-MAY-09
     
    Starting backup at 04-MAY-09
    channel ORA_DISK_1: starting compressed full datafile backup set
    channel ORA_DISK_2: starting compressed full datafile backup set
    ...
    Finished backup at 04-MAY-09
     
    Starting backup at 04-MAY-09
    current log archived
    channel ORA_DISK_1: starting compressed archived log backup set
    channel ORA_DISK_2: starting compressed archived log backup set
    ...
    Finished backup at 04-MAY-09
    


  3. Crosscheck the backup. What happens and why?

    RMAN> list backupset summary;
    Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed 
    ------- -- -- - ----------- --------------- ------- ------- ---------- 
    1       B  A  A DISK        04-MAY-09       1       1       YES
    2       B  A  A DISK        04-MAY-09       1       1       YES
    3       B  A  A DISK        04-MAY-09       1       1       YES
    4       B  A  A DISK        04-MAY-09       1       1       YES
    5       B  F  A DISK        04-MAY-09       1       1       YES
    6       B  F  A DISK        04-MAY-09       1       1       YES
    7       B  F  A DISK        04-MAY-09       1       1       YES
    8       B  F  A DISK        04-MAY-09       1       1       YES
    9       B  A  A DISK        04-MAY-09       1       1       YES
    10      B  A  A DISK        04-MAY-09       1       1       YES
     
    RMAN> allocate channel for maintenance device type disk;
     
    released channel: ORA_DISK_1
    released channel: ORA_DISK_2
    allocated channel: ORA_MAINT_DISK_1
    channel ORA_MAINT_DISK_1: SID=111 instance=RAC1 device type=DISK
     
    RMAN> crosscheck backup;
    RMAN> list backupset summary;