Oracle rman 常用命令

--列出备份信息
list backup of database;
list backup of archivelog all;
list backup of controlfile;
list backup of spfile;

--检查删除失效的备份
crosscheck backup;
delete expired backup;

--报告删除过期的备份
report obsolete;                               
delete obsolete;

--报告需要备份的文件
report need backup;

--validate验证
validate backupset 1;                   --检查备份集1是否可用
restore ... validate
    restore tablespace users validate;    --确认是否可以从备份集还原
resotre ... preview
    restore database preview;             --确定某个特定复原操作必须的所有备份文件

--确认需要恢复哪些数据文件
select file#, error, online_status, change#, time
from v$recover_file;

select r.file# as df#, d.name as df_name, t.name as tbsp_name,
d.status, r.error, r.change#, r.time
from v$recover_file r, v$datafile d, v$tablespace t
where t.ts#=d.ts#
and d.file#=r.file#;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27633655/viewspace-1080624/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27633655/viewspace-1080624/