Oracle 全库备份脚本

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

connect rcvcat rman/[email protected];

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