清除归档⽇志
1.⽤RMAN连接⽬标DB:
rman target /
RMAN target sys/*****@orcl
2.在RMAN命令窗⼝中,输⼊如下命令(清理所有的归档⽇志):
怀疑拼音 crosscheck archivelog all;
delete expired archivelog all;
或者清理指定时间之前的⽇志(archivelog):
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';(指定删除7天前的归档⽇志); 或者直接如下:
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;