What is the impact of the results of the output of the following command?
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
—- ———————– ———————————–
4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF
A.
There are no backup sets with any backups of the users01.dbf datafile.
B.
The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be
backed up or some data loss is possible during a recovery.
C.
The users01.dbf datafile is corrupted.
D.
The users01.dbf datafile backup exceeds the retention criteria.
E.
The last backup of the users01.dbf datafile failed and must be rerun.
B is the correct answer. Report unrecoverable database lists datafiles in which nologging operations were performed.
Anonim is correct, the answer is B
The RMAN output text specifically states this above:
RMAN> report unrecoverable database;
“Report of files that need backup due to unrecoverable operations”
Anonim is correct, the answer is B
The answer is B.
Actually the command is
REPORT UNRECOVERABLE;
which lists all datafiles for which an unrecoverable operation has been performed against an object in the datafile since the last backup of the datafile.
See…
http://oracle.su/docs/11g/backup.112/e10642/rcmquick.htm#BABJAGIB