RE: Does the Rman Catalog hold tape volume names?
Date: Tue, 10 Feb 2009 16:05:28 -0500
Thanks for the info. I'm aware of disk and tape backups. I'm talking about tape backups.
Still waiting for my SA to verify that the numbers reported in the media column are actually tape numbers.
From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Tuesday, February 10, 2009 4:02 PM To: Mercadante, Thomas F (LABOR); D'Hooge Freek; oracle-l_at_freelists.org Subject: RE: Does the Rman Catalog hold tape volume names?
Just beware - the information from the media column will be useless if your backup is going to a disk staging area before it goes to tape, and it also won't tell you if your backup spanned multiple tapes, or if it was migrated later to a different tape from the original by your media management software. It's really just there for looks - it can't be relied on.
What is the retention on your backups? Maybe it's only 14 days and 1/29 is still within that policy, but 1/27 is not?
If you were on Netbackup, I'd recommend using the bplist and/or bpclimagelist commands to search the Netbackup catalog directly for your backups, but I don't know what the equivalent is for TSM.
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 Tue Feb 10 2009 - 15:05:28 CST