How to get all the archive logs in a backup piece

From: Ganesh <ganesh.tambat_at_gmail.com>
Date: Sat, 8 Nov 2008 03:09:01 -0800 (PST)
Message-ID: <e2623355-4846-4bed-a9d8-6dc483b2a2ee@q26g2000prq.googlegroups.com>


Is there any way I can get all the archive log files present in a backup piece. I tried following but it always gives me all the log files for each piece:



SQL> select s.set_stamp, s.set_count, s.PIECES, s.backup_type,
s.controlfile_included from v$backup_set s, v$backup_piece p where
s.set_stamp=p.set_stamp and s.set_count=p.set_count and
p.handle='5mjv4do0_1_1';

SQL> select unique resetlogs_change# from v$backup_redolog where set_stamp=670185216 and set_count=1206;

SQL> select unique name, TO_CHAR(FIRST_TIME, 'MMDDYYYYHH24MISS'), TO_CHAR(NEXT_TIME, 'MMDDYYYYHH24MISS'), (BLOCKS*BLOCK_SIZE), TO_CHAR(COMPLETION_TIME, 'MMDDYYYYHH24MISS') from v$archived_log where resetlogs_change#=569317 AND name IS NOT NULL;


Thanks in advance,
Ganesh Tambat Received on Sat Nov 08 2008 - 05:09:01 CST

Original text of this message