ORA-01547 , ORA-01194 , ORA-01110 during Hot backup restore
While restoring hot backup & performing recovery post the end of the backup, we are getting following error:
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oracle11g/oradata/oimprod/system01.dbf'
Datafiles are not in backup (V$backup). No file required recovery (V$recover_file). But Fuzzy is Yes for all files (V$datafile_header).
We are running 11.2.0.3 on SLES 11SP1.
SQL> select fuzzy, status, error, recover, checkpoint_change#, checkpoint_time, count(*) from v$datafile_header group by fuzzy, status, error, recover, checkpoint_change#, checkpoint_time ;