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 correct.
A data file is considered unrecoverable if an unrecoverable operation has been performed against an object residing in the data file since the last backup of the data file. In an unrecoverable operation, REDO IS NOT GENERATED. Examples are DIRECT LOAD of table data and updates with the NOLOGGING option.
Looks like D is correct
B is correct. Certain types of SQL operations can make an object unrecoverable. This is because these
operations do not produce redo, in an effort to make the process more performant. Since
there is no redo, there is no recovering the object, and what you end up with after a recovery
is a shell of an object with no data in it.