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

Arturo,
Any dbwriter trace which displays:
WARNING:Oracle process running out of OS kernel I/O resources 

If that’s the case, maybe you are hitting BUG:5609038

Set these parameters as a workaround:
disk_asynch_io = false
filesystemio_options = none

Alessandro Guimaraes
-----Mensagem original-----
De: [email protected]
[mailto:[email protected]] Em nome de Arun Singh
Enviada em: quinta-feira, 29 de abril de 2010 18:14
Para: Arturo Gutierrez
Cc: [email protected]
Assunto: Re: [suse-oracle] ORA-27061: waiting for async I/Os failed with
RMAN 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

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