ORA-01578 after rman recovery
Oracle - 11.2 This is a brief list pointing out some factors on nologging operations which results unrecoverability in database. Once a db backup with unrecoverable operations fully recovered, accessing affected objects will still return ORA--1578. 1. Detecting unrecoverable operations. Rman " report unrecoverable " will provide list of datafiles which are in unrecoverable state. Also unrecoverable_time column of v$datafile can be queried to see the last unrecoverable action performed on particular datafile, but this column will not be updated after a backup is made from rman. 2. There want be any errors during the restore/recovery operations in rman logs. Even during a nologging operation small amount of redo is generated. These logs simply says that affected block is for nologging operation. So during a roll-forward these logs will be applied, but they will logically corrupt the affected blocks. 3. After full restore/recovery of daabase with nologging corr...