oracle 增量备份脚本

    OS :RHEL AS 4 oracle 10g

    0备份脚本
    #!/bin/bash
    # incremental level 0 backup script

    source /home/oracle/.bash_profile

    current_day=`date +%Y%m%d`
    mkdir /home/oracle/RMANBACKUP/$current_day
    rman target  / <<EOF
    run
    {
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$current_day/PID-%F';
    allocate channel dev1 type disk;
    allocate channel dev2 type disk;
    allocate channel dev3 type disk;
    backup incremental level 0 tag='db0'
    format '/home/oracle/RMANBACKUP/$current_day/%n_%T_%U' database;
    sql 'alter system archive log current';
    backup archivelog all format '/home/oracle/RMANBACKUP/$current_day/arc_%n_%T_%U' delete all input;
    release channel dev1;
    release channel dev2;
    release channel dev3;
    }
    EOF

    1级累积增量脚本
    #!/bin/bash
    # incremental level 1 backup script

    source /home/oracle/.bash_profile

    current_day=`date +%Y%m%d`
    incr_day=incr$current_day
    mkdir /home/oracle/RMANBACKUP/$incr_day
    rman target  / <<EOF
    run
    {
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$incr_day/PID-%F';
    allocate channel dev1 type disk;
    allocate channel dev2 type disk;
    allocate channel dev3 type disk;
    backup incremental level 1 cumulative tag='db1'
    format '/home/oracle/RMANBACKUP/$incr_day/%n_%T_%U' database;
    sql 'alter system archive log current';
    backup archivelog all format '/home/oracle/RMANBACKUP/$incr_day/arc_%n_%T_%U' delete all input;
    release channel dev1;
    release channel dev2;
    release channel dev3;
    }
    EOF

    每天RMAN出来的backup set集合到一个文件夹下面