Hi, Sorry for coming back to old post but I made some additional research. There is a possibility to catalog backup pieces using RMAN and not only using dbms_backup_restore. 1. identify a list of backup sets on tapes using Media Manager commands ex. for EMC Networker (Legato) you can use - ./sbin/mminfo -q "client=piorovm" -r "ssid,name,totalsize,savetime,volume" ssid name total date volume 4267926146 RMAN:3bl4n6ru_1_1 9961944 01/29/2010 piorovm.localdomain.001 4234372063 RMAN:3dl4n76v_1_1 805331112 01/29/2010 piorovm.localdomain.001 4217594914 RMAN:3el4n792_1_1 1389143616 01/29/2010 piorovm.localdomain.001 4200817814 RMAN:3fl4n7cl_1_1 477378960 01/29/2010 piorovm.localdomain.001 2. catalog backup piece using RMAN and name from output above RMAN> catalog device type 'sbt_tape' backuppiece '3fl4n7cl_1_1'; released channel: ORA_SBT_TAPE_1 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=149 device type=SBT_TAPE channel ORA_SBT_TAPE_1: NMO v5.0.0.0 cataloged backup piece backup piece handle=3fl4n7cl_1_1 RECID=107 STAMP=709599788 3. RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 81 Full Unknown SBT_TAPE 00:00:00 29-JAN-10 BP Key: 107 Status: AVAILABLE Compressed: NO Tag: TAG20100129T224333 Handle: 3fl4n7cl_1_1 Media: List of Datafiles in backup set 81 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 3 Full 8788185 29-JAN-10 +DATA/pioro/datafile/undotbs1.261.695313067 Of course for other Media Manager command in point number 1 are different but you can find command for Netbackup in Allen mail. ps. I will write a blog post about it soon. regards, Marcin Przepiorowski http://oracleprof.blogspot.com/ On Tue, Jan 26, 2010 at 4:42 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote: > Here’s an example of the Netbackup command (bplist): > > > > unx01.baanprd /opt/oracle ->bplist -t 4 -k <YOUR_policy_name> -l -s > 1/25/2010 -e 1/26/2010 -R / > > -rw------- oracle oracle 12582912 Jan 25 21:21 > /c-18889999-20100125-09 > > -rw------- oracle oracle 2359296 Jan 25 21:18 > /baanprd_al_52855_1_709244222 > > -rw------- oracle oracle 3383296K Jan 25 21:15 > /baanprd_db_52852_1_709243545 > > > > And, here is the related command (bpclimagelist) that you use to check the > retention settings in Netbackup: > > > > unx01.baanprd /opt/oracle ->bpclimagelist -t ANY -policy <YOUR_policy_name> > -ct 4 -s 1/25/2010 -e 1/26/2010 > > Backed Up Expires Files KB C Sched Type Policy > > ---------------- ---------- -------- ----------- - ------------ > ------------ > > 01/25/2010 21:20 02/08/2010 5 12320 N User Backup > TAR_DP-Oracle-BAANPRD-hot > > 01/25/2010 21:17 02/08/2010 5 2336 N User Backup > TAR_DP-Oracle-BAANPRD-hot > > 01/25/2010 21:07 02/08/2010 5 3383328 N User Backup > TAR_DP-Oracle-BAANPRD-hot > > > > Note that these commands are pretty picky so you have to get them just right > (e.g. policy name is case-sensitive, must have client and server configured > correctly, or set them correctly with command-line parameters) or they’ll > just return “EXIT STATUS 227: no entity was found”. > > > > Also, the bpclimagelist command is the client version of bpimagelist, and I > think it’s only referred to as bpimagelist in the documentation. > > > > Regards, > > Brandon > > > > From: Robert Freeman [mailto:robertgfreeman@xxxxxxxxx] > > The key with dbms_backup_restore is that you need to know the piece names > you are dealing with. I know there is a way with Netbackup to get these > names > > > > ________________________________ > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed > by it. > -- //www.freelists.org/webpage/oracle-l