RE: RMAN Tape Media Volume Identification

  • To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, <jim.silverman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 May 2007 08:39:22 -0400

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.

Tom


--------------------------------------------------------
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 [mailto:Brandon.Allen@xxxxxxxxxxx] 
Sent: Thursday, May 03, 2007 6:56 PM
To: Mercadante, Thomas F (LABOR); jim.silverman@xxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN Tape Media Volume Identification

You can get the tape volume from rc_backup_piece.media, 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-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
jim.silverman@xxxxxxxxxxx

We have need to obtain information from RMAN including the specific tape
volumes on which various backupsets are written.
--
//www.freelists.org/webpage/oracle-l


Other related posts: