Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN Tape Media Volume Identification

RE: RMAN Tape Media Volume Identification

From: <>
Date: Fri, 4 May 2007 08:51:31 -0400
Message-ID: <E2157B37A63D2E4B9B00575021FC84D6010EE20C@tshusmian2msg01.ERF.THOMSON.COM>

Thanks for the followup, Tom.

This timing couldn't be better, since even as we speak I'm diddling around with querying the RC_BACKUP_PIECE and related views. Since my primary need is to identify the volumes on which expired backups resides, it seems a rather straightforward task to simply retrieve this information from this view (after having run a CROSSCHECK).

Thanks again for the guidance. Have a good weekend!

Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641
FAX:            734-930-7611

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

From: Mercadante, Thomas F (LABOR)
[] Sent: Friday, May 04, 2007 8:39 AM
To: Allen, Brandon; Silverman, James (TH USA); Subject: RE: RMAN Tape Media Volume Identification

I stand corrected! Thanks Brandon! I checked the same column and spoke with our backup folks. The value stored in our database in this column is what Brandon was talking about - a "domain storage pool name" which is a disk staging area. Tivoli will move these files to tape at a later time.


This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

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

From: Allen, Brandon [] Sent: Thursday, May 03, 2007 6:56 PM
To: Mercadante, Thomas F (LABOR);;
Subject: RE: RMAN Tape Media Volume Identification

You can get the tape volume from, at least I do with Netbackup, but it may be different with other MMLs. Actually, I used to get this info back when we went straight to tape, but now our Netbackup server uses a disk staging area to facilitate the high volume of backups we run, so when RMAN writes the backup to the MML, it actually just goes to the Netbackup disk staging area and then Netbackup puts it on tape later on its own time so now we don't get the actual tape names in the media column anymore.

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

[] On Behalf Of Mercadante, Thomas F (LABOR) I don't think you will find the specific tape volume information in the Rman repository. This is managed by the Media Management software.

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

[] On Behalf Of

We have need to obtain information from RMAN including the specific tape volumes on which various backupsets are written.
-- Received on Fri May 04 2007 - 07:51:31 CDT

Original text of this message