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#
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
Post a Comment