database couldn’t open because i got the error,
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘E:\REDO\REDO01_01.ILG’
ORA-00312: online log 1 thread 1: ‘H:\REDO\REDO01_02.ILG’
i search some explanation about the error,
ora-00312: online log %s thread %s: ‘%s’
*Cause: This message reports the filename for details of another message.
*Action: Other messages will accompany this message. See the
associated messages for the appropriate action to take.
ora-00313: open failed for members of log group %s of thread %s
*Cause: The online log cannot be opened. May not be able to find file.
*Action: See accompanying errors and make log available.
so to open database, follow the step,
1)Using V$LOG, got the status of each group
In mount mode,
2) Clear the log groups which are not current,
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
3) RECOVER DATABASE UNTIL CANCEL (This is what i missed and looking for the help)
4) ALTER DATABASE OPEN RESETLOGS;
OPEN RESETLOGS is valid whenever you make an incomplete recovery