OCP Oracle DBA in Montreal at Desjardins
Latest posts by Cyrille Modiano (see all)
- Renaming a RAC cluster - 27/09/2018
- Stop/Start all RAC databases at once - 26/09/2018
- RMAN Backup script - 08/11/2017
Description
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;
NEXT_CHANGE# scn is not included in archivelogs. It is up to NEXT_CHANGE#-1.
Hi,
Thank you very much, I updated the query.
Cyrille