How to retrieve a REDO file name containing a specific sequence?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #8825
    Frank Knot
    Participant

    I have an Oracle Log Based Capture exception, which contain a sequence number XXXX . How can I see the actual REDO file name, which contains the specific sequence?

    #8827
    Frank Knot
    Participant

    For archive logs, you have to run:

    select thread#, sequence#, first_time, next_time, name from v$archived_log where sequence# = XXXX order by thread#, sequence#

    For online logs:

    select l.thread#, l.sequence#, l.first_time, l.next_time, f.member from v$log l, v$logfile f where l.group# = f.group# and sequence# = XXXX ;

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us