Problem restore Oracle RMAN

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.

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

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

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?

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.