Oracle RMAN脚本删除过期归档、保留最近7天归档

最新推荐文章于 2024-05-05 14:03:35 发布

z1blog

最新推荐文章于 2024-05-05 14:03:35 发布

阅读量543

点赞数 11

分类专栏：数据库管理员(DBA) 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_41824599/article/details/135662898

版权

数据库管理员(DBA) 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

mkdir -p /u01/app/oracle/backup/log
export ORACLE_SID=testdb
export ORACLE_BASE=/u01/app
export ORACLE_HOME=/u01/app/oracle
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
LOGDIR=/u01/app/oracle/backup/log
LOGFILE=${LOGDIR}/del_testdb_arch_`date +"%Y%m%d_%H%M%S"`.log

$ORACLE_HOME/bin/rman target / <<_EOF | tee -a ${LOGFILE}

        run {
            allocate channel c1 type disk;
                report schema;
                crosscheck backup of database;
                crosscheck backup of archivelog all;
                crosscheck backup of controlfile;
                crosscheck backup of spfile;
                crosscheck archivelog all;
            release channel c1;
        }
      run {
            allocate channel c1 type disk;
            delete noprompt force expired archivelog all;
            delete noprompt archivelog until time 'sysdate-7';
            release channel c1;
        }
exit;
_EOF