aix oracle数据库巡检,AIX下Oracle Rac巡检说明文档.pdf

AIX下Oracle Rac巡检说明文档

AIX 下RAC 巡检文档 收藏

详细内容见我的资源(带图)

一、操作系统查看1

1> 查看操作系统(AIX 文件系统是否合理)

方式: " df -m ,查看所有的文件系统大小 是否>2G"

结果类似下面:

$df -m

Filesystem MB blocks Free %Used Iused %Iused Mounted on

/dev/hd4 2048.00 1980.01 4% 6837 2% /

/dev/hd2 10240.00 8068.59 22% 44971 3% /usr

/dev/hd9var 8192.00 7868.97 4% 7278 1% /var

/dev/hd3 4096.00 3496.39 15% 1019 1% /tmp

/dev/hd1 20480.00 15137.79 27% 3713 1% /home

/proc - - - - - /proc

/dev/hd10opt 20480.00 14830.66 28% 33118 1% /opt

/dev/arch1_lv 207360.00 207320.46 1% 5 1% /arch1

zzrac2:/arch2 208896.00 208858.72 1% 5 1% /arch2

解决方案:

如果不是，需要修改过小的fs

使用命令smitty chfs->change /show characteristic of an enhanced Journaled File System

修改对应的文件系统的大小

二、操作系统查看2

2> 查看操作系统是否打齐补丁( oslevel -s instfix -i )

方式：“oslevel –s 或 insfix –i |grep ML ”

结果类似下面:

# oslevel -s

5300-10-02-0943

# instfix -i |grep ML

All filesets for _AIX_ML were found.

All filesets for 5300-01_AIX_ML were found.

All filesets for 5300-02_AIX_ML were found.

All filesets for 5300-03_AIX_ML were found.

All filesets for 5300-04_AIX_ML were found.

All filesets for 5300-05_AIX_ML were found.

All filesets for 5300-06_AIX_ML were found.

Not all filesets for 5300-07_AIX_ML were found.

Not all filesets for 5300-08_AIX_ML were found.

Not all filesets for 5300-09_AIX_ML were found.

Not all filesets for 5300-10_AIX_ML were found.

# oslevel -s

5300-06-12-0920

解决方案:

如果不是，则查看到目前版本需要哪些补丁包，(oslevel –rl 5300-10 ，并通过smitty installp

来升级补丁包)

oslevel -rl 5300-10

三、操作系统查看3

3>查看操作系统的rootvg 是否做了mirror ("lsvg -l rootvg") ，查看LPS 和PPS 是不是1 对2

的关系

方式：“lsvg -l rootvg ”

类似结果:

# lsvg -l rootvg