RE: Getting all tapes used out of RMAN

Yes Dave, I don't think it is stored anywhere in RMAN when a backup piece extends beyond a single tape. Here is the definition of the v$backup_piece.media column from the 10.2 documentation:

MEDIA VARCHAR2(65) Name of the media on which the backup piece resides. This value is informational only; not needed for restore.

I think that last sentence is key. Basically it's just storing the first tape name as a favor, but it's not really necessary for RMAN to keep track of the tapes used by the media manager - that is the media manager's job. When restore time comes, Oracle just sends the client name and file name, and the media manager will look it up in its own catalog to determine where it should grab it from - which might not even be the same tape it was originally written to - in the case that you have duplication like we do. Also, in our case with Netbackup, we don't even write directly to tape anymore - we write to a disk pool first, and then Netbackup writes from there to tape on its own time. This increases the throughput of our backup system. When we do this, Oracle just stores pretty meaningless data in the MEDIA field - like this: /NBDP1/XYZ/xyzunx01_1153837292_C1_F1, so I have no visibility to what tape my backup might be on within RMAN - I have to query the Netbackup catalog to find that info.

Regards,
Brandon

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Herring Dave - dherri

Is it really not stored anywhere in RMAN that piece blah, blah, blah was written to WF0033 and continued onto WF0010?

Dave

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