Corruption (Fractured block ) on physical standby database

(Doc ID 1314439.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms


Physical standby database

Recovery works fine but there is a corruption error listed within the alert*.log/trace-files:


Hex dump of (file 464, block 182228) in trace file /oracle/diag/rdbms/premtn/premtn101/trace/premtn101_pr01_1697136.trc
Corrupt block relative dba: 0x7402c7d4 (file 464, block 182228)
Fractured block found during media recovery
Data in bad block:
type: 6 format: 2 rdba: 0x7402c7d4
last change scn: 0x085a.4cd521f8 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x658f0601
check value in block header: 0xe483
computed block checksum: 0x4477
Reading datafile '/oracle22/oradata/premtn920/index1/tps_index_large_26.dbf' for corruption at rdba: 0x7402c7d4 (file 464, block 182
228)

Media Recovery Log /arch2/premtn920/premtn92_630177063_1_526997.arc
Media Recovery Log /arch2/premtn920/premtn92_630177063_1_526998.arc


DBV runs fine against the primary database, against the standby database fallowing errors are listed:


dbv file=/oracle22/oradata/premtn920/index1/tps_index_large_26.dbf blocksize=8192

DBVERIFY: Release 11.2.0.1.0 - Production on Thu Apr 7 16:15:48 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle22/oradata/premtn920/index1/tps_index_large_26.dbf

DBV-00600: Fatal Error - [25] [61618] [0] [1140]

6. After DBV failed a RMAN validate datafiles was performed against the same datafile, this was succesful.

RMAN> validate datafile '/oracle22/oradata/premtn920/index1/tps_index_large_26.dbf';

Starting validate at 07-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3472 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00464 name=/oracle22/oradata/premtn920/index1/tps_index_large_26.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:19:36
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
464 OK 0 5774 2097152 9184124577638
File Name: /oracle22/oradata/premtn920/index1/tps_index_large_26.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 2088104
Other 0 3274

Finished validate at 07-APR-11

Changes

Standby was rebuilt using disk based mirroring (Hitachi True Copy).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms