Re: Does the Rman Catalog hold tape volume names?

From: David Barbour <david.barbour1_at_gmail.com>
Date: Wed, 11 Feb 2009 10:54:23 -0500
Message-ID: <69eafc3f0902110754n43e3ec86ya226ec41b8b7e35_at_mail.gmail.com>

Currently, I'm using RMAN with AX/TSM. I can categorically state the number in the media column IS NOT the tape number. I've actually run through this with Tivoli Support.

Not only is there the issue of disk-to-tape with respect to TSM, there's also the issue of Storage Pool Migration and/or Reclamation. The tape your backup is initially sent to may not be (probably won't be) the tape from which it is retrieved.

To find the backup, you need to query the TSM database.

You say RMAN has the backup cataloged. Get the handle from your recovery catalog table bp. If you have rights in TSM you can run this, otherwise, it's going to be up to your SA:

select volume_name from contents where file_name = '<RMAN File Handle>'

On Tue, Feb 10, 2009 at 10:37 PM, Kevin Lidh <kevin.lidh_at_gmail.com> wrote:

> Kevin,
>
> When I used the script in combination with legato networker, I noticed that
> the media column had sometimes more then 1 media id in it (separated by a
> comma).
>
> I have quickly checked with a netbackup configuration, but I don't have a
> case in which a backup piece is split over 2 tapes.
> Do you remember which version of netbackup was used?
>
> regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> e-mail: freek.dhooge_at_uptime.be
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
> disclaimer
> ________________________________________
> From: Kevin Lidh [kevin.lidh_at_gmail.com]
> Sent: 10 February 2009 22:33
> To: Thomas.Mercadante_at_labor.state.ny.us
> Cc: Allen, Brandon; D'Hooge Freek; oracle-l_at_freelists.org
> Subject: RE: Does the Rman Catalog hold tape volume names?
>
> When I worked at an organization that backed up directly to tape, we ran
> into issues where a backup piece would span more than one tape (maybe it
> started towards the end of one). In that case, the catalog was only
> aware of the first tape ID. Our SA had to run some NetBackup script to
> get the whole tape list and ensure it was available.
>
> On Tue, 2009-02-10 at 16:05 -0500, Mercadante, Thomas F (LABOR) wrote:
> > Brandon,
> >
> > 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.
> >
> > Thanks
> >
> > Tom
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 11 2009 - 09:54:23 CST