Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01547 , ORA-01194 , ORA-01110 during Hot backup restore

edited Jan 5, 2014 6:55PM in Database Backup and Recovery (MOSC) 7 commentsAnswered
Hello

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 ;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center