RE: RMAN Tape Media Volume Identification

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Fri, 4 May 2007 09:43:36 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45071FDC01@NT15.oneneck.corp>

One more detail I forgot to include - the rc_backup_piece.media column will only report the first tape that the backup piece gets written to. If you have a large database, there is a good chance it will span multiple tapes and I don't believe RMAN will ever record any of the other tapes.

Regards,
Brandon

-----Original Message-----

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com]

You can get the tape volume from rc_backup_piece.media

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 Received on Fri May 04 2007 - 11:43:36 CDT