Skip to Content
0
Former Member
Dec 07, 2009 at 07:43 AM

DB Recovery Issue

100 Views

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;