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@(protected)
[mailto:oracle-l-bounce@(protected) -
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