Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN Tape Media Volume Identification
Jim,
I don't think you will find the specific tape volume information in the Rman repository. This is managed by the Media Management software.
But I've had luck spinning better reports using the Rc_Database, Rc_Backup_Set and Rc_Backup_Piece views.
I agree that Rman reporting is quite lame. But luckily, they have developed a few views to help us along.
Good Luck,
Tom
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
jim.silverman_at_thomson.com
Sent: Wednesday, May 02, 2007 3:29 PM
To: oracle-l_at_freelists.org
Subject: RMAN Tape Media Volume Identification
All:
We have need to obtain information from RMAN including the specific tape volumes on which various backupsets are written. For example, "show me the information in the catalog for backupsets written between date 1 and date 2, including the tape volumes". I've diddled around with the myriad forms of the RMAN "list" command to try and obtain this information, but the only success I've had is using the syntax that includes "primaryKey" (i.e., BS Key) specifiers; without this keyword, the "Media:" field in the output is empty.
Unfortunately, in order to obtain these keys, you first have to issue the "list" command that generates scads of output, parse this output for the BS keys, and then assemble this information into another script that includes these keys in "list" commands in another RMAN session.
This can't be this hard.
Hopefully I'm missing something perfectly obvious. Any clues? TIA...
FAX: 734-930-7611 E-Mail: jim.silverman_at_thomson.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 02 2007 - 15:00:41 CDT
![]() |
![]() |