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:
Post a Comment