该文章讲述了ORACLE 10G RAC 服务器日常维护手册.
三、Linux操
作系统检查
3.1 系统已运行时间
# uptime
3.2 系统磁盘空间检查
# df -k
3.3 检查linux日志文件
命令 tail -200 /var/log/messages
# dmesg
3.4 检查/etc/fstab
[root@ctmsdb1 etc]# more /etc/fstab
# This file is edited by fstab-sync - see 'man fstab-sync' for details
LABEL=/ / ext3 defaults 1 1
LABEL=/arch /arch ext2 defaults 1 2
LABEL=/backup /backup ext3 defaults 1 2
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs defaults 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
LABEL=SWAP-sda5 swap swap defaults 0 0
/dev/sdb1 /oradata ocfs2 _netdev,datavolume,nointr 0 0
/dev/hda /media/cdrecorder auto pamconsole,exec,noauto,managed 0 0
3.5 性能检查
# mpstat -P ALL 2 10
检查每个cpu状态
# topas
# vmstat 2 10
3.6 内存使用检查
命令行 free –m
[root@gzwldb1 /]# free -m
total used free shared buffers cached
Mem: 3842 3791 50 0 131 2999
-/+ buffers/cache: 660 3181
Swap: 8189 0 8189
命令行 free –t
[root@gzwldb1 /]# free -t
total used free shared buffers cached
Mem: 3934216 3882428 51788 0 134364 3071816
-/+ buffers/cache: 676248 3257968
Swap: 8385920 0 8385920
Total: 12320136 3882428 8437708
四、数据库ORACLE健康检查
4.1 状态检查OPS
在数据库服务器上运行ops命令,检查oracle的进程,磁盘空间,群集状态信息
命令行[root@ctmsdb1 bin]# ops
-- oracle 10g数据库后台进程
oracle 14555 1 0 18:08 ? 00:00:00 ora_pmon_ctms1
oracle 14557 1 0 18:08 ? 00:00:00 ora_diag_ctms1
oracle 14559 1 0 18:08 ? 00:00:00 ora_psp0_ctms1
oracle 14561 1 0 18:08 ? 00:00:00 ora_lmon_ctms1
oracle 14565 1 0 18:08 ? 00:00:00 ora_lmd0_ctms1
oracle 14567 1 0 18:08 ? 00:00:00 ora_lms0_ctms1
oracle 14571 1 0 18:08 ? 00:00:00 ora_lms1_ctms1
oracle 14577 1 0 18:08 ? 00:00:00 ora_mman_ctms1
oracle 14581 1 0 18:08 ? 00:00:00 ora_dbw0_ctms1
oracle 14583 1 0 18:08 ? 00:00:00 ora_lgwr_ctms1
oracle 14585 1 0 18:08 ? 00:00:00 ora_ckpt_ctms1
oracle 14588 1 0 18:08 ? 00:00:00 ora_smon_ctms1
oracle 14590 1 0 18:08 ? 00:00:00 ora_reco_ctms1
oracle 14592 1 0 18:08 ? 00:00:00 ora_cjq0_ctms1
oracle 14594 1 0 18:08 ? 00:00:00 ora_mmon_ctms1
oracle 14596 1 0 18:08 ? 00:00:00 ora_mmnl_ctms1
oracle 14598 1 0 18:08 ? 00:00:00 ora_lck0_ctms1
oracle 14641 1 0 18:08 ? 00:00:00 ora_qmnc_ctms1
oracle 14926 1 0 18:08 ? 00:00:00 ora_q000_ctms1
oracle 14928 1 0 18:08 ? 00:00:00 ora_q001_ctms1
oracle 15704 1 0 18:09 ? 00:00:00 ora_pz99_ctms1
--oracle数据库监听进程
oracle 14563 1 0 18:08 ? 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_CTMSDB1 –inherit
-- oracle 10g 群集后台进程
oracle 13505 13504 0 18:07 ? 00:00:00 /u01/app/oracle/product/10.2.0/crs/bin/evmd.bin
root 13650 4293 0 18:07 ? 00:00:01 /u01/app/oracle/product/10.2.0/crs/bin/crsd.bin reboot
root 14035 13660 0 18:07 ? 00:00:00 /u01/app/oracle/product/10.2.0/crs/bin/oprocd.bin run -t 1000 -m 500 -f
oracle 14195 13702 0 18:07 ? 00:00:00 /u01/app/oracle/product/10.2.0/crs/bin/ocssd.bin
Oracle server have 21 processes --oracle数据库后台进程数
Oracle client have 4 processes ---oracle客户端服务进程数
--以下是文件系统空间,平时注意空间情况,如果已用达到95%,说明空间不足,需要检查并清除无用日志。
文件系统 1K-块 已用 可用 已用% 挂载点
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 54285276 9385776 42141948 19% /
/dev/sda3 41286828 1971336 37218208 6% /arch oracle归档文件目录
/dev/sda2 41286828 81984 39107560 1% /backup oracle备份文件目录
none 4154280 0 4154280 0% /dev/shm
/dev/sdb1 142841856 13081856 129760000 10% /oradata oracle数据文件目录
--Oracle 10g RAC 数据群集软件的状态,运行正常
名称 类型 设置 状态 服务器名
Name Type Target State Host
------------------------------------------------------------
ora....s1.inst application ONLINE ONLINE ctmsdb1 ctmsdb1实列
ora....s2.inst application ONLINE ONLINE ctmsdb2 ctmsdb2实列
ora.ctms.db application ONLINE ONLINE ctmsdb1 ora.ctms.db
ora....B1.lsnr application ONLINE ONLINE ctmsdb1 监听服务
ora....db1.gsd application ONLINE ONLINE ctmsdb1 全局服务
ora....db1.ons application ONLINE ONLINE ctmsdb1 ons服务
ora....db1.vip application ONLINE ONLINE ctmsdb1 虚拟IP服务
ora....B2.lsnr application ONLINE ONLINE ctmsdb2 监听服务
ora....db2.gsd application ONLINE ONLINE ctmsdb2 全局服务
ora....db2.ons application ONLINE ONLINE ctmsdb2 ons服务
ora....db2.vip application ONLINE ONLINE ctmsdb2 虚拟IP服务
--网络ip地址的状态
inet addr:192.168.100.16 Bcast:192.168.100.255 Mask:255.255.255.0
inet addr:192.168.100.18 Bcast:192.168.100.255 Mask:255.255.255.0
inet addr:172.168.100.16 Bcast:172.168.100.255 Mask:255.255.255.0
inet addr:127.0.0.1 Mask:255.0.0.0
本文来自: 高校自动化网(Www.zdh1909.com) 详细出处参考(转载请保留本链接):http://www.zdh1909.com/html/Cisco/16674.html