Maybe I'm missing something here, but wouldn't there have to be a way to extract the pieces from tape without RMAN? Otherwise how would non-RMAN backups work? I'd list out the commands but I've never used Netbackup - we used Legato NetWorker in the past. We wrote a number of scripts involving NetWorker commands to aid us in management of the whole process (of course that's after getting sudo for them first, the tough part). We needed this kind of access since it was the DBAs who set defined the offsite tape rotation and were responsible for all tape estimate needs. Dave Herring | DBA, Acxiom Database Services 630-944-4762 office | 630-430-5988 cell | 630-944-4989 fax 1501 Opus Pl | Downers Grove, IL, 60515 | U.S.A. | www.acxiom.com Service Desk: 888-243-4566, https://servicedesk.acxiom.com, GSCA@xxxxxxx ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman Sent: Tuesday, January 26, 2010 10:45 AM To: Allen, Brandon; troach@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Cc: sims@xxxxxxx Subject: Re: Catalog RMAN backups on Tape? Is there a netbackup command to extract these to disk without RMAN? RF Robert G. Freeman Oracle ACE Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author: 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 Blog: http://robertgfreeman.blogspot.com Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare! ________________________________________ From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> To: Robert Freeman <robertgfreeman@xxxxxxxxx>; "troach@xxxxxxxxx" <troach@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Cc: "sims@xxxxxxx" <sims@xxxxxxx> 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. 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. *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** -- //www.freelists.org/webpage/oracle-l