OCP-IZO-053_QUESTION339

最新推荐文章于 2024-07-20 20:04:43 发布

congbianzhi5656

最新推荐文章于 2024-07-20 20:04:43 发布

阅读量75

点赞数

文章标签：数据库

QUESTION NO: 339

Why would you run the delete obsolete command? (Choose all that apply.)

A. To remove missing backup set pieces physically from disk

B. To remove metadata related to backup set pieces in the control file and the recovery catalog

C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria

E. To remove old versions of RMAN backups

【题目示意】

此题考查有关于DELETE OBSOLETE的相关知识。

【解析】

删除过时的备份是以备份策略为基础的。RMAN删除命令支持一种过时的选项,删除不再满足指定的可恢复性要求的备份。默认的根据保留政策的备份删除过时的文件,或另一个保留政策指定一个选项为DELETE OBSOLETE命令。和其它形式的“删除文件”一样，从备份介质和恢复目录中删除，并在控制文件中标记为删除。

如果执行DELETE OBSOLETE命令，没有加任何的参数，那么RMAN 会删除根据保留策略配置的所有的过时的备份。

【实验】

根据备份策略删除过时的文件。

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

-------------------- ------ ------------------ --------------------

Backup Set 10 24-JAN-14

Backup Piece 10 24-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_24/o1_mf_ncsnf_TAG20140124T003139_9g2k2zz0_.bkp

Backup Set 11 29-JAN-14

Backup Piece 11 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_29/o1_mf_nnndf_TAG20140129T195121_9gktsvqq_.bkp

Backup Set 12 29-JAN-14

Backup Piece 12 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_01_29/o1_mf_s_838151568_9gktwkk5_.bkp

Backup Set 13 29-JAN-14

Backup Piece 13 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_29/o1_mf_nnndf_TAG20140129T202114_9gkwktjs_.bkp

Backup Set 14 29-JAN-14

Backup Piece 14 29-JAN-14 /u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_01_29/o1_mf_s_838153275_9gkwkw3l_.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/backupset/2014_01_24/o1_mf_ncsnf_TAG20140124T003139_9g2k2zz0_.bkp RECID=10 STAMP=837650015

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_29/o1_mf_nnndf_TAG20140129T195121_9gktsvqq_.bkp RECID=11 STAMP=838151483

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_01_29/o1_mf_s_838151568_9gktwkk5_.bkp RECID=12 STAMP=838151569

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_29/o1_mf_nnndf_TAG20140129T202114_9gkwktjs_.bkp RECID=13 STAMP=838153274

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/autobackup/2014_01_29/o1_mf_s_838153275_9gkwkw3l_.bkp RECID=14 STAMP=838153276

Deleted 5 objects

【小结】

DELETE OBSOLETE 就是根据备份策略删除不在需要的文件，从备份介质和恢复目录中删除，并在控制文件中标记为删除。

【答案】 CD