alter database activate standby database；

oerr ora 00313
00313, 00000, "open failed for members of log group %s of thread %s"
// *Cause:  The online log cannot be opened. May not be able to find file.
// *Action: See accompanying errors and make log available.

oerr ora 00312
00312, 00000, "online log %s thread %s: '%s'"
// *Cause:  This message reports the filename for details of another message.
// *Action: Other messages will accompany this message. See the
//          associated messages for the appropriate action to take.

oerr ora 0027037
27037, 00000, "unable to obtain file status"
// *Cause:  stat system call returned an error, additional information
//          indicates which function encountered the error
// *Action: check errno

alter database activate standby database;

alter database clear logfile group 34;

alter database drop logfile group 34;

--预警日志
alter database clear logfile group 34
Clearing online log 34 of thread 1 sequence number 220
Errors in file /opt/oracle/diag/rdbms/xbltestbak/baipx1/trace/baipx1_ora_2844.trc:
ORA-00313: open failed for members of log group 34 of thread 1
ORA-00312: online log 34 thread 1: '/redo/XBLTESTBAK/onlinelog/o1_mf_34_k5lm6ccs_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /opt/oracle/diag/rdbms/xbltestbak/baipx1/trace/baipx1_ora_2844.trc:
ORA-00313: open failed for members of log group 34 of thread 1
ORA-00312: online log 34 thread 1: '/redo/XBLTESTBAK/onlinelog/o1_mf_34_k5lm6ccs_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Deleted Oracle managed file /redo/XBLTESTBAK/onlinelog/o1_mf_34_k5lm6ccs_.log
Thu May 19 10:17:14 2022
Completed: alter database clear logfile group 34


--预警日志
alter database drop logfile group 34
Deleted Oracle managed file /redo/XBLTESTBAK/onlinelog/o1_mf_34_k8cb4mo5_.log
Completed: alter database drop logfile group 34

select database_role, open_mode from v$database;

select f.group# AS groupId, f.type as type, l.thread# AS thread from v$logfile f left join v$log l on f.group# = l.group#;

select f.group# AS groupId, f.type as type, l.thread# AS thread from v$logfile f left join v$log l on f.group# = l.group# where f.type = 'ONLINE';

select f.group# AS groupId, f.type as type, l.thread# AS thread from v$logfile f left join v$log l on f.group# = l.group# where f.type = 'STANDBY';