Which archivelog contains your SCN ?


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

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

Latest posts by Cyrille Modiano (see all)

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

2 thoughts on “Which archivelog contains your SCN ?

Leave a Reply