rac+dg環境刪除歸檔日誌

--rac節點使用
--建立指令碼dellog.sql，此處，時間可以根據實際情況自行修改，有些醫院的歸檔日誌為dbf，可以修改；
conn sys/aqa@standby as sysdba
set feedback off;
set pagesize 0;
set heading off;
set verify off;
set linesize 200;
set trimspool on;
spool /archivelog/dellog/dellog.bat
select 'rm -rf /archivelog/ARC'||thread#||'_'||sequence#||'_'||resetlogs_id||'.arc',completion_time
 from v$archived_log where applied='YES' and completion_time spool off;
exit;

--建立指令碼dellog
#!/bin/bash
rm -rf /archivelog/dellog/dellog.bat
find /archivelog/ -mtime +10 -name '*.arc' -exec  rm -rf {} \;
su - oracle -c '/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus "/nolog" @/archivelog/dellog/dellog.sql';
chmod +x /archivelog/dellog/dellog.bat
/archivelog/dellog/dellog.bat

--crontab -e中新增自動執行計劃
0 23 * * * /archivelog/dellog/dellog

——————————————————————————————————————————
--dg使用
--建立指令碼dellog.sql，時間自行修改；
conn sys/aqa@standby as sysdba
set feedback off;
set pagesize 0;
set heading off;
set verify off;
set linesize 200;
set trimspool on;
spool /archivelog/dellog/dellog.bat
select 'rm -rf /archivelog/ARC'||thread#||'_'||sequence#||'_'||resetlogs_id||'.arc',completion_time
 from v$archived_log where applied='YES' and completion_time spool off;
exit;

--建立指令碼dellog
#!/bin/bash
rm -rf /archivelog/dellog/dellog.bat
find /archivelog/ -mtime +7 -name '*.arc' -exec  rm -rf {} \;
su - oracle -c '/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus "/nolog" @/archivelog/dellog/dellog.sql';
chmod +x /archivelog/dellog/dellog.bat
/archivelog/dellog/dellog.bat

--crontab -e中新增自動執行計劃
0 23 * * * /archivelog/dellog/dellog

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29313387/viewspace-776257/，如需轉載，請註明出處，否則將追究法律責任。