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;
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