oracle归档日志定时清理,Linux的定时清理oracle归档日志文件及脚本

Linux的定时清理oracle归档日志文件及脚本

定时crontab

够执行。

该定时任务并能生成rman的日志文件。该文件是清理超过5天的archivelog文件

定时清理oracle数据库的archivelog文件

#rman_del_arch.sh

#liul21cn@http://www.doczj.com/doc/dd3f76781711cc7931b7162f.html

#!/bin/sh

#. $HOME/.bash_profile

. /home/oracle/.bash_profile

echo "--------------------------------------------"

echo "Begin database Delete Archivelog ......"

echo "Begin time:"`date`

back_path="/datavg/oracle_area/rman_data_bak";

back_log="/datavg/oracle_area/rman_data_bak/log";

#rman_name="rman"

#rman_pw="rman";

#rman_log_name="racdb";

#rman_log_pass="racdb";

#rman_sid="gmmdb";

rman_bin=/opt/app/oracle/product/10.2.0/db_1/bin/rman

rman target / nocatalog log=$back_log/del_arch_`date +%Y-%m-%d`.log << !EOF

run {

allocate channel ch_rac11 device type disk maxpiecesize 2G connect 'sys/oracle@gmmdb' ;

delete noprompt archivelog until time 'sysdate-5';

release channel ch_rac11 ;

}

crosscheck backup;