Oracle Rman备份之全库备份

某客户生产库全库备份脚本如下:

************************
备份时长设置
************************
rman target / 
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

--此处设置窗口保留期为7天,即默认7天以前的数据可以认为是过期的。但是冗余策略保留为1个,也就是可以保留一个有效备份。感觉这里有点冲突,还需进一步测试!
************************ 数据库全备 ************************ DBNAME=deepblue2 BACTIME=`date +%Y%m%d%I%M` BACPATH=/rman LOGNAME=''$DBNAME'_'$BACTIME'_FULL.log' export ORACLE_SID=$DBNAME export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH rman log="$BACPATH/log/$LOGNAME" append
<<EOF connect target /; run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate channel c4 type disk; backup incremental level=0 database format '${BACPATH}/backup/${DBNAME}_ful_%U'; sql 'alter system archive log current'; backup archivelog all format '${BACPATH}/backup/${DBNAME}_arc_%U'; backup current controlfile format '${BACPATH}/backup/${DBNAME}_ctl_%U'; backup spfile format '${BACPATH}/backup/${DBNAME}_spf_%U'; release channel c1; release channel c2; release channel c3; release channel c4; } crosscheck archivelog all; crosscheck backupset; delete noprompt obsolete; delete noprompt expired backup; delete noprompt archivelog all completed before 'sysdate-3'; delete force noprompt archivelog all completed before 'sysdate-7'; list backup summary; EOF * 22 * * * sh /rman/rman_backup.sh 0

 

posted @ 2018-07-18 19:55  dayu.liu  阅读(3368)  评论(0编辑  收藏  举报