ORA-27061: skgfospo: waiting for async I/Os failed_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 2887 | 回复: 0

主题： ORA-27061: skgfospo: waiting for async I/Os failed

Koei111

注册用户

等级：列兵
经验：81
发帖：42
精华：0
注册：2011-7-22
状态：离线
发送短消息息给Koei111

加好友发送短消息息给Koei111

发消息

发表于：

2015-5-21 14:27:41 | [全部帖] [楼主帖]

楼主

ORA-27061: skgfospo: waiting for async I/Os failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10039: error encountered while polling for RPC completion on channel default
RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 and serial=:2
RMAN-10002: ORACLE error: ORA-03113: end-of-file on communication channel
ORA-03114: not connected to ORACLE
RMAN-03002: failure of recover command at 03/02/2010 07:15:30
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u02/backup/1_31141.dbf'
ORA-03113: end-of-file on communication channel

alert.log文件内容：

Media Recovery Log
ORA-279 signalled during: alter database recover if needed
start until canc...
Tue Mar  2 07:15:09 2010
alter database recover logfile '/u02/backup/1_31140.dbf'
Tue Mar  2 07:15:09 2010
Media Recovery Log /u02/backup/1_31140.dbf
ORA-279 signalled during: alter database recover logfile '/u02/backup/1_3114...
Tue Mar  2 07:15:16 2010
alter database recover logfile '/u02/backup/1_31141.dbf'
Media Recovery Log /u02/backup/1_31141.dbf
Tue Mar  2 07:15:26 2010
Errors in file /home/oracle/admin/orcl/bdump/orcl_dbw0_369106.trc:
ORA-27061: skgfospo: waiting for async I/Os failed
IBM AIX RISC System/6000 Error: 22: Invalid argument
Tue Mar  2 07:15:26 2010
DBW0: terminating instance due to error 27061
Tue Mar  2 07:15:28 2010
Errors in file /home/oracle/admin/orcl/bdump/orcl_lgwr_352716.trc:
ORA-27061: skgfospo: waiting for async I/Os failed
Tue Mar  2 07:15:29 2010
Errors in file /home/oracle/admin/orcl/bdump/orcl_ckpt_438366.trc:
ORA-27061: skgfospo: waiting for async I/Os failed
Tue Mar  2 07:15:29 2010
Errors in file /home/oracle/admin/orcl/bdump/orcl_pmon_319782.trc:
ORA-27061: skgfospo: waiting for async I/Os failed
Tue Mar  2 07:15:39 2010
Instance terminated by DBW0, pid = 369106
# more /home/oracle/admin/orcl/bdump/orcl_ckpt_438366.trc
/home/oracle/admin/orcl/bdump/orcl_ckpt_438366.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /home/oracle/product/9.2.0
System name:    AIX
Node name:      db1
Release:        3
Version:        5
Machine:        00C64E4B4C00
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 438366, image: oracle@db1 (CKPT)
*** 2010-03-02 07:15:29.155
*** SESSION ID:(4.1) 2010-03-02 07:15:29.147
error 27061 detected in background process
ORA-27061: skgfospo: waiting for async I/Os failed

oracle版本：Oracle9i Enterprise Edition Release 9.2.0.1.0
os版本：AIX5.3-TL3

这个由于异步IO引起的问题，在AIX 5.3 TL3下，使用文件系统，打开Oracle的异步IO选项的时候，经常会出现。当异步IO的请求（队列）超出MAXREQS的时候，由于AIX上AIOWAIT的问题，会导致返回值是错误的，Oracle发现该错误后，就会出现问题。如果正好是某些重要的后台进程碰到这样的错误，会导致数据库宕掉。

解决方法（三选一，其中第二和第三可以一起使用）：

1、关闭数据库的异步IO（最后没办法的时候采取的措施）

2、修改异步IO参数，加大MAXREQS到8192，甚至16384（很多人说这个调整无效）

chdev -l aio0 -a maxreqs=16384 --或者8192

要不启动系统，动态修改请使用下面命令（临时设置，重启不起作用）

aioo -o maxreqs=16384 --或者8192 （aioo是AIX5.3-TL5版本以上才支持的）

3、安装IBM的IZ03260补丁包（这个是最根本的解决方法，修复bug）

--转自