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@xxxxxxxxxxx] 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. -- //www.freelists.org/webpage/oracle-l