All,
I have an issue while starting the DB. I have Oracle 9.2.0.8,32bit
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs
2 ;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
SQL> recover datafile 'G:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using BACKUP CONTROLFILe;
ORA-00279: change 606018081 generated at 12/07/2009 11:58:11 needed for thread
1
ORA-00289: suggestion : G:\ORACLE\DEV\SAPARCH\DEVARCHARC00511.001
ORA-00280: change 606018081 for thread 1 is in sequence #511
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'G:\ORACLE\DEV\SAPARCH\DEVARCHARC00511.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00308: cannot open archived log 'G:\ORACLE\DEV\SAPARCH\DEVARCHARC00511.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Now when i try to find the log sequence,
SQL> select * from v$log
2 ;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
15 1 508 104857600 2 YES INACTIVE
605958033 07-DEC-09
16 1 510 104857600 2 YES INACTIVE
605998065 07-DEC-09
17 1 511 104857600 2 NO CURRENT
606018081 07-DEC-09
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
18 1 509 104857600 2 YES INACTIVE
605978049 07-DEC-09
The recovery needs the sequence #511 to complete the recover. But its still in current state.
Please suggest how I can recover the database;