HI
Can someone explain exactly what RMAN command "report unrecoverable" means. Each day I run this command, a number of datafiles are returned in the result, not always the same ones however.
There are no "no logging" operations performed against this database nor is there any direct path loads, etc.
The database passes all RMAN validation tests and all checks for "REPORT need backup" return no results.
Oracle explains the "report unrecoverable" command as such:
"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."
The backup command I am using follows:
RUN {
allocate channel bkp_disk1 type disk format "[PATH]\%U";
RECOVER COPY OF DATABASE WITH TAG 'Incr_Update';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'Incr_Update'
DATABASE;
}