database not open – redo log fail


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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: