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
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;