Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

async io error message

async io error message

We upgraded Oracle to 10g on the production and standby databases. We are using home grown scripts not DataGusard to update the standby. Now when we replay the archive logs to update the standby database we get the following message. "OS async I/O limit 128 is lower than recovery batch 642". The job is now taking more than twice as long to apply the logs. We are running on HP-UX 11.11 and don't have the async drivers in the kernel on either Production or Standby servers. Are there kernel parameters that need updating? Do I need to install async in the kernel even if I'm not using raw disk?
We are asking Oracle the same questions.
Thank you in advance.

"Good judgment comes from experience. Experience comes from bad judgment." -- Barry LePatner
5 REPLIES
Steven E. Protter
Exalted Contributor

Re: async io error message

Shalom,

There may be a problem in your asynchronous i/o setup.

See this document:
http://blog.chinaunix.net/u/12960/showart_446628.html

http://hpux-tips.blogspot.com/2006/01/how-to-enable-asynchronous-io-disk-hp.html

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=103995

Check the last one first.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com

Re: async io error message

We are not using async at all. This procedure worked fin under Oracle 920. This started happening with the upgrade to 10g. Is there something new in The oracle parameters that has a default of async? Do I need to add async even if I don't use it?

Dave
"Good judgment comes from experience. Experience comes from bad judgment." -- Barry LePatner
Josef Watzko
Occasional Advisor

Re: async io error message

Hi,
we are seeing the same behaviour on HP-UX 11.31 with Oracle 10.2.0.4.0 too (message "OS async I/O limit ..." and slow replay of archive logs).
Someone else has a hint.

Josef

Aneesh Mohan
Honored Contributor

Re: async io error message

Hi,

Could you please post
#kmtune -q max_async_ports


Aneesh
Josef Watzko
Occasional Advisor

Re: async io error message

Hi,

#kctune -q max_async_ports
Tunable Value Expression Changes
max_async_ports 4096 Default Immed

Josef