Oracle 全库备份脚本

connect target 备份用户名/口令@KFDB2;
connect rcvcat rman/rman@rman;


RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=jcyz01,NSR_CLIENT=nmkfdb2,NSR_DATA_VOLUME_POOL=NMKFDB,NSR_COMPRESSION=TRUE,NSR_SAVESET_BROWSE="2Weeks",NSR_SAVESET_RETENTION="2Weeks",NSR_GROUP=nmkf_oracle_full)';


BACKUP
    incremental level 0
    FILESPERSET 4 
    FORMAT 'dbfull_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';


RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;




ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=jcyz01,NSR_CLIENT=nmkfdb2,NSR_DATA_VOLUME_POOL=NMKFDB,NSR_COMPRESSION=TRUE,NSR_SAVESET_BROWSE="2Weeks",NSR_SAVESET_RETENTION="2Weeks",NSR_GROUP=nmkf_oracle_full)';


BACKUP
  FORMAT 'cntrl_%s_%p_%t'
  CURRENT CONTROLFILE;


RELEASE CHANNEL ch00;


ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' connect '备份用户名/口令@KFDB1';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' connect '备份用户名/口令@KFDB2';


send 'NSR_ENV=(NSR_SERVER=jcyz01,NSR_DATA_VOLUME_POOL=NMKFDB1,NSR_COMPRESSION=TRUE,NSR_SAVESET_BROWSE="2Weeks",NSR_SAVESET_RETENTION=
"2Weeks",NSR_GROUP=nmkf_oracle_arch)';


BACKUP
   filesperset 8
   FORMAT 'al_%s_%p_%t'
   ARCHIVELOG ALL delete input;


RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;


ALLOCATE CHANNEL D1 TYPE DISK;


copy current controlfile to '/app/nsr/RMAN_BAK/KFDB_ctl_full.bak';


RELEASE CHANNEL D1;

host '/app/networker/bin/save -s jcyz01 -b NMKFDB -w 2Weeks -y 2Weeks /app/nsr/RMAN_BAK/KFDB_ctl_full.bak';

}

转载请注明出处及原文链接：

http://blog.csdn.net/xiangsir/article/details/8570480