Which logfile does streams capture want?

Sometimes it can be misleading which logfile streams actually needs to pick up where it left off - this SQL shows exactly which log sequence and filename it needs:

select sequence#, name 
from v$archived_log al, dba_capture cap
where cap.REQUIRED_CHECKPOINT_SCN between al.FIRST_CHANGE# and al.NEXT_CHANGE#

Comments