86.View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true

86.View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is true about the output of the command?
A.The backup piece is expired as the new backup is available.
B.The backup piece is expired because the operating-system file was not found.
C.The backup piece is expired because the retention period for the backup has expired.
D.The backup piece is expired because the backup set to which it belongs is not complete.
答案：B
解析：
crosscheck backup的作用是，为了使恢复目录保持最新的状态，使用该命令，为缺少的备份加上expired标记
RMAN> list backup summary;


using target database control file instead of recovery catalog


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
111     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T113055
112     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T113102
--这里的S列也是表空备份状态的，如果为A那么就是available 可用，rman认定该项存在于备份介质上
如果为U，那么就是unavailable不可用，X为expired到期
--我们可以测试一下
RMAN> list backupset summary;
List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
113     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T115138
114     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T115141
--有两个备份集，状态都为available
RMAN> list backupset 113;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
113     Full    85.54M     DISK        00:00:02     23-JUL-16      
        BP Key: 113   Status: AVAILABLE  Compressed: NO  Tag: TAG20160723T115138
        Piece Name: /home/oracle/db_recover/WAHAHA3/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T115138_cs5tgbft_.bkp
  List of Datafiles in backup set 113
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 2655151    23-JUL-16 /u01/oracle/oradata/wahaha3/users01.dbf
--这个时user01数据文件的备份
RMAN> host;
[oracle@wahaha3 ~]$ mv /home/oracle/db_recover/WAHAHA3/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T115138_cs5tgbft_.bkp /home/oracle/a.bkp
--挪个地方
[oracle@wahaha3 ~]$ exit
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/db_recover/WAHAHA3/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T115138_cs5tgbft_.bkp RECID=113 STAMP=917956298
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/db_recover/WAHAHA3/autobackup/2016_07_23/o1_mf_s_917956301_cs5tgfrl_.bkp RECID=114 STAMP=917956301
Crosschecked 2 objects
RMAN> 
--执行crosscheck可以看出来113标记为EXPIRED了
RMAN> list backupset summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
113     B  F  X DISK        23-JUL-16       1       1       NO         TAG20160723T115138
114     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T115141
--这里状态也变为了X了
RMAN> host;
[oracle@wahaha3 ~]$ mv /home/oracle/a.bkp /home/oracle/db_recover/WAHAHA3/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T115138_cs5tgbft_.bkp
[oracle@wahaha3 ~]$ exit
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/db_recover/WAHAHA3/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T115138_cs5tgbft_.bkp RECID=113 STAMP=917956298
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/db_recover/WAHAHA3/autobackup/2016_07_23/o1_mf_s_917956301_cs5tgfrl_.bkp RECID=114 STAMP=917956301
Crosschecked 2 objects
RMAN> list backupset summary;
List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
113     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T115138
114     B  F  A DISK        23-JUL-16       1       1       NO         TAG20160723T115141
--诺回去执行backupset后状态又变为了可用
--删除expired的命令是delete expired backup;