oracle 删除standby_log,asm下如何自动删除standby上已经applied过的归档日志

由于是asm，所以和文件系统处理起来可能还不太一样，这要完全依赖rman了，不能依赖os了，当然我的这些脚本适合db是文件系统。[@more@]

首先先写了一个脚本purge_archlog_sql_.sh,内容如下：

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/product/11.1.0/db_1

ORACLE_SID=lnmsadg

export ORACLE_BASE ORACLE_HOME ORACLE_SID

applied_days=3

cat /dev/null>applied_arch.lst

chmod +x applied_arch.lst

sqlplus -s "/ as sysdba"

set feedback off

set pages 0

set head off

set timing off

set echo off

spool applied_arch.lst

select 'run{' from dual;

select 'delete noprompt archivelog sequence '||sequence#||' ;' from v$archived_log where DEST_ID=1 and name like '%.dbf' and status='A'

and SEQUENCE#and COMPLETION_TIME<=sysdate-${applied_days}

order by COMPLETION_TIME;

select '}' from dual;

spool off;

exit

EOF

--================================

以上脚本用来生成文件applied_arch.lst，applied_arch.lst的内容就是rman要调用的删除归档日志的脚本，内容大致如下：

$ more applied_arch.lst

run{

delete noprompt archivelog sequence 14254 ;

delete noprompt archivelog sequence 14255 ;

delete noprompt archivelog sequence 14256 ;

delete noprompt archivelog sequence 14257 ;

delete noprompt archivelog sequence 14258 ;

..................

delete noprompt archivelog sequence 14268 ;

delete noprompt archivelog sequence 14269 ;

delete noprompt archivelog sequence 14270 ;

delete noprompt archivelog sequence 14271 ;

delete noprompt archivelog sequence 14272 ;

delete noprompt archivelog sequence 14273 ;

}

--===============================

最后在脚本purge_archlog.sh里调用就可以了，purge_archlog.sh的内容如下：

$ more purge_archlog.sh

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

export ORACLE_BASE=/oracle

export ORACLE_HOME=/oracle/product/11.1.0/db_1

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=lnmsadg

rman target / cmdfile='/home/oracle/purge_archlog/applied_arch.lst' log='/home/o

racle/purge_archlog/purge_archlog.log' append

最后通过crontab自动执行就可以了，crontab -l的结果如下：

$ crontab -l

10 22 * * * purge_archlog_sql.sh >/dev/null 2>&1

20 22 * * * purge_archlog.sh >/dev/null 2>&1

$