oracle 10g rac standby 归档日志自动删除脚本
首页 → 数据库技术
背景：
阅读新闻
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 /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 /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 / >$log_file
crosscheck archivelog all;
delete noprompt expired archivelog all;
exit;
eof
echo ....................................>>$log_file
0
rman备份报错message file rman.msb not found
oracle rac ssh等价性配置
相关资讯       oracle 10g rac
图片资讯
本文评论查看全部评论 (0)
评论声明
最新资讯
本周热门
linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
本站（linuxidc）所刊载文章不代表同意其说法或描述，仅为提供更多信息，，也不构成任何建议。
copyright © 2006-2011　linux公社　all rights reserved 浙icp备06018118号