QUESTION NO: 338
You run the following commands:
RMAN> list expired backup;
RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?
A. They will be renamed.
B. Nothing will happen to them. The backup set pieces do not exist.
C. They will be deleted immediately since they are not in the flash recovery area.
D. You will need to manually remove the physical files listed in the output of the commands.
E. They will become hidden files and removed 10 days later.
【题目示意】
此题考查有关于EXPOIRED BACKUP的相关知识。
【解析】
CROSSCHECK是检查确定文件在磁盘上或在介质目录管理中对应RMAN库中的数据。介质管理可以标记磁带为过期或无法使用,因为文件从磁盘可以被删除或者否则会损坏,RMAN库可以包含过时的信息备份。运行crosscheck命令执行交叉核对。核对完之后,将删除和损坏的磁盘信息或者是过时的备份信息 存放在EXPIRED储库中,一旦执行DELETE EXPIRED 命令将存放在EXPIRED储库中的文件信息都删除。
【实验】
1)查看过期备份,
RMAN> list expired backup;
List of Backup Sets
====================================================================================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------------------------------------------------------------------------------------
8 Full 9.36M DISK 00:00:01 23-JAN-14
BP Key: 8 Status: EXPIRED Compressed: NO Tag: TAG20140123T234343
Piece Name: /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_23/o1_mf_ncsnf_TAG20140123T234343_9g2g9foz_.bkp
SPFILE Included: Modification time: 23-JAN-14
SPFILE db_unique_name: ENMOEDU
Control File Included: Ckp SCN: 948826 Ckp time: 23-JAN-14
2)删除过期备份:
RMAN> delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
8 8 1 1 EXPIRED DISK /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_23/o1_mf_ncsnf_TAG20140123T234343_9g2g9foz_.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_23/o1_mf_ncsnf_TAG20140123T234343_9g2g9foz_.bkp RECID=8 STAMP=837647149
Deleted 1 EXPIRED objects
3)再次查看过期的备份,没有过期的备份:
RMAN> list expired backup;
specification does not match any backup in the repository
本题中执行的两个命令,第一个命令是查看有哪些过时的备份,第二个命令是删除过期的备份,所以在查找中的文件,不存在啦。
【答案】 B
相关参考
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-1078453/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078453/