ora9i,LINUXas3 ,DG归档日志管理,看书笔记,测试
[@more@]ORACLE_BASE=/SERVER/ora9;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/9.2;export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH
ORACLE_SID=ora9i; export ORACLE_SID
#delete archive log on STANDBY database which has been applied
grep "Media Recovery Log" $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log| awk '{print "rm -f ",$4}' >$ORACLE_BASE/rmarchlog.sh
cd $ORACLE_BASE/admin/$ORACLE_SID/bdump
cat alert_${ORACLE_SID}.log >>alert_${ORACLE_SID}.log.bak
echo ''>alert_${ORACLE_SID}.log
sh $ORACLE_BASE/rmarchlog.sh
#delete archive log on PRIMARY database which has been applied on standby database
scp -P 10088 $ORACLE_BASE/rmarchlog.sh 192.168.18.91:$ORACLE_BASE
ssh -p 10088 oracle@192.168.18.91
sh $ORACLE_BASE/rmarchlog.sh
exit
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/703656/viewspace-1001490/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/703656/viewspace-1001490/