oracle备份验证,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号.