读书人

Oracle RMAN有关验证备份

发布时间: 2012-07-15 20:20:06 作者: rapoo

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;验证spfilerestore sfile validate;验证归档日志    RESTORE ARCHIVELOG ALL VALIDATE;验证特定的归档片   select max(sequence#) from v$archived_log;   restore archivelog sequence 45 vadliate;  备份:45为存在的归档sequence号.   

?

读书人网 >其他数据库

热点推荐