Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11gR2 on Windows 2008R2 istnace crash du to write async fail

alemarNov 2 2011 — edited Jun 11 2012

Hi guys,

I need urgent help with an oracle 11gr2 x64 +ASM on Windows 2008 R2 (on VMware vsphere 4.1).

I had no problem installing and configuring the entire environment but randonmly i receive the following very bad errors:

These errors caused the instance to crash immediately (and then it has restarted thanks to oracle restart).
The Oracle Version is 11.2.0.1 with patchset 11 installed on both oracle home and Grid Home.

All the ASM disks are VMDK disk form the point of view of vmware.

Can anybody help me?

Thank you very much

Alessandro

Wed Nov 02 01:30:14 2011
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):0.0xf0f004ea disk_path:\\.\ORCLDISKDATA0
AU:123365 disk_offset(bytes):129357578240 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):1.0xf0f004eb disk_path:\\.\ORCLDISKDATA1
AU:123354 disk_offset(bytes):129346043904 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):0.0xf0f004ea disk_path:\\.\ORCLDISKDATA0
AU:123333 disk_offset(bytes):129324023808 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):1.0xf0f004eb disk_path:\\.\ORCLDISKDATA1
AU:123322 disk_offset(bytes):129312489472 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):1.0xf0f004eb disk_path:\\.\ORCLDISKDATA1
AU:123290 disk_offset(bytes):129278935040 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):1.0xf0f004eb disk_path:\\.\ORCLDISKDATA1
AU:123258 disk_offset(bytes):129245380608 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):1.0xf0f004eb disk_path:\\.\ORCLDISKDATA1
AU:123226 disk_offset(bytes):129211826176 io_size:32768 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-27070: lettura/scrittura asincrona non riuscita
WARNING: IO Failed. group:1 disk(number.incarnation):1.0xf0f004eb disk_path:\\.\ORCLDISKDATA1
AU:89 disk_offset(bytes):93929472 io_size:16384 operation:Write type:asynchronous
result:I/O error process_id:3832
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 454 logical extent 0 of file 256 in group 1 on disk 1 allocation unit 89
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 708681 logical extent 0 of file 276 in group 1 on disk 1 allocation unit 123226
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 708873 logical extent 0 of file 276 in group 1 on disk 1 allocation unit 123258
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 709065 logical extent 0 of file 276 in group 1 on disk 1 allocation unit 123290
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 709257 logical extent 0 of file 276 in group 1 on disk 1 allocation unit 123322
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 709321 logical extent 0 of file 276 in group 1 on disk 0 allocation unit 123333
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 709449 logical extent 0 of file 276 in group 1 on disk 1 allocation unit 123354
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-15080: operazione di I/O sincrono su un disco non riuscita
WARNING: failed to write mirror side 1 of virtual extent 709513 logical extent 0 of file 276 in group 1 on disk 0 allocation unit 123365
KCF: read, write or open error, block=0x2b4b241 online=1
file=8 '+DATA/aidmemp/datafile/aidmemp_lob.276.755702619'
error=15081 txt: ''
Automatic datafile offline due to write error on
file 8: +DATA/aidmemp/datafile/aidmemp_lob.276.755702619
KCF: read, write or open error, block=0x2b4b240 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b4a241 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b4a240 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b47241 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b47240 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b44241 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b44240 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b41241 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x2b41240 online=0
file=8 'MISSING0'
error=15081 txt: ''
KCF: read, write or open error, block=0x71a5 online=1
file=1 '+DATA/aidmemp/datafile/system.256.755696233'
error=15081 txt: ''
Errors in file c:\oracle\diag\rdbms\aidmemp\aidmemp\trace\aidmemp_dbw0_3832.trc:
ORA-01243: file di tablespace di sistema danneggiato dal guasto al supporto
ORA-01114: errore I/O scrivendo blocco su file 1 (blocco n. 29093)
ORA-01110: file di dati 1: '+DATA/aidmemp/datafile/system.256.755696233'
ORA-15081: sottomissione di un'operazione di I/O su un disco non riuscita
ORA-15081: sottomissione di un'operazione di I/O su un disco non riuscita
DBW0 (ospid: 3832): terminating the instance due to error 1243
Wed Nov 02 01:30:19 2011
ORA-1092 : opitsk aborting process
Wed Nov 02 01:30:33 2011
Starting ORACLE instance (normal)

Edited by: user11986082 on 2-nov-2011 11.56

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2012

Added on Nov 2 2011

#11gr2, #general-database-discussions

6 comments

572 views