ITPub博客

首页 > 数据库 > Oracle > Backup And Recovery User's Guide-从RMAN开始-维护RMAN备份-cross-checking备份

Backup And Recovery User's Guide-从RMAN开始-维护RMAN备份-cross-checking备份

原创 Oracle 作者:luisedalian 时间:2014-02-13 13:33:12 0 删除 编辑

维护RMAN备份

RMAN库元数据始终存储在目标数据库的控制文件中。RMAN维护命令管理备份的时候会使用这些元数据。

cross-checking备份

CROSSCHECK命令会将RMAN备份和镜像的逻辑记录与存储介质上的文件进行同步。

如果备份存在于磁盘上,则CROSSCHECK会确定文件头是否有效;

如果备份在磁带上,则RMAN查询RMAN库,查看备份片的名称和位置。

 

在删除之前首先对备份和拷贝进行cross-check检查是很好的做法。

--对所有备份进行检查

RMAN> crosscheck backup;

 

using channel ORA_DISK_1

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp RECID=1 STAMP=820092104

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp RECID=3 STAMP=820095696

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T202137_8xkf4l36_.bkp RECID=4 STAMP=820095698

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_ncsnf_TAG20130706T202137_8xkfd4fb_.bkp RECID=5 STAMP=820095940

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202541_8xkfd5tj_.bkp RECID=6 STAMP=820095941

Crosschecked 5 objects

 

--只对镜像拷贝进行检查

RMAN> crosscheck copy;

 

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=50 device type=DISK

specification does not match any datafile copy in the repository

specification does not match any control file copy in the repository

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_9_8xkf4h9k_.arc RECID=1 STAMP=820095695

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_10_8xkfd5gv_.arc RECID=2 STAMP=820095941

Crosschecked 2 objects

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

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    5642205