#!/usr/bin/ksh

##环境变量
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=center
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

SHELL_DIR=/scripts
ARCHIVE_DIR=/u02/oradata/center/archive/standby

del_seq=`ls -tr $ARCHIVE_DIR/|head -1|cut -f2 -d_`

echo $del_seq

sqlplus / as sysdba <$SHELL_DIR/max_sn.log

set head off;

set feedback;

select max(sequence#) from v\$log_history;

exit;

eof

max_sn=`cat $SHELL_DIR/max_sn.log|awk '{print $1}'|grep ^[0-9]`

max_sn=`expr $max_sn - 20`

echo $max_sn

while [ $del_seq -lt $max_sn ]

do

rm $ARCHIVE_DIR/1_"$del_seq"_833387761.dbf

del_seq=`expr $del_seq + 1`

echo $del_seq

done

ITPub博客

物理standby库删除归档

最新文章