--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