QUESTION NO: 347
What does the output on this report indicate?
RMAN> report need backup;
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
5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF
A. The my_data_01.dbf datafile is corrupted and needs to be restored.
B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
D. The my_data_01.dbf datafile no longer meets the retention criteria for backups.
E. Datafile 5 is missing.
【题目示意】
此题考查有关于BACKUP的相关知识。
【解析】
REPORT NEED BACKUP是核实数据库中的备份文件与与备份策略中不一样的文件。但是这些备份文件仍然可以用于备份恢复。
【实验】
1)需要备份的文件
RMAN> report need backup;
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
---- ----- -----------------------------------------------------
1 0 /u01/app/oracle/oradata/ENMOEDU/system01.dbf
2 0 /u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf
3 0 /u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf
4 0 /u01/app/oracle/oradata/ENMOEDU/users01.dbf
5 0 /u01/app/oracle/oradata/ENMOEDU/he.dbf
2)对数据库进行恢复
[oracle@ENMOEDU admin]$ rman target/
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 5 18:33:14 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ENMOEDU (DBID=95949543, not open)
RMAN> recover database;
Starting recover at 05-FEB-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 05-FEB-14
RMAN> restore database;
Starting restore at 05-FEB-14
using channel ORA_DISK_1
对数据库进行恢复需要的是在线日志和归档日志文件。
【小结】
文件需要备份,但是仍然可以恢复,因此选择B
【答案】 B
相关参考
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#BRADV89595
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078467/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078467/