archivelog_containing_scn
The archivelog files containing requested SCN
select THREAD#,sequence# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#-1;
Source link.https://www.dba-scripts.com/scripts/administration/archivelog-containing-scn/
archivelog_containing_scn.txt · Last modified: 2018/02/20 11:44 by admin
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
