Re: [suse-oracle] RES: ORA-27061: waiting for async I/Os failed withRMAN Backup

I recommend to add DB writers if you disable async io. Or much better just 
upgrade the kernel.


----- Original Message ----- 
From: "Alessandro Guimarães" <[email protected]>
To: "'Arturo Gutierrez'" <[email protected]>; 
"'Alexei_Roudnev'" <[email protected]>
Cc: <[email protected]>; "'Arun Singh'" <[email protected]>
Sent: Friday, April 30, 2010 6:33 AM
Subject: [suse-oracle] RES: ORA-27061: waiting for async I/Os failed 
withRMAN Backup


Hi Arturo,

None disables ASYNC IO and DIRECT IO so that Oracle uses normal synchronous
writes, without any direct io options.
To use direct io set filesystemio_options=DIRECTIO

Alessandro Guimaraes

-----Mensagem original-----
De: [email protected]
[mailto:[email protected]] Em nome de Arturo Gutierrez
Enviada em: sexta-feira, 30 de abril de 2010 06:34
Para: Alexei_Roudnev
Cc: [email protected]; Arun Singh
Assunto: Re: [suse-oracle] ORA-27061: waiting for async I/Os failed withRMAN
Backup

Hello,
I'll change the parameter:
filesystemio_options to none to avoid the problem.

Do you know if direct I/O will be done to bypass the Linux Buffer Cache
if this parameters is set to none?

Thanks
Arturo



Alexei_Roudnev escribió:
> Yes:
> - this parameter affect RMAN
> - there is not any way to configure RMAN mode different
> - SLES10 SP2 release had a big preventing rman from working in this
> mode (later udpates fixed it).
>
>
> ----- Original Message ----- From: "Arun Singh" <[email protected]>
> To: "Arturo Gutierrez" <[email protected]>
> Cc: <[email protected]>
> Sent: Thursday, April 29, 2010 2:14 PM
> Subject: Re: [suse-oracle] ORA-27061: waiting for async I/Os failed
> withRMAN Backup
>
>
> Hello Arturo,
>
>> We had modify the parameter:
>> filesystemio_options=SETALL more than 1 month ago, and the database work
>> fine.
>> Is possible that this parameter affect to this Rman error?
>
> Yes, it's coming from AIO portion of kernel code and I am sure kernel
> update will fix this. Also. SLES10 SP3 is latest and it's includes
> this fix.
>
> Thanks,
> Arn
>
>>>> On 4/29/2010 at 2:08 PM, Arturo Gutierrez
> <[email protected]> wrote:
>> Hello Arun,
>>
>> Thanks for you fast response.
>>
>> Also sometimes the error is:
>>
>> RMAN-00571: ===========================================================
>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>> RMAN-00571: ===========================================================
>> RMAN-03009: failure of backup command on c1 channel at 04/29/2010
>> 00:14:44
>> ORA-19502: write error on file
>>
"/flasharea/PRO/oracle/backup_SIEBEL_set29076_piece1_20100429_cklc9v75_1_1",

>>
>>
>> blockno 56705 (blocksize=8192)
>> ORA-27061: waiting for async I/Os failed
>> L*inux-x86_64 Error: 28: No space left on device*
>> Additional information: -1
>> Additional information: 1048576
>>
>> This is extrange because the file system has only 63% used.
>>
>> ....
>> We had modify the parameter:
>> filesystemio_options=SETALL more than 1 month ago, and the database work
>> fine.
>> Is possible that this parameter affect to this Rman error?
>>
>>
>> Thanks
>> Arturo
>>
>> Arun Singh escribió:
>>> Hello  Arturo,
>>>
>>> Please update to latest kernel update, as similar bug is fixed in
>>> post SP2
>> update.
>>>
>>> Thanks,
>>> Arun
>>>
>>>
>>>>>> On 4/29/2010 at 12:44 PM, Arturo Gutierrez
>>>>>>
>>> <[email protected]> wrote:
>>>
>>>
>>>> Hello,
>>>>
>>>> We're receiving this error into Rman backup.
>>>>
>>>> input archive log thread=1 sequence=1231 recid=1214 stamp=715871001
>>>> input archive log thread=1 sequence=1232 recid=1215 stamp=715911673
>>>> channel c1: starting piece 1 at 23-APR-10
>>>> released channel: c1
>>>> RMAN-00571:
>>>> ===========================================================
>>>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
>>>> ===============
>>>> RMAN-00571:
>>>> ===========================================================
>>>> RMAN-03009: failure of backup command on c1 channel at 04/23/2010
>>>> 00:17:27
>>>> ORA-19502: write error on file
>>>>
"/flasharea/PRO/oracle/backup_SIEBEL_set28685_piece1_20100423_0dlbq4vr_1_1",

>>>>
>>
>>>>
>>>> blockno 25856001 (blocksize=512)
>>>> ORA-27061: waiting for async I/Os failed
>>>> Linux-x86_64 Error: 5: Input/output error
>>>> Additional information: -1
>>>> Additional information: 1048576
>>>>
>>>> Recovery Manager complete.
>>>>
>>>> The env is:
>>>> SuSE Linux Enterprise Server 10 Service Pack 2  X64
>>>>
>>>> Oracle 10.2.0.4 EE
>>>>
>>>>
>>>>
>>>> Any idea about the cause?
>>>>
>>>> Many thanks
>>>> Arturo
>>>>
>>>
>>>
> _______________________________________________
> suse-oracle mailing list
> [email protected]
> http://listx.novell.com/mailman/listinfo/suse-oracle
>


-- 




          Arturo Gutiérrez Gómez


          Formador/Consultor  Tecnologias Oracle

Oracle DBA Certified Professional OCP  [7.3-10g]
Oracle Real Application Clusters Certified profesional


          Movíl 61 64 70 190




* *

* *

* *

/ /

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

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

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