December 29, 2009

How to : open failed for members of log group 1 of thread 1 open failed for members of log group 1 of thread 1: Oracle error

Oracle Error : open failed for members of log group 1 of thread 1

Start up your oracle
SQL> startup
ORACLE instance started.

Total System Global Area 928584620 bytes
Fixed Size 451500 bytes
Variable Size 369098752 bytes
Database Buffers 553648128 bytes
Redo Buffers 5386240 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/usr/oracle/oradata/mydb/redo01a.log'
ORA-00312: online log 1 thread 1: '/oradata/mydb/redo01b.log'


Here the problem/error is with redo logs of a specific group. so reseting the logs may solve the problem.

SQL>RECOVER DATABASE UNTIL CANCEL;

SQL>ALTER DATABASE OPEN RESETLOGS;

done...
Shutdown and Startup Oracle and check the whether the error exist or not .

No comments: