10g for aix 64bit

系统日志:

/home/oracle/oracle/product/10g/admin/hbsx/bdump/hbsx_lgwr_33124954.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /home/oracle/oracle/product/10g
System name: AIX
Node name: SXDB
Release: 3
Version: 5
Machine: 000771C2D900
Instance name: hbsx
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 33124954, image: oracle@SXDB (LGWR)

*** SERVICE NAME:() 2009-09-26 23:21:02.431
*** SESSION ID:(551.1) 2009-09-26 23:21:02.431
Maximum redo generation record size = 132096 bytes
Maximum redo generation change vector size = 98708 bytes
*** 2009-09-27 07:00:01.784
Warning: log write time 650ms, size 2051KB
*** 2009-09-27 07:17:45.685
Warning: log write time 730ms, size 1027KB
*** 2009-09-27 07:39:08.940
Warning: log write time 550ms, size 2834KB
*** 2009-09-27 07:55:06.815
Warning: log write time 550ms, size 1032KB
*** 2009-09-27 07:55:07.632
Warning: log write time 810ms, size 6445KB
*** 2009-09-27 07:55:08.286

检查服务器日志: errpt

3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
0D09B489 0923200609 P H hdisk2 POLLED STATUS FAILURE
3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
3074FEB7 0923200609 T H fscsi1 ADAPTER ERROR
0D09B489 0923194909 P H hdisk4 POLLED STATUS FAILURE
3074FEB7 0923194909 T H fscsi1 ADAPTER ERROR
3074FEB7 0923194909 T H fscsi1 ADAPTER ERROR
3074FEB7 0923194909 T H fscsi1 ADAPTER ERROR
3074FEB7 0923194909 T H fscsi1 ADAPTER ERROR
0D09B489 0923194809 P H hdisk2 POLLED STATUS FAILURE
3074FEB7 0923194809 T H fscsi1 ADAPTER ERROR

发现是由于pooled 错误,检查具体的原因,是由于dump区太小导致,以下方法修改dump区

以下内容也是转明白的,主要是把问题解决了,记录一下

---------------------------------------------------------------------------------------------------------

1.查看lg_dumplv大小的估计值

#sysdumpdev -e
0453-041 Estimated dump size in bytes: 1287651328

即1.2G

2.现在lg_dumplv大小

#lslv lg_dumplv

其中PP SIZE: 256 megabyte(s)

PPs: 4

经计算,现在容量为1G.需要扩容0.2G

3.查看lg_dumplv所在的vg的容量是否够用

#lsvg rootvg

其中 PP SIZE: 256 megabyte(s)

TOTAL PPs: 1092 (279552 megabytes)

FREE PPs: 826 (211456 megabytes)

经计算,vg剩余容量为206.5G,因为根盘做了镜像.故,可用剩余容量为103G左右.因pp size为256m,故扩容2pps,即0.5G(其实扩1个pp也可以.2个放心点.)

4.扩容操作

extendlv lg_dumplv 2

5.检查当前lg_dumplv的大小.

#lslv lg_dumplv

其中 PP SIZE: 256 megabyte(s)

PPs: 6

即,现在容量为1.5G.

6.使用dumpcheck命令查看,是否还出现errpt信息

#/usr/lib/ras/dumpcheck

#errpt

不出现,则为成功