DG-在主庫/備庫刪除已經應用過的日誌.txt

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