053试题 319

试题 319"/>

053试题 319

题目：

319.What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag=gold_copy plus archivelog tag=gold_copy delete input;
Backup database tag=silver_copy plus archivelog tag=silver_copy delete input;

A. Attempting to restore silver_copy will fail.
B. Attempting to restore gold_copy will fail.
C. Both backups will be available for restore without question.
D. Attempting to restore gold_copy may or may not succeed.
E. You will not be able to restore either gold_copy or silver_copy.
 
参考答案 D
解析
备份冗余策略是redundancy 1. 先后进行了两次备份，tag是 gold_copy，sliver_copy。这样gold_copy就开始obsolete的了。
如果进行restore/recover的话。使用sliver_copy会成功，A错误。
如果执行了report obsolete，delete obsolete后，GOLD_COPY就会被删除，就不能进行restore/recover。 可能会成功，也可能失败。
使用tag=silver_copy 一定会成功的。

-- 测试

分别进行备份，查看备份后的结果

RMAN> list backup of database tag GOLD_COPY;List of Backup Sets
===================BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
258     Full    2.64G      DISK        00:07:00     30-AUG-19BP Key: 258   Status: AVAILABLE  Compressed: YES  Tag: GOLD_COPYPiece Name: /u01/oradata/fast_recovery_area/test/TEST/backupset/2019_08_30/o1_mf_nnndf_GOLD_COPY_gpknzh6j_.bkpList of Datafiles in backup set 258File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name---- -- ---- ---------- --------- ----------- ------ ----1       Full 5030501    30-AUG-19              NO    /u01/oradata/test/system01.dbf2       Full 5030501    30-AUG-19              NO    /u01/oradata/test/example01.dbf3       Full 5030501    30-AUG-19              NO    /u01/oradata/test/sysaux01.dbf4       Full 5030501    30-AUG-19              NO    /u01/oradata/test/undotbs01.dbf5       Full 5030501    30-AUG-19              NO    /u01/oradata/test/lob_tbs01.dbf7       Full 5030501    30-AUG-19 5030525      NO    /u01/oradata/test/users01.dbf8       Full 5030501    30-AUG-19              NO    /u01/oradata/test/tbs_hmw01.dbfRMAN> list backup of database tag SILVER_COPY;List of Backup Sets
===================BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
262     Full    2.65G      DISK        00:07:11     30-AUG-19BP Key: 262   Status: AVAILABLE  Compressed: YES  Tag: SILVER_COPYPiece Name: /u01/oradata/fast_recovery_area/test/TEST/backupset/2019_08_30/o1_mf_nnndf_SILVER_COPY_gpkok86n_.bkpList of Datafiles in backup set 262File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name---- -- ---- ---------- --------- ----------- ------ ----1       Full 5030922    30-AUG-19              NO    /u01/oradata/test/system01.dbf2       Full 5030922    30-AUG-19              NO    /u01/oradata/test/example01.dbf3       Full 5030922    30-AUG-19              NO    /u01/oradata/test/sysaux01.dbf4       Full 5030922    30-AUG-19              NO    /u01/oradata/test/undotbs01.dbf5       Full 5030922    30-AUG-19              NO    /u01/oradata/test/lob_tbs01.dbf7       Full 5030922    30-AUG-19 5031353      NO    /u01/oradata/test/users01.dbf8       Full 5030922    30-AUG-19              NO    /u01/oradata/test/tbs_hmw01.dbfRMAN>

-- delete obsolete

RMAN> delete obsolete;

-- 然后再进行查看备份的数据库，只有一个了。

RMAN> list backup of database summary;List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
262     B  F  A DISK        30-AUG-19       1       1       YES        SILVER_COPYRMAN> host;

END