Know the archived log sequence # And find out which backuppiece the archived log belongs .,

Know the archived log sequence # And find out which backuppiece the archived log belongs .,

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 2015Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options08:35:52 sys@FS> select recid,set_stamp,sequence#,first_change#,next_change#08:36:01   2         from  v$backup_redolog;     RECID  SET_STAMP  SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#---------- ---------- ---------- ------------- ------------      1700  870903865       1231      23692915     23720698      1701  870903865       1233      23727009     23758185      1702  870903865       1234      23758185     23787101      1703  870903865       1242      23932089     23933585      1704  870903865       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     24175154      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      1719  872372688       1244      23953931     23953937      1720  872372688       1252      24076221     24096147      1721  872372688       1246      23962525     23987530      1722  872372688       1247      23987530     24007645      1723  872372688       1251      24039725     24076221      1724  872372688       1250      24007694     24039725      1725  872372688       1253      24096147     24117164      1726  872372688       1248      24007645     24007678      1727  872372688       1249      24007678     24007694      1728  872372749       1260      24190837     24198609      1729  872372749       1261      24198609     24198614xxx rows selected.Elapsed: 00:00:00.7008:36:02 sys@FS> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            h:\fsarch2Oldest online log sequence     1260Next log sequence to archive   1262Current log sequence           126208:37:15 sys@FS> set line 20008:37:28 sys@FS> col handle format a4008:36:17 sys@FS> select r.sequence#, p.handle08:37:13   2    from 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 sys@FS>

 

Reference:

How To Locate What Files Are Backed Up In What RMAN Backup Set (Document ID 246189.1)