Home Topics HVR Real-time Replicator Community Discussions How to retrieve a REDO file name containing a specific sequence?
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?
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 ;
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.