Know the archive log sequence# and investigate which backuppiece the archive log is in.

F:\oracle\product\10.2.0\db_1\bin>sqlplus/as sysdbasql*plus:release 10.2.0.4.0-production on Mon Feb 23 08:41:41 2  015Copyright (c) 1982, Oracle. All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit productionwith the part Itioning, OLAP, Data Mining and Real application testing options08:35:52 [email protected]> Select Recid,set_stam     P,sequence#,first_change#,next_change#08:36:01 2 from V$backup_redolog; RECID set_stamp sequence# first_change# next_change#-------------------------------------------------------170 0 870903865 1231 23692915 23720698 1701 870903865 1233 23727009 23758185 1702 8 70903865 1234 23758185 23787101 1703 870903865 1242 23932089 23933585 1704 87090        3865 1243 23933585 23953931 1705 870903865 1241 23903940 23932089 1706 870903865 1244 23953931 23953937 1707 872372688 1254 24117164 24124546 1708 872372688 1255 24124546     24128404 1709 872372688 1256 24128404 24153309 1710 872372688 1259 24184496 24190837 1711 872372688 1258 24175154 24184496 1712 872372688 1257 24153309 2417       5154 1713 872372688 1245 23953937 23962525 1714 872372688 1240 23888188 23903940      1715 872372688 1242 23932089 23933585 1716 872372688 1243 23933585 23953931 1717 872372688 1239 23849112 23888188 1718 872372688 1241 23903940 23932089 17  19 872372688 1244 23953931 23953937 1720 872372688 1252 24076221 24096147 1721 872372688 1246 23962525 23987530 1722 872372688 1247 23987530 24007645 1723 8723 72688 1251 24039725 24076221 1724 872372688 1250 24007694 24039725 1725 872372688 1253 240961     47 24117164 1726 872372688 1248 24007645 24007678 1727 872372688 1249 24007678 24007694 1728 872372749 1260 24190837 24198609 1729 872372749 1261 24198609 2 4198614xxx rows selected. elapsed:00:00:00.7008:36:02 [email protected]> Archive Log list;database log mode archive Modeautoma Tic Archival enabledarchive destination h:\fsarch2Oldest online log sequence 1260Next log seque NCE to archive 1262Current log sequence 126208:37:15 [email protected]> set line 20008:37:28 [EMAIL&NB sp;protected]> col handle format a4008:36:17 [email protected]> select r.sequence#, p.handle08:37:13 2 fro M v$backup_piece p, v$backup_redolog r08:37:13 3 where R.set_stamp = p.set_stamp08:37:13 4 and R.set_count =P.set_count08:37:13 5 and r.sequence# = 125608:37:13 6; sequence# HANDLE--------------------------------------------------1256 H:\FSARCH\ARC_HRPVUMEG_1_1Elapsed: 00:00:00.0408:37:46 [email protected]>

Reference from:

How to Locate what Files is backed up and what RMAN Backup Set (document ID 246189.1)

Know the archive log sequence# and investigate which backuppiece the archive log is in.