Which archivelog contains your SCN ?

Notice: get_currentuserinfo is deprecated since version 4.5.0! Use wp_get_current_user() instead. in /home/dbascrip/public_html/wp-includes/functions.php on line 3828

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft


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

2 thoughts on “Which archivelog contains your SCN ?

Leave a Reply