试题 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
更多推荐
053试题 319
发布评论