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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
jim.silverman_at_thomson.com

We have need to obtain information from RMAN including the specific tape volumes on which various backupsets are written.

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.

--
http://www.freelists.org/webpage/oracle-l