Hi Grzegorz,
As an interesting case of corruption of backup I may add problem with
wrongly set MTU on IB interfaces used to communicate with ZFS
Appliance.
"Wrongly set " I mean correct value regarding to "Oracle Sun Database
Machine X2-2/X2-8, X3-2/X3-8 and X4-2 Performance Best Practices (Doc
ID 1274475.1)" but wrong for specific environment
Pozdrawiam / Regards,
Paweł
On Mon, 12 Dec 2016 21:23:26 +0100
GG <grzegorzof@xxxxxxxxxx> wrote:
Hi guys,
just want to share the issue during rman active duplicate for standby
(both pull and push) in
Oracle 12 Oct2016 PSU Exadata x5 .
First I hit bug solved via DISABLE_OOB=on in sqlnet.ora .
Then
Full restore complete of datafile 2 to datafile copy
+DATAC1/GGCPRD_SP/343463B5BC029BCAE0534380CC0A005C/DATAFILE/system.978.930146259.
Elapsed time: 0:00:15
checkpoint is 173478379
last deallocation scn is 173276653
Fri Dec 09 13:58:39 2016
Corrupt block 70167 found during reading backup piece, file=network,
corr_type=3
Continuing reading piece network, no other copies available.
Fri Dec 09 13:59:07 2016
Datafile rdba reconstruction error, expected block greater than
140983, got 140862 for datafile 3
Corrupt block 125161 found during reading backup piece, file=network,
corr_type=4
Continuing reading piece network, no other copies available.
Corrupt block 125162 found during reading backup piece, file=network,
corr_type=-2
Continuing reading piece network, no other copies available.
Corrupt block 125163 found during reading backup piece, file=network,
corr_type=-2
from rman session :
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service
GGCPRD_LU channel ORA_AUX_DISK_1: specifying datafile(s) to restore
from backup set channel ORA_AUX_DISK_1: restoring datafile 00001 to
+DATAC1 channel ORA_AUX_DISK_1: restore complete, elapsed time:
00:01:06 channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service
GGCPRD_LU channel ORA_AUX_DISK_1: specifying datafile(s) to restore
from backup set channel ORA_AUX_DISK_1: restoring datafile 00002 to
+DATAC1 channel ORA_AUX_DISK_1: restore complete, elapsed time:
00:00:25 channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service
GGCPRD_LU channel ORA_AUX_DISK_1: specifying datafile(s) to restore
from backup set channel ORA_AUX_DISK_1: restoring datafile 00003 to
+DATAC1 PSDRPC returns significant error 600.
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
=============== RMAN-00571:
===========================================================
RMAN-03002: failure of Duplicate Db command at 12/09/2016 13:59:09
RMAN-05501: aborting duplication of target database RMAN-03015: error
occurred in stored script Memory Script
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
ORA-19849: error while reading backup piece from service GGCPRD_LU
ORA-12592: TNS:bad packet
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
ORA-19661: datafile 3 could not be verified
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
ORA-19849: error while reading backup piece from service GGCPRD_LU
ORA-12592: TNS:bad packet
Got SR but no progress there .
Maybe anyone hit something similiar ?
My to check list:
-- deep packet inspection
-- source DB corruption (but rman backup validate reports no errors).
Regards
GG
--
//www.freelists.org/webpage/oracle-l
