1.用RMAN链接目标DB:post
rman target /spa
RMAN target sys/*****@orcl日志
2.在RMAN命令窗口中,输入以下命令(清理全部的归档日志):blog
crosscheck archivelog all;get
delete expired archivelog all;class
或者清理指定时间以前的日志(archivelog):定时任务
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';(指定删除7天前的归档日志);di
或者直接以下:文件
RMAN target sys/*****@orcl;时间
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
=================================================================
RMAN target sys/*****@orcl
DELETE NOPROMPT ARCHIVELOG UNTIL TIME "TO_DATE('XXXX-XX-XX','YYYY-MM-DD')";
3.其它相关命令:
查看归档日志列表:
list archivelog all;
查看失效的归档日志列表:
list expired archivelog all;
4.按期清除archivelog:
能够将以下代码写成.bat文件,在控制面版的任务计划下添加新的定时任务:
RMAN target sys/*****@orcl
crosscheck archivelog all;
delete expired archivelog all;