omscripts_db_97_delete_dg_archive.sh

omscripts_db_97_delete_dg_archive.sh

下載

#!/bin/bash

PATH=$PATH:$HOME/bin

TIMESTR=`date +%Y%m%d_%H:%M:%S`

. ~/.bash_profile

DIR1=/opt/oracle/product/diag/rdbms/trace

ARCH_DIR=/data/arch

#take the log number to be applied

LogNo=`tail -30000 ${DIR1}/alert* | grep "Media Recovery Log" | cut -d " " -f 4 | cut -d "_" -f 2 | tail -1 `

echo "Oracle applied LogNo is $LogNo"

#extract 10

let SecLogNo=${LogNo}-10

echo "new backlog log No: $SecLogNo"

#delete small numbers from this in arch dir

cd $ARCH_DIR

for i in `ls *.dbf`

do

Newi=`echo $i | cut -d "_" -f 2`

if [ $Newi -lt $SecLogNo ] ; then

echo "$i to be deleted...">> /home/oracle/h_ar.log

rm $i

fi

done