QUESTION NO: 333
Which command would you use to determine what database backups are currently available for restore?
A. list database backup;
B. report database backup;
C. list backup of database;
D. list summary backup;
E. report backup of database;
【题目示意】
此题考查有关于list backup的相关知识。
【解析】
在RMAN中的的备份文件怎么查询备份的文件。
List backup of database 列出数据库所有文件的备份集;
List backup by file 根据文件的备份列出备份;
List backup summary 列表输出汇总;
Report need backup database,根据备份策略写显示需要备份的文件;
Report obseoete,列出备份配置下过时的备份策略,默认的使用可选择的冗余和恢复窗口来覆盖.
【实验】
1)列出数据库中所有文件的备份集
RMAN> list backup of database;
List of Backup Sets
==================================================================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------------- ------------ ---------------------- --------
2 Full 1.30G DISK 00:04:01 22-JAN-14
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20140122T220148
PieceName: /u01/app/oracle/fast_recovery_area/ENMOEDU/backupset/2014_01_22/o1_mf_nnndf_TAG20140122T220148_9fzmtnv1_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- -------- -- ---- ---------- --------- -------- -- ---- ---------- --------- -------- --
1 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/system01.dbf
2 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf
3 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf
4 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/users01.dbf
5 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/example01.dbf
6 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/test01.dbf
7 Full 1231425 22-JAN-14 /u01/app/oracle/oradata/ENMOEDU/test02.dbf
2)列表输出汇总;
2)RMAN> list backup summary;
List of Backups
==================================================================
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ------------- ------- ------- ---------- --------
1 B F A DISK 22-JAN-14 1 1 NO TAG20140122T215813
2 B F A DISK 22-JAN-14 1 1 NO TAG20140122T220148
3 B F A DISK 22-JAN-14 1 1 NO TAG20140122T220148
3)列出需要备份的数据文件
RMAN> REPORT NEED BACKUP DATABASE;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
【小结】
(A)list database backup没有这样的命令;执行时是错误的语句;
(B)命令不对,应该是Report need backup database;
(C)List backup of database,此命令是正确的可以列出备份的文件;
(D)此命令不正确,应该List backup summery;
(E)此原因同(B);
【答案】 C
相关参考
file:///D:/oracle/11g手册_01/backup.112/e10642/rcmquick.htm#sthref155
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078449/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078449/