Oracle Rman备份之全库备份

最新推荐文章于 2024-05-24 15:46:25 发布

山清水秀iOS

最新推荐文章于 2024-05-24 15:46:25 发布

阅读量230

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/dayu-liu/p/9332281.html

版权

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

************************
备份时长设置
************************
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

转载于:https://www.cnblogs.com/dayu-liu/p/9332281.html