QUESTION NO: 334
What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?
A. crosscheck
B. list backup
C. confirm
D. resync
E. backup validate
【题目示意】
此题考查有关于CROSSCHECK的相关知识。
【解析】
CROSSCHECK是检查确定文件在磁盘上或在介质目录管理中对应RMAN库中的数据。因为介质管理可以标记磁带为过期或无法使用,因为文件从磁盘可以被删除或者否则会损坏,RMAN库可以包含过时的信息备份。运行crosscheck命令执行交叉核对。
图中表明了介质的管理者的交叉核对。RMAN查询RMAN库的名称和位置对四个备份集进行核对,RMAN将这些信息发送到目标数据库服务器,查询媒体介质软件有关备份,介质管理软件然后检查其媒体目录和报告回服务器,备份集3丢失,RMAN的状态更新为备份集3在 EXPIRED存储库中,一旦运行DELETE EXPIRED命令,备份集3被删除。
【实验】
1)使用CROSSCHEK核对控制文件的备份信息:
[oracle@ENMOEDU ~]$ rman target/
RMAN> CROSSCHECK BACKUP OF CONTROLFILE;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_02_05/o1_mf_s_838745026_9h3yg3ow_.bkp RECID=29 STAMP=838745027
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_02_05/o1_mf_s_838746025_9h3zf9h4_.bkp RECID=31 STAMP=838746025
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_02_05/o1_mf_s_838748124_9h41oj3j_.bkp RECID=33 STAMP=838748335
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_02_05/o1_mf_s_838748124_9h41r4l0_.bkp RECID=35 STAMP=838748420
Crosschecked 4 objects
2)删除过期备份的控制文件,因为此数据库没有过期的备份,所以就没有可以匹配的:
RMAN> DELETE EXPIRED BACKUP OF CONTROLFILE;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
31 31 1 1 EXPIRED DISK /u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_02_05/o1_mf_s_838746025_9h3zf9h4_.bkp
Do you really want to delete the above objects (enter YES or NO)? y
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_02_05/o1_mf_s_838746025_9h3zf9h4_.bkp RECID=31 STAMP=838746025
Deleted 1 EXPIRED objects
【小结】
要对备份文件进行交叉核实,才能保证文件真实的存在备份介质中
【答案】 A
相关参考
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV90138
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmmaint.htm#BRADV89624
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078450/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078450/