What is the impact of the results of the output of the following command?

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

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.

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

Justyna

Justyna

In this context ‘affected by’ means something like ‘touched by’. When there is any operation with NOLOGGING then there is no red logs.

See documentation of 11g database

“Reporting on Datafiles Affected by Unrecoverable Operations

When a datafile has been changed by an unrecoverable operation, such as a direct load insert, normal media recovery cannot be used to recover the file, because an unrecoverable operation does not generate redo. You must perform either a full or incremental backup of affected datafiles after such operations, to ensure that data blocks affected by the unrecoverable operation can be recovered using RMAN. ”

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#autoId16

Reply

Justyna

Justyna

And more:

“A datafile is considered unrecoverable if an unrecoverable operation has been performed against an object residing in the datafile since the last backup of the datafile. In an unrecoverable operation, redo is not generated. Examples are direct load of table data and updates with the NOLOGGING option.”

http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta035.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta035.htm#BGBHCCGH

So D is not correct answer but B.

Reply

spellblind

spellblind

Found this info useful from the Oracle Community

When ever a operation occurs on database i.e. any dml occurs on tables, these operation generates REDO information in redolog files. So when someone explicitly disable the logging information to redologfile(by hint no_logging), then datafile is marked as unrecoverable.

Oracle says it unrecoverable because oracle cannot perform recovery by reading from redologfile or archivefiles if datafile crashes and need a recovery. Thats why rman warns you about such operation which could have taken place and point you to datafile which had these operation performed. The operations which are unrecoverable are:

So once you take the full backup of datafiles (which are affected by these operation) will clearout the Unrecoverable warning. Because now oracle has the backup of these files.

Reply