客户一数据库alert日志持续报以下错误
[quote]LNS: Standby redo logfile selected for thread 1 sequence 4060 for destination LOG_ARCHIVE_DEST_2
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:[/quote]
跟踪文件显示
[quote]/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440
Ioctl ASYNC_CONFIG error, errno = 1
/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440
Ioctl ASYNC_CONFIG error, errno = 1
/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440
Ioctl ASYNC_CONFIG error, errno = 1[/quote]
从跟踪文件可以基本定位为系统异步IO出现问题
操作系统:[color=red]HP-UX B.11.23[/color]
数据库库版本为:[color=red]10.2.0.1[/color]
错误为:[color=red]Ioctl ASYNC_CONFIG error, errno = 1[/color]
进一步诊断:
检查HP-UX异步IO文件,可以看到Oracle具有读写权限
[quote]# ls -l /dev/async
crw-rw-rw- 1 bin bin 101 0x000000 Nov 7 2007 /dev/async[/quote]
[color=red]在HP-UX平台下如果Oracle数据文件存放在文件系统中,我们强烈建议不能使用异步IO,可以通过增加dbwr进程来提高写速度,需要注意的是修改其权限可能会影响到其他应用软件使用异步io,并且建议修改之前关闭Oracle[/color]
[quote]# chmod 660 /dev/async[/quote]
检查系统参数
[quote]# kctune|grep fs_async
fs_async 0 Default [/quote]
检查Oracle参数文件
[quote]SQL> show parameter disk_async
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io boolean TRUE
SQL> show parameter filesystem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string asynch[/quote]
将参数修改为
disk_asynch_io=FALSE
filesystemio_options=none
为了避免Ioctl ASYNC_CONFIG错误,给dba组赋MLOCK权限
[quote]#/usr/sbin/setprivgrp dba MLOCK
# cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO[/quote]
参考文献:metalink 302801.1
[quote]LNS: Standby redo logfile selected for thread 1 sequence 4060 for destination LOG_ARCHIVE_DEST_2
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:[/quote]
跟踪文件显示
[quote]/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440
Ioctl ASYNC_CONFIG error, errno = 1
/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440
Ioctl ASYNC_CONFIG error, errno = 1
/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440
Ioctl ASYNC_CONFIG error, errno = 1[/quote]
从跟踪文件可以基本定位为系统异步IO出现问题
操作系统:[color=red]HP-UX B.11.23[/color]
数据库库版本为:[color=red]10.2.0.1[/color]
错误为:[color=red]Ioctl ASYNC_CONFIG error, errno = 1[/color]
进一步诊断:
检查HP-UX异步IO文件,可以看到Oracle具有读写权限
[quote]# ls -l /dev/async
crw-rw-rw- 1 bin bin 101 0x000000 Nov 7 2007 /dev/async[/quote]
[color=red]在HP-UX平台下如果Oracle数据文件存放在文件系统中,我们强烈建议不能使用异步IO,可以通过增加dbwr进程来提高写速度,需要注意的是修改其权限可能会影响到其他应用软件使用异步io,并且建议修改之前关闭Oracle[/color]
[quote]# chmod 660 /dev/async[/quote]
检查系统参数
[quote]# kctune|grep fs_async
fs_async 0 Default [/quote]
检查Oracle参数文件
[quote]SQL> show parameter disk_async
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io boolean TRUE
SQL> show parameter filesystem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string asynch[/quote]
将参数修改为
disk_asynch_io=FALSE
filesystemio_options=none
为了避免Ioctl ASYNC_CONFIG错误,给dba组赋MLOCK权限
[quote]#/usr/sbin/setprivgrp dba MLOCK
# cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO[/quote]
参考文献:metalink 302801.1