Re: [suse-oracle] 10.2.0.2l.0 + SLES 10 + SP2 + ext3 + filesystemio_options=setall --> archiver error

Looks as exactly the same error which we had in SLES9 SP4 kernels 308 and 
311.


----- Original Message ----- 
From: "Ronny Egner" <[email protected]>
To: "Alexei_Roudnev" <[email protected]>
Sent: Thursday, July 24, 2008 7:19 AM
Subject: 10.2.0.2l.0 + SLES 10 + SP2 + ext3 + 
filesystemio_options=setall --> archiver error


Hi Alexei,

i have observed some strang thing and would like to ask
if you can verify this:

When using 10g Rel. 2 (here: 10.2.0.2.0) with SLES 10 SP2
(64-bit) and ext3 and filesystemio_options=setall the archiver
gets stuck:

ORA-19502: write error on file
"/u03/oraarch/SONTST10/1_573_655903791.dbf", blockno 364545 (blocksize=512)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file
"/u03/oraarch/SONTST10/1_573_655903791.dbf", blockno 364545 (blocksize=512)
Thu Jul 24 16:08:21 2008
Errors in file /u01/app/oracle/admin/SONTST10/bdump/sontst10_arc1_31723.trc:
ORA-19502: write error on file
"/u03/oraarch/SONTST10/1_573_655903791.dbf", blockno 364545 (blocksize=512)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file
"/u03/oraarch/SONTST10/1_573_655903791.dbf", blockno 364545 (blocksize=512)
ARC1: I/O error 19502 archiving log 3 to
'/u03/oraarch/SONTST10/1_573_655903791.dbf'
ARC1: Failed to archive thread 1 sequence 573 (19502)
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Jul 24 16:08:21 2008
ORACLE Instance SONTST10 - Archival Error




Tracing the process with strace yields:



pwrite(24, "\1\"\0\0\1X\5\0_\2\0\0\0\200\344?1070\003231\377\1N\377"...,
1048576, 179307008) = 1048576
times(NULL)                             = 1726320259
pread(23,
"\1\"\0\0\1`\5\0_\2\0\0X\201\307\17\1\200\00536830\377\001"..., 1048576,
180355584) = 1048576
times(NULL)                             = 1726320259
pwrite(24,



************ HERE ******************

"\1\"\0\0\1`\5\0_\2\0\0X\201\307\17\1\200\00536830\377\001"..., 1048576,
180355584) = -1 EIO (Input/output error)

************ HERE ******************

pread(23, "\1\"\0\0\1h\5\0_\2\0\0\0\200r\311\2`;\37\2\301\2\00337"...,
1048576, 181404160) = 1048576
times(NULL)                             = 1726320264
pread(23, "\1\"\0\0\1\240\5\0_\2\0\0004\200\276\212\377\7xh\4\17\17"...,
1048576, 188744192) = 1048576
times(NULL)                             = 1726320287
close(13)                               = 0
open("/u01/app/oracle/admin/SONTST10/bdump/alert_SONTST10.log",
O_WRONLY|O_APPEND|O_CREAT, 0664) = 13
writev(13, [{"Fri Jul 18 09:00:25 2008\n", 25}, {"ARC1: Encountered disk
I/O error"..., 38}, {"\n", 1}], 3) = 64
times(NULL)                             = 1726320287
times(NULL)                             = 1726320287
times(NULL)                             = 1726320287
times(NULL)                             = 1726320287
write(2, "*** 2008-07-18 09:00:25.832", 27) = 27
write(2, "\n", 1)                       = 1
write(2, "*** 2008-07-18 09:00:25.832 6063"..., 40) = 40
write(2, "\n", 1)                       = 1
times(NULL)                             = 1726320287
times(NULL)                             = 1726320287
write(2, "ARC1: Encountered disk I/O error"..., 38) = 38
write(2, "\n", 1)                       = 1
close(13)                               = 0



I was able to reproduce this on two different systems
with plain SLES10 + SP2 (64-bit) installed.



Thanks in advance
-- 
Mit freundlichen GrЭъen

Ronny Egner
Diplom-Ingenieur (BA)
Systeme & Service
Oracle DBA

Telefon: +49 381 2524-422
Telefax: +49 381 2524-399


SIV.AG - Service fЭr Informationsverarbeitung AG
Hauptsitz: Konrad-Zuse-Str. 1, 18184 Roggentin
Handelsregister: Amtsgericht Rostock, HRB 8677, Ust.-IdNr.: DE 137477226
Vorstand: JЖrg Sinnig (Vorsitzender), Andreas Lehmann, Arno Weichbrodt
Aufsichtsratsvorsitzender: Thomas Huth

*************************************************************************
Aus RechtsgrЭnden ist die in dieser E-Mail gegebene Information nicht
rechtsverbindlich. Eine rechtsverbindliche BestДtigung reichen wir
Ihnen auf Anforderung in schriftlicher Form nach. Diese Nachricht ist
ausschlieъlich fЭr den Adressaten oder dessen Vertreter bestimmt.

The information contained in this email is not legally binding.
At your request, we will provide you with a legally binding confirmation
in written form. This message is intended solely for the addressee,
entity to which the email is addressed or the authorised agent.

*************************************************************************






_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle