Problem restore Oracle RMAN

Check ip/name definition in hosts file. Probably not resolve name and send this error.

Is this a redirect recover (on other than production server machine)? If so, you have to put the name of the production server (or make it any other way resolveable) to hosts file on the machine on which you want to recover DB.

We need more info to be able to help you out
We need to see the rman script and exactly what kind of recovery you are doing, directed recovery....?
HTH

Hi Guys,

Following more detais:


A full description of the issue.


We have backup of Oracle RAC.

environment:

physical Node 1: prdb03.xxx
physical node 2: prdb04.xxx
virtual node: prdb04-vip.xxx

physical node for restore: prdb05.xxx
(Direct Restore, ok)


The backup is successful.
The restore starts normally but displays the following message and aborted:


channel t1: starting datafile backupset restore channel t1: specifying datafile(s) to restore from backup set restoring datafile 00016 to +DG1/dpf05p/datafile/asinp100l03.dbf
restoring datafile 00030 to +DG1/dpf05p/datafile/asinp100l13.dbf
restoring datafile 00052 to +DG1/dpf05p/datafile/asinp100l26.dbf
restoring datafile 00061 to +DG1/dpf05p/datafile/aprom100d07.dbf
restoring datafile 00070 to +DG1/dpf05p/datafile/asti100l08.dbf
channel t1: reading from backup piece /FULL_ONLINE_DPF05P_DPF05P_3iklc4th/
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
We could not read the checksum. (0:3:2)
ORA-19870: error reading backup piece /FULL_ONLINE_DPF05P_DPF05P_3iklc4th/
ORA-19501: read error on file "/FULL_ONLINE_DPF05P_DPF05P_3iklc4th/", blockno 131250177 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned error
ORA-19511: Error received from media manager layer, error text channel t1: starting datafile backupset restore channel t1: specifying datafile(s) to restore from backup set restoring datafile 00002 to +DG1/dpf05p/datafile/undotbs1_01.dbf
restoring datafile 00021 to +DG1/dpf05p/datafile/aprom100d03.dbf
restoring datafile 00040 to +DG1/dpf05p/datafile/asinp100l15.dbf
restoring datafile 00056 to +DG1/dpf05p/datafile/asinp100l28.dbf
restoring datafile 00074 to +DG1/dpf05p/datafile/asinp100l40.dbf
channel t1: reading from backup piece /FULL_ONLINE_DPF05P_DPF05P_3oklc7t5/

######################################################################################################






2). A full description of this implementation.

Server Networker: networker-cti.cti.xxx
W2k3 EE SP2
NW 7.5.1.Build.269

PRDB04 and prdb03:
Red Hat Enterprise AS 4 (Release 4) IA64Bits
Oracle: 10.2.0.4 Bits: 64 bits
NW 7.5.1.Build.269
NMO: NMO v5.0.0.0

PRDB05:
Red Hat Enterprise AS 4 (Release 4) X86_64
Oracle: 10.2.0.4 64 bits
NW 7.5.1.Build.269
NMO v5.0.0.0

License: PRDB03 and PRDB04 Dedicated SN
PRDB05 Storage Node


45 installed clients.
Environment only exists Oracle agent installed.

Library: EDL 4406 not use Embedded Storage Node for EDL.


###################################################################


Script Restore:


. /home/oracle/.bash_profile
data=`date +%Y%m%d-%Hh%Mm`
export ORACLE_SID=dpf05p
$ORACLE_HOME/bin/rman target / cmdfile=/home/oracle/scripts/rman/restore_sbt_tape.sql log=/home/oracle/scripts/rman/log/restore_sbt_tape_${ORACLE_SID}${data}.log

cat /home/oracle/scripts/rman/log/restore_sbt_tape_${ORACLE_SID}${data}.log | mail -s " RESTORE PRDB05 - 10.61.100.100 " sbd.sst.cti@xxx
cat /home/oracle/scripts/rman/log/restore_sbt_tape_${ORACLE_SID}${data}.log | mail -s " RESTORE PRDB05 - 10.61.100.100 " sso.sst.cti@xxx


run{
startup nomount;
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
allocate channel t5 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
allocate channel t6 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
allocate channel t7 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=networker-cti.xxx,NSR_CLIENT=prdb04-vip.xxx)';
restore controlfile from 'DPF05P_c-3778656815-20090729-29';
alter database mount;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 7;
restore database;
recover database;
sql 'ALTER DATABASE OPEN';
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
release channel t6;
release channel t7;
}


#########################################################################

Message was edited by:
Hormigo

anyone have any idea?

Is prdb04-vip.xxx defined in prdb05-vip.xxx host file? I have same error and resolution is define that entrie in hosts file.

Is a RAC environment?

Regards

1. prdb04-vip.xxx has to have entry in the prdb05.xxx hosts file (or has to be resolvable by any other way) with even fake IP. Probably you have to put also those two physical nodes also.
2. Add prdb05.xxx to remote access list on prdb04-vip.xxx

I will Check.

Hi,

Can you please try from other tape....using some other date ???

Thanks

We are work with EDL, ok.

Already test with other time, other controlfile, other tape...
I removed Device Multiplex, and the error continues....

Any other suggestion?

The DNS is resolving the names correctly.

Remote Access is ok too.

Any other suggestions?

anyone have any idea?

I forgot...check rpc comunication between all systems.

Did you try only FS restore? Of course if you have FS backup for this client too.
You will be sure that it is not a network problem.