ORA-03113: end-of-file or ORA-00313: open failed for members of log group

Error
During startup of the Oracle database getting the following error:

startup
ORACLE instance started.
Total System Global Area 1610609744 bytes
Fixed Size                  9028688 bytes
Variable Size            1258291200 bytes
Database Buffers          335544320 bytes
Redo Buffers                7745536 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 20876
Session ID: 296 Serial number: 6999

On Checking the alert log, Getting the following error:

Errors in file C:\ORACLE\diag\rdbms\xe\xe\trace\xe_lgwr_16748.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: 'C:\ORACLE\ORADATA\XE\REDO05.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Solution: Clear the redo log group which causing the problem. Alert log file show us the log group 5 is causing problem.

1. Connect with new session and open Database in mount stage

sqlplus / as sysdba

startup mount
ORACLE instance started.
Total System Global Area 1610609744 bytes
Fixed Size                  9028688 bytes
Variable Size            1258291200 bytes
Database Buffers          335544320 bytes
Redo Buffers                7745536 bytes
Database mounted.

2. Run the Clear archive log command.

SQL> alter  database clear  logfile group 5;
Database altered.
--If the corrupt redo log file has not been archived, use the UNARCHIVED keyword in the statement
alter database clear unarchived logfile group 5;

3. Open the Database.

SQL> alter database open;
Database altered.

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.