OCP-IZO-053_QUESTION340

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

congbianzhi5656

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

阅读量85

点赞数

文章标签：数据库

QUESTION NO: 340

What does it mean if a backup is expired?

A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B. The backup set has one or more invalid blocks in it and is not usable for recovery.

C. The backup set contains one or more tablespaces no longer in the database.

D. The backup set contains one or more missing backup set pieces.

E. The backup set is from a previous version of RMAN and was not upgraded.

【题目示意】

此题考查有关于backup expired的相关知识。

【解析】

RMAN库备份的状态是到期,这意味着备份文件不存在。当运行CROSSCHECK命令和文件不存在或无法访问，RMAN将备份和复制标记为过期。

【实验】

1）删除一个备份文件rm -rf o1_mf_nnndf_TAG20140124T003139_9g2jzf2w_.bkp；

[oracle@ENMOEDU 2014_01_24]$ rm -rf o1_mf_nnndf_TAG20140124T003139_9g2jzf2w_.bkp

2）在目录中删除文件核实过期备份，

RMAN> CROSSCHECK BACKUP OF database;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=140 device type=DISK

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_24/o1_mf_nnndf_TAG20140124T003139_9g2jzf2w_.bkp RECID=9 STAMP=837649901

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_29/o1_mf_nnndf_TAG20140129T202220_9gkwmwtp_.bkp RECID=15 STAMP=838153340

Crosschecked 2 objects

3）查看过期的备份：

RMAN> list expired backup;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

9 Full 1019.61M DISK 00:01:53 24-JAN-14

BP Key: 9 Status: EXPIRED Compressed: NO Tag: TAG20140124T003139

Piece Name: /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_24/o1_mf_nnndf_TAG20140124T003139_9g2jzf2w_.bkp

List of Datafiles in backup set 9

File LV Type Ckp SCN Ckp Time Name

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

1 Full 951738 24-JAN-14 /u01/app/oracle/oradata/ENMOEDU/system01.dbf

2 Full 951738 24-JAN-14 /u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf

3 Full 951738 24-JAN-14 /u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf

4 Full 951738 24-JAN-14 /u01/app/oracle/oradata/ENMOEDU/users01.dbf

5 Full 841233 16-JAN-14 /u01/app/oracle/oradata/ENMOEDU/hr.dbf

4）删除过期的备份

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

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

9 9 1 1 EXPIRED DISK /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_24/o1_mf_nnndf_TAG20140124T003139_9g2jzf2w_.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_nnndf_TAG20140124T003139_9g2jzf2w_.bkp RECID=9 STAMP=837649901

Deleted 1 EXPIRED objects

【小结】文件不存在或无法访问的文件为过期的文件，因此选择D

【答案】 D