How to Resolve ORA-00313 in Oracle Database

Error:

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

In case of Dataguard, Standby Database Issues follow the following steps to resolve in Standby Environment:

Step 1: Check the logfiles and see the invalid log files

set lines 300 pages 300
col MEMBER for a80
select * from v$logfile;

Step 2: If you encounter this error on a standby database, you may need to manage the standby file manually.

ALTER SYSTEM SET standby_file_management=manual;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Step 3: Clear the log file groups:

ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 2;
ALTER DATABASE CLEAR LOGFILE GROUP 3;

Step 4: Start the recovery again and put standby_file_management to auto state

ALTER SYSTEM SET standby_file_management=auto;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Hopefully it will fix the issue