| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Getting all tapes used out of RMAN
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
"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 [mailto:Brandon.Allen_at_OneNeck.com]
> 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$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.
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 25 2006 - 11:47:28 CDT
 |
 |