列出所有的备份表空间
list backup of tablespace tablespace_name;
列出过期所有过期备份
list expired backup;
列出所有备份归档文件
list archivelog all;
delele
删除所有过旧的备份
delete noprompt obsolete;
删除过期备份
delete noprompt expired backup;
上面命令物理备份文件被删除通过下面检查备份是否可用
corsscheck backup;
删除所有过期归档
delete expired archivelog all;
删除指定60天后归档
delete archivelog all completed before 'sysdate-60’；
crosscheck backup of archivelog all;
crosscheck backup of controlfile 核对控制文件的备份集;
crosscheck backup of spfile 核对SPFILE的备份集;
--------------------------------------推荐阅读 --------------------------------------
--------------------------------------分割线 --------------------------------------