RE: Does the Rman Catalog hold tape volume names?

From: Allen, Brandon <>
Date: Tue, 10 Feb 2009 14:17:18 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E111A3BB526_at_ONEWS06.oneneck.corp>

I'm not sure if we're on the same page - I know you're talking about "tape" backups, but in real life, what you might think of as a "tape" backup could very likely go to a disk staging unit used by your media management software (TSM in your case, Netbackup in mine). As far as Oracle/RMAN is concerned this is a "tape" backup through the sbt_tape device type, but really it's sitting on disk until your media management software gets around to moving it off to tape (which may even be never). This is a very common practice to improve the performance of backups & restores due to the limited speed & capacity of tapes. If this is the case in your environment, then you won't get a tape label in your RMAN media column - you'll just get some mostly useless identifier for the disk path that your media management software used for staging the backup.


-----Original Message-----

From: Mercadante, Thomas F (LABOR) []

Thanks for the info. I'm aware of disk and tape backups. I'm talking about tape backups.

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 Feb 10 2009 - 15:17:18 CST

Original text of this message