Hi Gurus,
I am facing a problem during the backup/restore phase in SAPINST for a system copy. I am getting the below error in sapinst.log
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-01109: database not open
I have already perfrmed the Alter Database Open Resetlog and i am still getting error.
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/SID/sapdata1/system_1/system.data1'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1164329738 generated at 03/09/2012 13:20:26 needed for thread
1
ORA-00289: suggestion : /oracle/SID/oraarch/SIDarch1_2_777474969.dbf
ORA-00280: change 1164329738 for thread 1 is in sequence #2
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/oracle/SID/oraarch/SIDarch1_2_777474969.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/oracle/SID/oraarch/SIDarch1_2_777474969.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 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/SID/sapdata1/system_1/system.data1'
Can someone kindly advice and help me out on this ?
Edited by: K.Bala on Mar 9, 2012 11:02 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.