QUESTION NO: 352
If a backup is expired, which of the following is true?
A. It can never be used for a restore/recover operation.
B. Oracle will remove the backup set pieces from the flash recovery area.
C. The backup has been used at least once to restore and recover the database.
D. The backup is no longer valid because of a resetlogs operation.
E. The physical backup set pieces are missing from the media.
【题目示意】
此题考查有关于backup expired的相关知识。
【解析】
CROSSCHECK是检查确定文件在磁盘上或在介质目录管理中对应RMAN库中的数据。介质管理可以标记磁带为过期或无法使用,因为文件从磁盘可以被删除或者否则会损坏,RMAN库可以包含过时的信息备份。运行crosscheck命令执行交叉核对。核对完之后,将删除和损坏的磁盘信息 存放在EXPIRED储库中,一旦执行DELETE EXPIRED 命令将存放在EXPIRED储库中的文件信息都删除。总之,备份文件在磁盘上删除和损坏,就是过期的备份文件。
【实验】
1)查看备份文件,并且删除一个备份文件。使文件从磁盘中删除。
[oracle@ENMOEDU 2014_01_16]$ ls
o1_mf_ncsnf_TAG20140116T160229_9fh4nqc5_.bkp o1_mf_ncsnf_TAG20140116T193313_9fhk042d_.bkp o1_mf_nnndf_TAG20140116T193313_9fhjvtb8_.bkp
o1_mf_ncsnf_TAG20140116T192640_9fhjt13b_.bkp o1_mf_ncsnf_TAG20140116T194453_9fhkoh6c_.bkp o1_mf_nnndf_TAG20140116T194453_9fhkkq17_.bkp
[oracle@ENMOEDU 2014_01_16]$ rm o1_mf_ncsnf_TAG20140116T192640_9fhjt13b_.bkp
2)执行crosscheck命令进行核实。
RMAN> CROSSCHECK BACKUP;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_ncsnf_TAG20140116T160229_9fh4nqc5_.bkp RECID=8 STAMP=837014679
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_ncsnf_TAG20140116T192640_9fhjt13b_.bkp RECID=10 STAMP=837027137
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_nnndf_TAG20140116T193313_9fhjvtb8_.bkp RECID=11 STAMP=837027194
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_ncsnf_TAG20140116T193313_9fhk042d_.bkp RECID=12 STAMP=837027332
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_nnndf_TAG20140116T194453_9fhkkq17_.bkp RECID=13 STAMP=837027894
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_ncsnf_TAG20140116T194453_9fhkoh6c_.bkp RECID=14 STAMP=837028015
Crosschecked 6 objects
可以看出有过期的文件。
3)列出过期的文件。
RMAN> list expired backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 9.36M DISK 00:00:07 16-JAN-14
BP Key: 10 Status: EXPIRED Compressed: NO Tag: TAG20140116T192640
Piece Name: /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_ncsnf_TAG20140116T192640_9fhjt13b_.bkp
SPFILE Included: Modification time: 16-JAN-14
SPFILE db_unique_name: ENMOEDU
Control File Included: Ckp SCN: 851101 Ckp time: 16-JAN-14
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
------- ------- --- --- ----------- ----------- ----------
10 10 1 1 EXPIRED DISK /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_16/o1_mf_ncsnf_TAG20140116T192640_9fhjt13b_.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_16/o1_mf_ncsnf_TAG20140116T192640_9fhjt13b_.bkp RECID=10 STAMP=837027137
Deleted 1 EXPIRED objects
文件过期就是磁盘上的文件被删除或者损坏。因此选择E
【答案】 E
相关参考
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-1078483/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078483/