Oracle 11g Data Guard 备库归档日志清理脚本(保留一周归档)

谁践踏了优雅 2024-04-17 23:52 69阅读 0赞

\#!/bin/sh  
\#clean archived log  
\#author jiadingyi  
\#version 1.0 2015/11/04  
\#设置数据库环境变量  
TMP=/tmp  
export TMP  
TMPDIR=$TMP  
export TMPDIR  
ORACLE\_BASE=/u01/app/oracle  
export ORACLE\_BASE  
ORACLE\_HOME=$ORACLE\_BASE/product/11.2.0/db\_1  
export ORACLE\_HOME  
ORACLE\_SID=gtfdb  
export ORACLE\_SID  
ORACLE\_UNQNAME=gtfdbdg  
export ORACLE\_UNQNAME  
ORACLE\_TERM=xterm  
export ORACLE\_TERM  
PATH=$ORACLE\_HOME/bin:/usr/sbin:$PATH  
export PATH  
LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:/lib:/usr/lib  
export LD\_LIBRARY\_PATH  
CLASSPATH=$ORACLE\_HOME/JRE:$ORACLE\_HOME/jlib:$ORACLE\_HOME/rdbms/jlib:$CLASSPATH  
export CLASSPATH  
NLS\_DATE\_FORMAT="yyyy-mm-dd HH24:MI:SS"  
export NLS\_DATE\_FORMAT  
NLS\_LANG=AMERICAN\_AMERICA.ZHS16GBK  
export NLS\_LANG  
  
now=\`date +%Y%m%d\`  
Gap=\`sqlplus -silent "/ as sysdba" << EOF   
set pagesize 0 feedback off verify off heading off echo off  
select count(\*) from v\\\\\\$archive\_gap;  
exit;\`  
Arc\_applied=\`sqlplus -silent "/ as sysdba" << EOF   
set pagesize 0 feedback off verify off heading off echo off  
select count(\*) from v\\\\\\$archived\_log where applied='NO';  
exit;\`  
\#check the archive log applicance and the gap information  
if \[ $Gap -eq 0 \] && \[ $Arc\_applied -eq 0  \]  
then  
rman target / log=/home/oracle/log/$now.log << EOF  
delete noprompt archivelog until time 'sysdate-7';  
exit  
EOF  
else  
echo "Please check the archivelog appliance error.." >> /home/oracle/log/error\_$now.log  
\#sendmail  
\#mail -s "subject" jiadingyi@xxx.com < /home/oracle/log/$now.log  
fi

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2050904/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2050904/