QUESTION NO: 349
What is the result of this command?
RMAN> Report need backup days 3;
A. Lists all datafiles created in the last three days that are not backed up.
B. Lists all datafiles not recoverable based on the current retention criteria.
C. Lists all datafiles not backed up in the last three days. The datafile is not recoverable.
D. Lists all datafiles that need to be backed up due to unrecoverable operations.
E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
【题目示意】
此题考查有关于BACKUP的相关知识。
【解析】
Report need backup days 3 报告出最近三天内没有备份的文件。在原来备份的文件没有损坏仍然可以用于恢复。
【实验】
1)列出三天内没有备份的数据文件,如果需要恢复这些数据文件,需要三天以上的归档日志文件才能恢复。
RMAN> Report need backup days 3;
using target database control file instead of recovery catalog
Report of files whose recovery needs more than 3 days of archived logs
File Days Name
---- ----- -----------------------------------------------------
1 116 /u01/app/oracle/oradata/ENMOEDU/system01.dbf
2 116 /u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf
3 116 /u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf
4 116 /u01/app/oracle/oradata/ENMOEDU/users01.dbf
5 113 /u01/app/oracle/oradata/ENMOEDU/example01.dbf
6 112 /u01/app/oracle/oradata/ENMOEDU/test01.dbf
7 112 /u01/app/oracle/oradata/ENMOEDU/test02.dbf
【小结】
REPORT NEED BACKUP DAYS n 就是在最近n天内没有备份的文件,但是以前的备份文件仍然可以用于恢复数据。选择E
【答案】 E
相关参考
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#BRADV89595
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078478/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078478/