Reply To: How to retrieve a REDO file name containing a 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 ;

© 2020 HVR

Test drive Contact us