Database Software

Hi Friends,

Our current scenario is,
Oracle 11.1.0.7 EE
AIX 5
Netbackup 7.1

RMAN backups are taken from our prod server (PROD1) to tapes on Netbackup Master Server (NBKS1).
We want to restore the backups on another Server (DRPROD1) which is linked to another netbackup master server (NBKS2). So we moved the tapes from NBKS1 to NBKS2 and then tried the restore as below.

RMAN> set dbid XXXXXXX; --- of the source database

RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'XXXXXX/XXXXXX'

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

RMAN>run {
2> allocate channel c1 type 'SBT_TAPE';
3> send 'NB_ORA_SERV=NBKS2, NB_ORA_CLIENT=PROD1';
4> restore spfile to pfile '/backup/initprod_test.ora' from autobackup until time 'SYSDATE-1';
5> release channel c1;
6> }

It says the autobackup found but when it tries to restore below errors are generated.

channel c1: looking for autobackup on day: 20120911
channel c1: autobackup found: c-1152196367-20120911-03


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/12/2012 14:24:46
ORA-19870: error while restoring backup piece c-1152196367-20120911-03
ORA-19507: failed to retrieve sequential file, handle="c-1152196367-20120911-03", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file <c-1152196367-20120911-03>

Please advise on the parameters or options that are to be taken into consideration for the restore to be successful.

Thanks in advance :)