oracle rac rman 批量删除归档日志脚本

在oracle目录下面/home/oracle建立delete_archive_log.sh，然后在linux下面做定时任务。

delete_archive_log.sh内容如下：

#!/bin/bash

 

oracle_sid=sjzxdb

oracle_home="/oracle/product/11.2/dbhome_1"

 

#ps -ef | grep oracle | grep -w "ora_lgwr_${oracle_sid}" >& /dev/null

#if [ $? -ne 0 ]

#then

#    exit 0

#fi

#source $HOME/.bash_profile ## 必须有oracle的环境变量，否则会提示##Message file RMAN<lang>.msb not found

##Verify that ORACLE_HOME is set properly

 

##${oracle_home}/bin/rman 必须时全路径的否则，会报不认识RMAN这个命#令

/oracle/product/11.2/dbhome_1/bin/rman target sys/oracle@sjzxdb  << EOF

crosscheck archivelog all;

#delete noprompt obsolete;

delete noprompt expired archivelog all;

delete noprompt archivelog until time 'sysdate-7';

exit;

EOF

更多文章请点击熊猫TEAM