OCP Oracle DBA in Montreal at DBSoft
Latest posts by Cyrille Modiano (see all)
- OCP 12C – Resource Manager and Performance Enhancements - 24/10/2014
- OCP 12C – SQL Enhancements - 23/10/2014
- OCP 12C – DataPump, SQL*Loader, External Tables Enhancements - 22/10/2014
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#;