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

Arturo Gutierrez <[email protected]> Thu, 29 Apr 2010 23:08:34 +0200
Newsgroups gmane.linux.suse.oracle.general
Message-ID <[email protected]>
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
>>     
>
>   


-- 




          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