Re: Catalog RMAN backups on Tape?

From: Robert Freeman <>
Date: Tue, 26 Jan 2010 08:44:54 -0800 (PST)
Message-ID: <>

Is there a netbackup command to extract these to disk without RMAN?


 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!

From: "Allen, Brandon" <>
To: Robert Freeman <>; "" <>; "" <>
Cc: "" <>
Sent: Tue, January 26, 2010 9:42:46 AM
Subject: RE: Catalog RMAN backups on Tape?

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.
From:Robert Freeman [] 

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.
Received on Tue Jan 26 2010 - 10:44:54 CST

Original text of this message