Linux-Unix shell 脚本清除归档日志文件.docx

Linux/Unixshell脚本清除归档日志文件
作者：robinson_0612
对于DEV以及UAT环境，有些时候，数据库需要处于归档模式，但并不需要备份数据库。因此，archive归档日志不停的增长导致磁盘空间被大量耗用。对于这种情形，可以使用一个shell脚本来定时自动清除这些归档日志。本文给出了清除归档日志的脚本。

1、清除归档日志shell脚本
[python]HYPERLINK"http://blog.csdn.net/robinson_0612/article/details/8802803"\o"viewplain"viewplainHYPERLINK"http://blog.csdn.net/robinson_0612/article/details/8802803"\o"copy"copyHYPERLINK"http://blog.csdn.net/robinson_0612/article/details/8802803"\o"print"printHYPERLINK"http://blog.csdn.net/robinson_0612/article/details/8802803"\o"?"?
robin@SZDB:~/dba_scripts/custom/bin>moreremove_arch_dump.sh
#!/bin/bash
#------------------------------------------------------------+
#FileName:remove_arch_dump.sh|
#Desc:|
#Removeoldarchivedloganddatapumpfile|
#Usage:|
#./remove_arch_dump.sh|
#|
#Authror:Robinson|
#Blog:http://blog.csdn.net/robinson_0612|
#------------------------------------------------------------+

filename=/etc/oratab

cat$filename|whilereadLINE
do
case$LINEin
\#*);;#comment-lineinoratab
*)
ORACLE_SID=`echo$LINE|awk-F:'{print$1}'-`
echo$ORACLE_SID

#---------------------------------
#definearchivedlogdirectory
#---------------------------------
dir=/u02/database/$ORACLE_SID/archive/
echo$dir

filelist=`ls-t$dir`
echo$filelist

#----------------------------------------------------------
#starttoremovearchivedlogandkeeplast2archivedlog
#----------------------------------------------------------
count=0
forfilenamein$filelist
do
echo$filename
count=$(($count+1))
if[$count-gt2];then
echo$count
rm-vrf$dir$filename
fi
done
ls-tr$dir

#--------------------------------
#definedatapumpdumpdirectory
#--------------------------------
dir=/u02/database/$ORACLE_SID/BNR/dump/
echo$dir

filelist=`ls-t$dir`
echo$filelist

#---------------------------------------------------------
#starttoremovedatapumpfileandkeeplast5dumpfile
#---------------------------------------------------------
count=0
forfilenamein$filelist
do
echo$filename
count=$(($count+1))
if[$count-gt5];then
echo$count
rm-vr