crosscheck archivelog all; —>校验日志的可用性
list expired archivelog all; —>列出所有失效的归档日志
delete archivelog until sequence 16; —>删除log sequence为16及16之前的所有归档日志
delete archivelog all completed before ‘sysdate-7’; —>删除系统时间7天以前的归档日志,不会删除闪回区有效的归档日志
delete archivelog all completed before ‘sysdate – 1’; —>同上,1天以前的
delete archivelog from time ‘sysdate-1’; —>注意这个命令,删除系统时间1天以内到现在的归档日志
delete noprompt archivelog all completed before ‘sysdate’; —>该命令清除所有的归档日志
delete noprompt archivelog all; —>同上一命令
范例:
robin@SZDB:~> export ORACLE_SID=GOBO1
robin@SZDB:~> rman target /