Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Getting all tapes used out of RMAN

RE: Getting all tapes used out of RMAN

From: Herring Dave - dherri <>
Date: Tue, 25 Jul 2006 11:47:28 -0500
Message-ID: <>

Well that stinks! Not your response (which was awesome), but that Oracle would present something that's useful, only to say you can't depend on it because it may not be complete.

Oh well, guess I'm back to UNIX commands.


Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762

"When I come home from work and see those little noses pressed against the windowpane, then I know I am a success" - Paul Faulkner

> -----Original Message-----
> From: Allen, Brandon []
> Sent: Tuesday, July 25, 2006 11:40 AM
> To: Herring Dave - dherri; Fuad Arshad; oracle-l
> Subject: 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$ column from the 10.2 documentation:
> MEDIA VARCHAR2(65) Name of the media on which the backup piece
> 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
> 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
> even write directly to tape anymore - we write to a disk pool first,
> then Netbackup writes from there to tape on its own time. This
> increases the throughput of our backup system. When we do this,
> 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:
> [] On Behalf Of Herring Dave -
> dherri
> Is it really not stored anywhere in RMAN that piece blah, blah, blah
> written to WF0033 and continued onto WF0010?
> Dave
> Privileged/Confidential Information may be contained in this message
> attachments hereto. Please advise immediately if you or your employer
> not consent to Internet email for messages of this kind. Opinions,
> conclusions and other information in this message that do not relate
> the official business of this company shall be understood as neither
> nor endorsed by it.

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

Received on Tue Jul 25 2006 - 11:47:28 CDT

Original text of this message