Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database open fails after online backup recovery

Hi Friends

We are trying to set up an additional server using the online backup of our DEV server. We have been following SAP Note 549828 for the same. Having restored the online backup, the open database failed.

To resolve the same, in accordance to SAP Note 549828, we created a backup control file with success using the command

create controlfile reuse set database DEV resetlogs noarchivelog

However on issuance of the command

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

we run into an error as to

ORA-00279: change 794638222 generated at 10/25/2007 12:43:20 needed for thread 1

ORA-00289: suggestion : /oracle/DEV/oraarch/DEVarch1_9766.dbf

ORA-00280: change 794638222 for thread 1 is in sequence #9766

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/oracle/DEV/oraarch/DEVarch1_9766.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

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/DEV/sapdata1/system_1/system.data1'

We even manually copied the file system.data1 from the source to the target server but to no avail.

Also the SQL command

SELECT FILE#, CHANGE# FROM V$RECOVER_FILE

displays a different change# for system.data1 while it is showing same number for all other datafiles.

Please advice at the earliest as we are struck. Points awaiting their master.

Regards

Lokesh Gupta

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question