oracle 10g : 日誌寫入慢.Warning: log write time 650ms, size 2051KB

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: (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

[@more@]

檢查伺服器日誌: 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

不出現,則為成功