ORA-00313: open failed for members of log group Error on Standby Database

dbtut

5 years ago

ORA-00313 error can be received depending on any problem in redo log files in standby database.

The possible error message will be as follows.

ORA-00313: open failed for members of log group 3 of thread 1

As a solution, the contents of the files in the redo log group that cause the error should be emptied.

To do this, we need to set the standby file management manually and turn off the recovery process.

SQL> alter system set standby_file_management=manual;

SQL> alter database recover managed standby database cancel;

SQL> alter system set standby_file_management=manual;

SQL> alter database recover managed standby database cancel;

Then, all redo log groups that cause the error should be cleaned as follows.

SQL> alter database clear logfile group 3;

1	SQL> alter database clear logfile group 3;

Then, standby file management should be automated and recovery should be continued.

SQL> alter system set standby_file_management=auto;

SQL> alter database recover managed standby database using current logfile disconnect from session;

SQL> alter system set standby_file_management=auto;

SQL> alter database recover managed standby database using current logfile disconnect from session;