Unsolved
This post is more than 5 years old
19 Posts
0
1341
Oracle RESTORE error
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
AllanW1
334 Posts
0
March 30th, 2010 07:00
Hi Mario,
Moving this one over to the support forum too..
Thanks,
Allan
hamid2
1 Message
0
May 12th, 2010 03:00
Hi,
We solved this problem by putting the ip-addresses of the clients in each others hosts file?
Best Regards
Hamid
snthr
12 Posts
0
May 12th, 2010 03:00
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
elvinperez
87 Posts
0
May 14th, 2010 09:00
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,
ble1
2 Intern
2 Intern
•
14.3K Posts
0
June 3rd, 2010 02:00
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....