Home / Find the archivelog from the scn Find the archivelog from the scn 10467 views Less than a minute 0 You can get the archivelog sequence number containing a specific scn. select sequence# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#;