Hi list,

When trying to restore an Oracle database through RMAN to a different location, 
like other server, I get the following:

RMAN> connect rcvcat rmanemc/rmanemc@rmanprd
> 
>connected to recovery catalog database
> 
>RMAN> connect target /
> 
>connected to target database: GRIDDB (DBID=
> 
>RMAN> run
>2> {ALLOCATE CHANNEL t1 type 'SBT_TAPE' ;
>3> ALLOCATE CHANNEL t2 type 'SBT_TAPE' ;
>4> ALLOCATE CHANNEL t3 type 'SBT_TAPE' ;
>5> send channel t1 'NSR_ENV=(NSR_SERVER=bkptempo02.tempopar.backupnet, 
>NSR_CLIENT=orstempo01_bkp.tempopar.backupnet)';
>6> send channel t2 'NSR_ENV=(NSR_SERVER=bkptempo02.tempopar.backupnet, 
>NSR_CLIENT=orstempo02_bkp.tempopar.backupnet)';
>7> send channel t3 'NSR_ENV=(NSR_SERVER=bkptempo02.tempopar.backupnet, 
>NSR_CLIENT=orstempo03_bkp.tempopar.backupnet)';
>8> set newname for datafile 1 to '/oradata/griddb/system.264.701344271';
>9> set newname for datafile 2 to '/oradata/griddb/undotbs1.256.701344275';
>10> set newname for datafile 3 to '/oradata/griddb/sysaux.265.701344275';
>11> restore datafile 1;
>12> restore datafile 2;
>13> restore datafile 3;
>14> }
> 
>allocated channel: t1
>channel t1: sid=321 devtype=SBT_TAPE
>channel t1: NMO v5.0.0.0
> 
>allocated channel: t2
>channel t2: sid=320 devtype=SBT_TAPE
>channel t2: NMO v5.0.0.0
> 
>allocated channel: t3
>channel t3: sid=319 devtype=SBT_TAPE
>channel t3: NMO v5.0.0.0
> 
>sent command to channel: t1
> 
>sent command to channel: t2
> 
>sent command to channel: t3
> 
>executing command: SET NEWNAME
> 
>executing command: SET NEWNAME
> 
>executing command: SET NEWNAME
> 
>Starting restore at 27/03/2010 11:28:57
> 
>7395 
>channel t1: starting datafile backupset restore
>channel t1: specifying datafile(s) to restore from backup set
>restoring datafile 00001 to /oradata/griddb/system.264.701344271
>channel t1: reading from backup piece df_GRIDDB_3851_1obl9grgo_1_1
>ORA-19870: error reading backup piece df_GRIDDB_3851_1obl9grgo_1_1
>ORA-19507: failed to retrieve sequential file, 
>handle="df_GRIDDB_3851_1obl9grgo_1_1", parms=""
>ORA-27029: skgfrtrv: sbtrestore returned error
>ORA-19511: Error received from media manager layer, error text:
>   Could not locate the LNM save file 'df_GRIDDB_3851_1obl9grgo_1_1' on server 
> 'bkptempo02.tempopar.backupnet'. (2:9:2)
>failover to previous backup
> 
>channel t1: starting datafile backupset restore
>channel t1: specifying datafile(s) to restore from backup set
>restoring datafile 00001 to /oradata/griddb/system.264.701344271
>channel t1: reading from backup piece df_GRIDDB_3758_1lel9bdc4_1_1



Mario



To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER