RMAN Images are missing in the catalog
RMAN Images are missing in the catalog
Our DBA's even start the Oracle restores and it also works for years.
Now I have a very strange case.
Our DBA's store the RMAN backups in their Oracle RMAN Catalog on for 2 months. I keep the RMAN backup images for 3 months ( netbackup retentiopn level -> 3month).
Now, a 10-week-old database must be restored and our DBA has set up an older RMAN catalog from the backup.
Based on this recovered RMAN Catalog a restore will fail.
Which Netbackup logfile i can check to see the successfull backup of the needed Netbackup Images?
Does anyone have an idea?
And here the RMAN log file:
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Feb 27 09:44:46 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: CLF (not mounted)
connected to recovery catalog database
RMAN>
executing command: SET DBID
database name is "CLF" and DBID is 3819197101
RMAN> 2> 3> 4> 5>
allocated channel: ch00
channel ch00: SID=42 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013061020)
executing command: SET until clause
Starting restore at 27-FEB-14
channel ch00: starting datafile backup set restore
channel ch00: restoring control file
channel ch00: reading from backup piece c-3819197101-20131209-01
channel ch00: ORA-19870: Fehler beim Zuruckschreiben von Backup Piece c-3819197101-20131209-01
ORA-19507: Fehler beim Abrufen der sequentiellen Datei, Handle="c-3819197101-20131209-01", Parameter=""
ORA-27029: skgfrtrv: sbtrestore hat Fehler zuruckgegeben
ORA-19511: Fehler von Media Manager-Ebene empfangen, Fehlertext:
Backup file <c-3819197101-20131209-01> not found in NetBackup catalog
failover to previous backup
channel ch00: starting datafile backup set restore
channel ch00: restoring control file
channel ch00: reading from backup piece c-3819197101-20131209-00
channel ch00: ORA-19870: Fehler beim Zuruckschreiben von Backup Piece c-3819197101-20131209-00
ORA-19507: Fehler beim Abrufen der sequentiellen Datei, Handle="c-3819197101-20131209-00", Parameter=""
ORA-27029: skgfrtrv: sbtrestore hat Fehler zuruckgegeben
ORA-19511: Fehler von Media Manager-Ebene empfangen, Fehlertext:
Backup file <c-3819197101-20131209-00> not found in NetBackup catalog
....
Thomas,
the Recovery Catalog from Oracle (RMAN Catalog or even the controlfile) and Netbackup Catalog are 2 separate repositories and usally have to keep in sync.
Therefore a maintainance operation should be run on the Oracle Side (CROSSCHECK, DELETE OBSOLTE, ...) at least every day.
Is that the case at your site. Does the database admin did some maintainance commands. If yes (and he did a DELETE OBSOLTE e.g. ) RMAN will delete the files even on the Netbackup Side (netbackup images).
If the DBA restores an old Recovery Catalog it will not help, because the backup pieces are already gone on the Netbackup side and the entries in the RMAN cataog points to nowhere.
Possibly the is the case at your side.
Regards
Marko