Oracle—V$FOREIGN_ARCHIVED_LOG/END_OF_REDO_TYPE

Possible values are as follows:

SWITCHOVER - Shows archived redo log files that are produced at the end of a switchover

TERMINAL - Shows archived redo log files produced after a failover

RESETLOGS - Shows online redo log files archived on the primary database after an ALTER DATABASE OPEN RESETLOGS statement is issued

ACTIVATION - Shows any log files archived on a physical standby database after an ALTER DATABASE ACTIVATE STANDBY DATABASE statement is issued

“empty string” - Any empty string implies that the log is just a normal archival and was not archived due to any of the other events

https://docs.oracle.com/en/database/oracle/oracle-database/23/refrn/V-FOREIGN_ARCHIVED_LOG.html