日期:2014-05-16  浏览次数:20603 次

Oracle RMAN相关验证备份
一.备份db并查看备份
  list backup summary;
二.验证备份
RMAN验证有三种方法
  1.validate
     valiate database;
	 valiate backupset;
	 validate archivelog all;
	 validate backupset 9;
	 validate datafile 1 block 10;
	 
  2.backup ... validate
     验证数据库和归档日志
	 backup validate check logical database archivelog all;
	 backup validate database archivelog all;
     验证数据文件
	 backup validate datafile 6;
	 


  3.restore ... validate
    验证数据库:
    RESTORE DATABASE VALIDATE;
	验证控制文件:
	restore controlfile validate;
	验证spfile
	restore sfile validate;
	验证归档日志
    RESTORE ARCHIVELOG ALL VALIDATE;
	验证特定的归档片
	   select max(sequence#) from v$archived_log;
	   restore archivelog sequence 45 vadliate;
	  备份:45为存在的归档sequence号.
	   



?