In one of my primary databases, I had several old standby redo log files that were forgotten from a previous relocation using Data Guard.
They could all be dropped at this point.
set lines 200
col member format a50
select s.group#,s.thread#,s.sequence#,s.archived,s.status,f.member, f.type
from v$standby_log s, v$logfile f
where f.type = 'STANDBY'
and s.group# = f.group#;
GROUP# THREAD# SEQUENCE# ARC STATUS MEMBER TYPE
---------- ---------- ---------- --- ---------- -------------------------------------------------- -------
6 1 0 YES UNASSIGNED /data03/oradata/prod01/onlinelog/stb_redo06.log STANDBY
7 1 0 YES UNASSIGNED /data03/oradata/prod01/onlinelog/stb_redo07.log STANDBY
8 1 0 YES UNASSIGNED /data03/oradata/prod01/onlinelog/stb_redo08.log STANDBY
9 1 0 YES UNASSIGNED /data03/oradata/prod01/onlinelog/stb_redo09.log STANDBY
10 1 0 YES UNASSIGNED /data03/oradata/prod01/onlinelog/stb_redo10.log STANDBY
11 1 0 YES UNASSIGNED /data03/oradata/prod01/onlinelog/stb_redo11.log STANDBY
Syntax for dropping:
SQL> alter database drop standby logfile group n;
In my case
alter database drop standby logfile group 6;
alter database drop standby logfile group 7;
etc etc.
The official Oracle 19c Alter Database documentation is here
