Commvault Oracle RMAN Restore to new host
- by Glenn Stauffer
We use Commvault Simpana 8 and I have a situation where I have backups of an Oracle database on tape that were taken from Host A. Host A suffered a disk failure (lost its raid configuration) and the sys admins are trying to restore it; in the meantime, I'd working to bring the database back up on another host - Host B.
I'm running into problems and am trying to sort out the parameters that need to be passed to the Commvault media agent to get this to work. Unfortunately, I do not have access to Commvault support and the backup person is unavailable.
Any one have a clue?
The backups are there and the media agent reported a successful write when they ran last night.
This is what fails:
run {
allocate channel t1 device type sbt_tape parms='SBT_LIBRARY=/usr/local/galaxy/Base/libobk.so,BLKSIZE=262144, ENV=(CvClientName=dbsrv2,CvInstanceName=Instance001, CVOraSID=BBPROD)';
restore spfile to pfile '/tmp/bbdb.ora' from autobackup;
}
allocated channel: t1
channel t1: sid=34 devtype=SBT_TAPE
channel t1: CommVault Systems for Oracle: Version 7.0.0(Build76)
Starting restore at 09-MAY-10
channel t1: looking for autobackup on day: 20100509
channel t1: autobackup found: c-3941155360-20100509-01
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/09/2010 18:01:35
ORA-19870: error reading backup piece c-3941155360-20100509-01
ORA-19507: failed to retrieve sequential file, handle="c-3941155360-20100509-01", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[0] thread[26316]: InitializeCLRestore() failed.
