Re: RMAN - correlating Backup Media to RMAN Catalog
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: jkstill@xxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 Nov 2008 11:52:06 -0800 (PST)
Right off hand I'm not aware of any way to do what you want. Could you backup
the backupsets with RMAN to the vaulted media instead? That might solve this
problem?
RF
Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
________________________________
From: Jared Still <jkstill@xxxxxxxxx>
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, November 3, 2008 11:16:49 AM
Subject: RMAN - correlating Backup Media to RMAN Catalog
Here's the platform info:
RMAN catalog - 10.2.0.3 on Windows 2003 Server
TARGET db: 9.2.0.7 on RH EL 4
BACKUP SW: NetBackup 6.0
The problem in a nutshell is that the MEDIA ID stored in the RMAN catalog
does not correspond to the MEDIA ID stored to in the NBU catalog.
This happens when the media is copied to new media. The new Media ID
of course does not match what is in RMAN. This new media is sent off site,
the original media is reused.
If a query such as this is run:
select d.name, p.MEDIA, p.handle, p.start_time,p.completion_time,p.bytes
from rc_backup_piece p, rc_database d
where d.NAME = 'ORCL'
and d.dbid = 123456789
and p.COMPLETION_TIME >= TO_DATE('05/01/2008', 'mm/dd/yyyy')
and p.COMPLETION_TIME <= TO_DATE('05/03/2008', 'mm/dd/yyyy')
and p.db_id = d.dbid
order by p.media
The MEDIA column contains the information for the original media.
This is verified by running the query for a recent backup, one that has
not yet been vaulted. In this case the query returns the correct MEDIA ID.
So, if the previous query is used to identify the media required to restore
a backup from media that has been vaulted (say 5 months old), the MEDIA
ID will be incorrect.
Does anyone here know how to update the MEDIA column in RMAN with
the current MEDIA ID's?
I tried the following - it doesn't change the MEDIA column:
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
CROSSCHECK BACKUP
COMPLETED BETWEEN "to_date('05/01/2008','mm/dd/yyyy')" and
"to_date('05/03/2008','mm/dd/yyyy')";
RELEASE CHANNEL;
Thanks,
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
