Reply to Message

Reply to Message

View discussion in a popup

Replying to:
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