Today in this article, we will learn how to resolve ORA-00313 error. Let’s go through the steps:
Table of Contents
Error :
1 2025-02-13T02:06:22.927347-08:00
1 2025-02-13T02:06:22.931071-08:00
1 2025-02-13T02:06:22.934965-08:00
1 2025-02-13T02:06:27.046387-08:00
9 Errors in file /home/oracle/admin/test/diag/rdbms/test/test/trace/test_rmi_1284.trc:
1 ORA-00313: open failed for members of log group 1 of thread 1
1 ORA-00313: open failed for members of log group 2 of thread 1
1 ORA-00313: open failed for members of log group 3 of thread 1
Solution :
Step 1 :
In standy database, Issue the below query to check the status of the redo log :
set lines 300 pages 300
col MEMBER for a80
select * from v$logfile;
You will see some redo logs which status is invalid. So, you have to clear those redo logs.
Output :
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- ---------------------------------------------------------
1 ONLINE +DATA/TEST/ONLINELOG/group_1.1139.1181370015 YES 0
2 ONLINE +DATA/TEST/ONLINELOG/group_2.1138.1181370015 YES 0
3 ONLINE +DATA/TEST/ONLINELOG/group_3.1137.1181370015 YES 0
4 ONLINE +DATA/TEST/ONLINELOG/group_4.1136.1181370015 YES 0
5 STANDBY +DATA/TEST/ONLINELOG/group_13.1130.1181370015 YES 0
6 STANDBY +DATA/TEST/ONLINELOG/group_14.1126.1181370017 YES 0
7 STANDBY +DATA/TEST/ONLINELOG/group_15.1123.1181370017 YES 0
8 STANDBY +DATA/TEST/ONLINELOG/group_16.1120.1181370017 YES 0
9 STANDBY +DATA/TEST/ONLINELOG/group_17.1125.1181370017 YES 0
1 INVALID ONLINE +DATA/TEST/redo2/log1b.rdo NO 0
2 INVALID ONLINE +DATA/TEST/redo2/log2b.rdo NO 0
3 INVALID ONLINE +DATA/TEST/redo2/log3b.rdo NO 0
4 INVALID ONLINE +DATA/TEST/redo2/log4b.rdo NO 0
Step 2:
Issue the below commands to clear the redo logs :
SQL> alter system set standby_file_management=manual;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> alter database clear logfile group 1;
SQL> alter database clear logfile group 2;
SQL> alter database clear logfile group 3;
SQL> alter database clear logfile group 4;
SQL> alter system set standby_file_management=auto;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
So, here are the simple and clear steps that can help you to resolve the ORA-00313 error. Hope this helps!! Also, you can get more information from the Oracle Doc ID 1616394.1 as well.
Related Oracle Related Articles :