There are times, like when we perform a restore, where we need to know which archive log file has a particular sequence or SCN. With the following query you can obtain the archive log file. Logically we need know the SCN we seek. The sentence would be like this.
SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND -- IF RAC IS ENABLE ----- <My specific SCN> BETWEEN FIRST_CHANGE# AND NEXT_CHANGE# -- My SCN --- /
SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE THREAD#=2 AND 216149709709 BETWEEN FIRST_CHANGE# AND NEXT_CHANGE# /
We no need to perform the query on the GV$ARCHIVED_LOG, perform it on V$ARCHIVED_LOG is sufficient.
HTH – Antonio NAVARRO