你好,游客 登录 注册 搜索
背景:
阅读新闻

Oracle 10g rac standby 归档日志自动删除脚本

[日期:2013-05-06] 来源:Linux社区  作者:calvin_kang [字体: ]

Oracle 10g rac standby 归档日志自动删除脚本

#!/bin/bash
export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
export ORACLE_SID=standby1
export ARCHIVE_DIR=/log/archivelog
export LOG_FILE=/home/oracle/logs/del_archive.log

if [ ! $1 ]
then
    sn=200
else
    sn=$1
fi

echo "begin delete archivelog: `date`.......">>$LOG_FILE
if [ `whoami` != 'oracle' ]
then
echo "Error: You must be oracle to execute.">>$LOG_FILE
exit 99
fi

echo "delete archivelog thread 1">>$LOG_FILE
del_seq=`ls -tr $ARCHIVE_DIR/|grep -v stdarch |grep arch_1 | head -1|cut -f3 -d_`
$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" <<XFF>/home/oracle/logs/tmp1.log
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\$ARCHIVED_LOG where THREAD#=1 and APPLIED='YES';
exit;
XFF
max_sn=`cat /home/oracle/logs/tmp1.log`
rm /home/oracle/logs/tmp1.log -f
max_sn=$(( $max_sn - $sn ))


while [[ ${del_seq} -lt ${max_sn} ]]
do
  echo "${ARCHIVE_DIR}/arch_1_${del_seq}_794450242.arc">>$LOG_FILE
  rm ${ARCHIVE_DIR}/arch_1_${del_seq}_794450242.arc -f
  del_seq=$(( $del_seq + 1 ))
done

echo "delete archivelog thread 2">>$LOG_FILE
del_seq=`ls -tr $ARCHIVE_DIR/|grep -v stdarch |grep arch_2 | head -1|cut -f3 -d_`
$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" <<XFF>/home/oracle/logs/tmp2.log
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\$ARCHIVED_LOG where THREAD#=2 and APPLIED='YES';
exit;
XFF
max_sn=`cat /home/oracle/logs/tmp2.log`
rm /home/oracle/logs/tmp2.log -f
max_sn=$(( $max_sn - $sn ))


while [[ ${del_seq} -lt ${max_sn} ]]
do
  echo "${ARCHIVE_DIR}/arch_2_${del_seq}_794450242.arc">>$LOG_FILE
  rm ${ARCHIVE_DIR}/arch_2_${del_seq}_794450242.arc -f
  del_seq=$(( $del_seq + 1 ))
done

echo "end delete archivelog: `date`....">>$LOG_FILE


$ORACLE_HOME/bin/rman target / <<EOF>>$LOG_FILE
crosscheck archivelog all;
delete noprompt expired archivelog all;
exit;
EOF

echo "....................................">>$LOG_FILE

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款