QUESTION NO: 350
Why would you execute the report obsolete command?
A. To list all backups that were no longer available for restore operations
B. To list all backups that had aged beyond the RMAN retention criteria
C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
D. To list all datafiles that are no longer part of the database and thus do not need to be backed up
E. To list all archived redo logs that are no longer needed for any database recovery
【题目示意】
此题考查有关于report obsolete 的相关知识。
【解析】
Report obsolete 根据当前的备份保留策略,报告出数据恢复不再需要的备份。
【实验】
1)根据我当前的保留策略,列出不再需要的备份。此保留策略的冗余度为1;
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 1 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_85_9gkf120r_.arc
Archive Log 2 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_86_9gkf1lk5_.arc
Archive Log 3 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_87_9gkqtt7y_.arc
Archive Log 4 31-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_31/o1_mf_1_88_9gpzjy3d_.arc
2)删除废弃的备份文件
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 1 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_85_9gkf120r_.arc
Archive Log 2 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_86_9gkf1lk5_.arc
Archive Log 3 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_87_9gkqtt7y_.arc
Archive Log 4 31-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_31/o1_mf_1_88_9gpzjy3d_.arc
Do you really want to delete the above objects (enter YES or NO)? y
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_85_9gkf120r_.arc RECID=1 STAMP=838137381
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_86_9gkf1lk5_.arc RECID=2 STAMP=838137397
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_29/o1_mf_1_87_9gkqtt7y_.arc RECID=3 STAMP=838148443
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ENMOEDU/archivelog/2014_01_31/o1_mf_1_88_9gpzjy3d_.arc RECID=4 STAMP=838320158
Deleted 4 objects
【小结】
Report obsolete就是根据保留策略列出不再需要的备份。因此选B
【答案】 B
相关参考
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#BRADV280
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078471/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078471/