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;
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;