使用hpux crontab作业job定时清除oracle归档

BWPRD1:/oracle/BWP/oraarch#cd /oracle/BWP/monitor

BWPRD1:/oracle/BWP/monitor#ll

total 28

-rw-r--r--   1 orabwp     dba           2056 May 22  2015 alerttbs.sql

-rw-r--r--   1 orabwp     dba            407 Jul 16 17:49 create_status.sql

-rwxr-xr-x   1 orabwp     dba           1219 Jul 17 20:35 jk_file_tbs.sh

-rwxr-xr-x   1 orabwp     dba            914 Jun 19  2015 jk_os_state.sh

-rwxr-xr-x   1 orabwp     dba           1914 May 26  2015 monitor.sh

-rw-r--r--   1 orabwp     dba             80 Dec 30 18:10 rman.sh

-rw-r--r--   1 orabwp     dba             81 Dec 30 22:41 rman.sql

-rw-r-----   1 orabwp     dba           2321 Jul 15 19:14 tbs.sql

BWPRD1:/oracle/BWP/monitor#more rman.sh

. /etc/profile

. ~/.profile

 

rman target / cmdfile=/oracle/BWP/monitor/rman.sql

BWPRD1:/oracle/BWP/monitor#

BWPRD1:/oracle/BWP/monitor#more rman.sql

crosscheck archivelog all;

delete noprompt archivelog until time 'sysdate-0.04';

BWPRD1:/oracle/BWP/monitor#

BWPRD1:/oracle/BWP/monitor#

 

 

查看orabwp的定时作业:

BWPRD1:orabwp 6> crontab -l

0 * * * * /oracle/BWP/monitor/jk_file_tbs.sh >/dev/null 2>&1

0,10,20,30,40,50 * * * * /oracle/BWP/monitor/jk_os_state.sh >/dev/null 2>&1

1 * * * * /oracle/BWP/monitor/rman.sh

请使用浏览器的分享功能分享到微信等