Recovery of Oracle 9i DB isn't possible in 11g database

195 Views

Hello Colleagues,

We are trying to refresh 9i DB into 11G DB.

We were successful in restoring the database but we are getting the error during the recovery phase.

The database is not starting and hanging in mount state.

I am getting the following errors:

ORA-10879: error signaled in parallel recovery slave

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'G:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'G:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

I had raised a ticket with SAP and they say 9i to 11g DB refresh is not recommended.

Kindly let me know is there anyway we can start the 11G database using 9i binaries?? How do we do that??

Kindly provide me some notes. I need to start the database somehow.