ASM "NORMAL" Redundancy MIRROR Fails , Places The Datafile In RECOVER Mode (Doc ID 1495164.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

On : 11.1.0.7 version, STORAGE

ASM "NORMAL" redundancy MIRROR fails , places the datafile in RECOVER mode

To simulate we can setup a diskgroup 2x 50G raw disks in ASM with normal redundancy. Then create a TEST tablespace and table and then we can manually pull the disk out, ASM and RDBMS don't cope and the datafile ends up in RECOVER state.

ERRORS:
ASM:
ORA-27072: File I/O error
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 54272
Additional information: -1
WARNING: IO Failed. subsys:System dg:5, diskname:/dev/oracle/asmdisk20 disk:0x0.0xf0f29100 au:53
  iop:0x9ffffffffd10c000 bufp:0x9ffffffffd20fe00 offset(bytes):55574528 iosz:1048576 operation:2(Write) synchronous:1
  result: 4 osderr:0x0 osderr1:0x0 pid:20494
ERROR: failed to copy file +CYF_DATA.256, extent 0

RDBMS:
Errors in file /u01/app/oracle/admin/Xcyf/diag/diag/rdbms/xcyf/Xcyf2/trace/Xcyf2_ckpt_21410.trc:
ORA-27063: number of bytes read/written is incorrect
WARNING: IO Failed. subsys:System dg:5, diskname:/dev/oracle/asmdisk20 disk:0x0.0xf0f29100 au:53
  iop:0x9ffffffffd40d320 bufp:0x9ffffffffd211a00 offset(bytes):55582720 iosz:8192 operation:1(Read) synchronous:0
  result: 4 osderr:0x0 osderr1:0x0 pid:21410
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 256 in group 5 from disk 0 allocation unit 53; if possible, will try ano
ther mirror side
NOTE: successfully read mirror side 2 of virtual extent 0 logical extent 1 of file 256 in group 5 from disk 1 allocation unit 53
Errors in file /u01/app/oracle/admin/Xcyf/diag/diag/rdbms/xcyf/Xcyf2/trace/Xcyf2_ckpt_21410.trc:
ORA-27063: number of bytes read/written is incorrect
WARNING: IO Failed. subsys:System dg:5, diskname:/dev/oracle/asmdisk20 disk:0x0.0xf0f29100 au:53
  iop:0x9ffffffffd40cbb0 bufp:0x9ffffffffd211a00 offset(bytes):55582720 iosz:8192 operation:2(Write) synchronous:0
  result: 4 osderr:0x0 osderr1:0x0 pid:21410
Errors in file /u01/app/oracle/admin/Xcyf/diag/diag/rdbms/xcyf/Xcyf2/trace/Xcyf2_ckpt_21410.trc:
ORA-15080

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