Re: Catalog RMAN backups on Tape?
Date: Mon, 25 Jan 2010 14:45:24 -0500
This is NetBackup 6.5 and Oracle 10.2.0.4.
I see the tapes as full in NB. I want to restore the RMAN backups to the file system where I can catalog them there, but I do not see how to do that because I cannot see the backups? I see regular backups, but Oracle seems to be treating differently and NB doesn't let you see them. Does anyone have experience with this? May have to reach out to NB with help on this one.
On Mon, Jan 25, 2010 at 2:36 PM, Robert Freeman <robertgfreeman_at_yahoo.com>wrote:
> The catalog command does not support SBT devices (at least in 11g and 10g
> and I think going back forever). So you can't re-catalog the backup pieces.
> Also there is no guarantee that the tapes won't be marked as deleted on the
> catalog of the tape system, so you might have double trouble there.
> If it's a BIG deal, you could get an older control file from before the
> crosscheck to use for restore purposes. It should still have the records in
> it for the backups. Hopefully the pieces are still there and not marked as
> deleted on the silo catalog.
> If you know the backup set pieces on the tape devices are intact, you can
> write PL/SQL code to access them. This becomes a bit complex (I used to have
> to do it all the time in the Oracle 8 days for various reasons). Metalink
> used to have articles on how to do this.
> Automating the delete after the crosscheck is dangerous when you are using
> SBT...... :)
> 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
> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
> 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:* Thomas Roach <troach_at_gmail.com>
> *To:* Oracle Discussion List <oracle-l_at_freelists.org>
> *Sent:* Mon, January 25, 2010 11:34:46 AM
> *Subject:* Catalog RMAN backups on Tape?
> We had an issue with one of our scripts where it did a crosscheck and
> because our tapes weren't in the cabinet, they got marked and removed. I
> know how to catalog backups that are on disk, but is anyone aware of the
> steps for doing tapes?
-- Thomas Roach 813-404-6066 troach_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 25 2010 - 13:45:24 CST