Database Restoration into newhost-DR- Could not catalog a backupiece..
Hi Friends...
We are doing a DR exercise of our current system...We have a 2 node rac on soalris sparc 10 with oracle 11g r2.03 for one our crictical system , Its on the ASM file system on a Sunzfs 7420 box...
We use EMC Networker to backup to Proxy tape library(EMC Data Domain) and then cloning to TApe...
Now we have restored the backups from the tapes to EMC DD( Proxy tape librayr),,Catalog database has been restored to different machine....we are restoing a one month old backup to a new host...
1. Catalog restored
2. Tape clone copied to EMC datadomian( different volume than the backup)
3. we have deleted a backup handle from the restored catalog as per suggestion from EMC becuase we couldnbt restore earlier...
3. we need to catalog the backup handle again to the RMAN Catalog...
Below are the things we did....
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
allocated channel: ORA_MAINT_SBT_TAPE_2
channel ORA_MAINT_SBT_TAPE_2: SID=83 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_2: NMDA Oracle v1.2.0
RMAN> catalog device type 'sbt_tape' backuppiece 'c-3901098745-20121231-00';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 02/18/2013 11:26:57
RMAN-06471: no configuration found to allocate channels for SBT_TAPE
RMAN> catalog backuppiece 'c-3901098745-20121231-00';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 02/18/2013 11:27:07
ORA-01507: database not mounted
RMAN> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'c-%F';
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
RMAN> catalog backuppiece 'c-3901098745-20121231-00';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 02/18/2013 11:27:26
ORA-01507: database not mounted
This server had anoither DB running and we have shutdown the instance to make room for this Instance...Its on ASM instance....
ANy help would be appreciated
we tried this as well
RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bk-**********,NSR_CLIENT=bk-*********,NSR_DATA_VOLUME_POOL=Oracle Restore)';
RMAN-03002: failure of configure command at 02/18/2013 12:42:35
ORA-01507: database not mounted
Edited by: Maran Viswarayar on Feb 18, 2013 12:44 PM