Which archivelog contains your SCN ?

Cyrille Modiano
Latest posts by Cyrille Modiano (see all)


This query returns the archivelog sequence containing a scn. This could be usefull in case you want to manually recover a standby database until a scn or just want to know which arvhivelog you should copy to recover the standby.

Archivelog containing your SCN

select sequence# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#-1;

2 thoughts on “Which archivelog contains your SCN ?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.