RE: EXT :Re: RMAN fails with ora-19501 - ora-27070

From: Schauss, Peter (ESS) <"Schauss,>
Date: Tue, 22 Oct 2013 19:31:07 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0D1EC01D_at_XMBVAG74.northgrum.com>

Nassyam,
It seems unlikely that DISK_ASYNC_IO would be the issue because the other database on this server also has files on this disk and has no problems with rman.

FWIW, I determined that the error is coming from a LOB segment which belongs to XDB.

-Peter Schauss

From: Nassyam Basha [mailto:nassyambasha_at_gmail.com] Sent: Tuesday, October 22, 2013 10:49 AM To: Schauss, Peter (ESS)
Cc: oracle-l
Subject: EXT :Re: RMAN fails with ora-19501 - ora-27070

Hi Peter,
I faced almost similar kind of issue 10g on windows platform but unable to recall either it is exact or not. Can you check what is the value is set for DISK_ASYCH_IO ? In my case it was TRUE(default) and after working with MOS suggested to set as FALSE based on our environment(I/O, disk,....), However worth check as said by Andrew regarding datafile status with dbv. Thanks & Regards,
Nassyam Basha,
www.oracle-ckpt.com<http://www.oracle-ckpt.com>

On Tue, Oct 22, 2013 at 7:49 PM, Schauss, Peter (ESS) <peter.schauss_at_ngc.com<mailto:peter.schauss_at_ngc.com>> wrote: This is Oracle 11.2.0.3 running on Windows 2008 r2 - 64 bit.

Rman fails with the following errors:

RMAN-03002: failure of backup plus archivelog command at 10/22/2013 09:33:44

ORA-19501: read error on file "<drive>:<path>\SYSAUX01.DBF", block number 61760 (block size�92)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1) Incorrect function.

There are no messages in the alert log and end users have not reported any issues. The other database which has files on the same drive is not reporting any rman errors.

Since I took over as DBA for this environment, I have been working my way through setting up rman on 15 production databases, so the only "backup" we have was made with expdp. Is there any workaround for this problem short of rebuilding the database from scratch and importing the data?

Thanks,
Peter Schauss

--

http://www.freelists.org/webpage/oracle-l

--

Thanks & Regards,
Nassyam Basha.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 22 2013 - 21:31:07 CEST