Highlighted
8 Krypton

Oracle RESTORE error

Hi all,

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

Tags (2)
0 Kudos
5 Replies
8 Krypton

Re: Oracle RESTORE error

Hi Mario,

Moving this one over to the support forum too..

Thanks,

Allan

0 Kudos
hamid2
1 Copper

Re: Oracle RESTORE error

Hi,

We solved this problem by putting the ip-addresses of the clients in each others hosts file?

Best Regards

Hamid

0 Kudos
snthr
6 Indium

Re: Oracle RESTORE error

When error like that occurred in my environment it was problem with CFI. Check that you have CFI on NW server for that backup and that the tape is in media db.

Run nsrinfo –n oracle client_name

BR,

Bojan

0 Kudos
8 Krypton

Re: Oracle RESTORE error

Hello Mario,

Which oracle version you have installed in production, in the RMAN database, if you use RMAN and Oracle versions where you want to retrieve.

Regards,

0 Kudos
8 Krypton

Re: Oracle RESTORE error

Can you confirm df_GRIDDB_3851_1obl9grgo_1_1 is in the source index and target client has privviledge to read it?

Also, when looking at your RMAN script, I see 3 different NSR clients being used.  Not sure I follow you there....

0 Kudos