I use NetBackup to call a unix shell script to perform database backups. The Oracle backups are configured to automatically backup the control files upon the completion of the backups of the database files.
My backups go to DataDomain virtual disk. The DataDomain disk in my datacenter is automatically replicated to a second DataDomain device at my DR site.
I have stopped the synchronization between the two DataDomains and am now trying to restore my databases. I have connected to RMAN on the DR server and issued the "Restore Controlfile" command. The output says:
channel CH1: starting datafile backupset restore
channel CH1: restoring control file
channel CH1: reading from backup piece PASPROD_c-1968089396-20130901-00
ORA-19870: error reading backup piece PASPROD_c-1968089396-20130901-00
ORA-19507: failed to retrieve sequential file, handle="PASPROD_c-1968089396-20130901-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <PASPROD_c-1968089396-20130901-00> not found in NetBackup catalog. failover to previous backup
When I connect to RMAN and do a "list backup of controlfile;", I see all the media is listed as "@aaaac" which is the copy of the backup at my primary datacenter. The media at the DR site is actually "@aaaae". I know this because I've already gone into the NetBackup Administration Console and selected all the @aaaae media and made it the "Primary Copy".
Has anyone seen a problem like this before? Does anyone have a recommendation on how I might fix it?
Thanks in advance for any help.
Ken
