rac 日常巡检

王硕 · 发表于 2015-4-19 18:24:42

说明：有些语句可能在oracle 或者在grid用户下才

yrh3elMD.txt (81.36 KB, 下载次数: 223)

王硕 · 发表于 2015-4-19 18:25:13

1.如何查询数据库数据库的状态是mount,nomount还是open的状态?

SQL>

select status from v$instance;

STATUS

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

OPEN

SQL> select open_mode from v$database;

OPEN_MODE

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

READ WRITE

王硕 · 发表于 2015-4-19 18:25:32

2.列出配置的所有数据库

[oracle@node1 ~]$ srvctl config database

db

王硕 · 发表于 2015-4-19 18:25:58

3.查看所有实例和服务的状态

[oracle@node1 ~]$ srvctl status database -d db ------- db为数据库的名字

Instance db1 is running on node node1

Instance db2 is running on node node2

王硕 · 发表于 2015-4-19 18:26:16

4. 查看Oracle数据库名和实例名

SQL> select name from v$database;

NAME

---------

DB

SQL> select instance_name from v$instance;

INSTANCE_NAME

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

db1

王硕 · 发表于 2015-4-19 18:26:40

5..列出RAC数据库的配置

[oracle@node1 ~]$ srvctl config database -d db ------db为数据库名

Database unique name: db

Database name: db

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/db/spfiledb.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: db

Database instances: db1,db2

Disk Groups: DATA,ARCH

Services:

Database is administrator managed

王硕 · 发表于 2015-4-19 18:28:21

6.显示节点应用程序的配置 —（VIP、GSD、ONS、监听器）

[oracle@node1 ~]$ srvctl config nodeapps -n node1 -a -g -s -l -------node1 为节点名

-n <node_name> option has been deprecated.

-l option has been deprecated and will be ignored.

VIP exists.:node1

VIP exists.: /node1-vip/192.168.1.131/255.255.255.0/eth0

GSD exists.

ONS daemon exists. Local port 6100, remote port 6200

-n option has been deprecated and will be ignored.

Name: LISTENER

Network: 1, Owner: grid

Home: <CRS home>

/u01/grid on node(s) node2,node1

End points: TCP:1521

王硕 · 发表于 2015-4-19 18:28:48

7. Oracle进程检查

[oracle@node1 ~]$ ps -ef |grep ora_

oracle 6722 1 0 13:00 ? 00:00:00 ora_pmon_db1

oracle 6726 1 0 13:00 ? 00:00:00 ora_vktm_db1

oracle 6732 1 0 13:00 ? 00:00:00 ora_gen0_db1

oracle 6736 1 0 13:00 ? 00:00:00 ora_diag_db1

oracle 6740 1 0 13:00 ? 00:00:00 ora_dbrm_db1

oracle 6744 1 0 13:00 ? 00:00:00 ora_ping_db1

oracle 6748 1 0 13:00 ? 00:00:00 ora_psp0_db1

oracle 6752 1 0 13:00 ? 00:00:00 ora_acms_db1

oracle 6756 1 0 13:00 ? 00:00:03 ora_dia0_db1

oracle 6760 1 0 13:00 ? 00:00:01 ora_lmon_db1

oracle 6764 1 0 13:00 ? 00:00:03 ora_lmd0_db1

oracle 6768 1 0 13:00 ? 00:00:01 ora_lms0_db1

oracle 6774 1 0 13:00 ? 00:00:00 ora_rms0_db1

oracle 6778 1 0 13:00 ? 00:00:00 ora_lmhb_db1

oracle 6782 1 0 13:00 ? 00:00:00 ora_mman_db1

oracle 6786 1 0 13:00 ? 00:00:00 ora_dbw0_db1

oracle 6790 1 0 13:00 ? 00:00:00 ora_lgwr_db1

oracle 6794 1 0 13:00 ? 00:00:00 ora_ckpt_db1

oracle 6798 1 0 13:00 ? 00:00:00 ora_smon_db1

oracle 6802 1 0 13:00 ? 00:00:00 ora_reco_db1

oracle 6806 1 0 13:00 ? 00:00:00 ora_rbal_db1

oracle 6810 1 0 13:00 ? 00:00:00 ora_asmb_db1

oracle 6814 1 0 13:00 ? 00:00:01 ora_mmon_db1

oracle 6818 1 0 13:00 ? 00:00:00 ora_mmnl_db1

oracle 6822 1 0 13:00 ? 00:00:00 ora_d000_db1

oracle 6826 1 0 13:00 ? 00:00:00 ora_s000_db1

oracle 6835 1 0 13:00 ? 00:00:00 ora_mark_db1

oracle 6850 1 0 13:00 ? 00:00:03 ora_lck0_db1

oracle 6859 1 0 13:00 ? 00:00:00 ora_rsmn_db1

oracle 7002 1 0 13:01 ? 00:00:00 ora_arc0_db1

oracle 7007 1 0 13:01 ? 00:00:00 ora_arc1_db1

oracle 7011 1 0 13:01 ? 00:00:00 ora_arc2_db1

oracle 7015 1 0 13:01 ? 00:00:00 ora_arc3_db1

oracle 7095 1 0 13:02 ? 00:00:00 ora_gtx0_db1

oracle 7099 1 0 13:02 ? 00:00:00 ora_rcbg_db1

oracle 7120 1 0 13:02 ? 00:00:00 ora_qmnc_db1

oracle 7128 1 0 13:02 ? 00:00:01 ora_q000_db1

oracle 7132 1 0 13:02 ? 00:00:00 ora_q001_db1

oracle 7269 1 0 13:03 ? 00:00:01 ora_cjq0_db1

oracle 7454 1 0 13:06 ? 00:00:00 ora_pz99_db1

oracle 7556 1 0 13:07 ? 00:00:00 ora_smco_db1

oracle 10734 1 0 13:47 ? 00:00:00 ora_w000_db1

oracle 10809 1 0 13:48 ? 00:00:00 ora_q002_db1

oracle 10838 1 0 13:49 ? 00:00:00 ora_j000_db1

oracle 10842 1 0 13:49 ? 00:00:00 ora_j001_db1

oracle 10866 7792 0 13:49 pts/2 00:00:00 grep ora_

王硕 · 发表于 2015-4-19 18:29:19

8.CRS进程检查

[oracle@node1 ~]$ ps -df |grep d.bin

grid 5110 1 0 12:54 ? 00:00:00 /u01/grid/bin/gipcd.bin

root 5155 1 0 12:54 ? 00:00:01 /u01/grid/bin/cssdmonitor

root 5178 1 0 12:54 ? 00:00:01 /u01/grid/bin/cssdagent

grid 5199 1 0 12:54 ? 00:00:10 /u01/grid/bin/ocssd.bin

grid 5206 1 0 12:54 ? 00:00:00 /u01/grid/bin/diskmon.bin -d -f

root 5707 1 0 12:57 ? 00:00:00 /u01/grid/bin/octssd.bin reboot

grid 5904 1 0 12:58 ? 00:00:00 /u01/grid/bin/oclskd.bin

root 6014 1 0 12:58 ? 00:00:00 /u01/grid/bin/oclskd.bin

grid 6068 5723 0 12:58 ? 00:00:00 /u01/grid/bin/evmlogger.bin -o /u01/grid/evm/log/evmlogger.info -l /u01/grid/evm/log/evmlogger.log

oracle 6839 1 0 13:00 ? 00:00:00 /u01/grid/bin/oclskd.bin

oracle 11027 7792 0 13:51 pts/2 00:00:00 grep d.bin

[root@node1 ~]# su - grid

[grid@node1 ~]$ crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[grid@node1 ~]$ crs_stat -t

Name Type Target State Host

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

ora.ARCH.dg ora....up.type ONLINE ONLINE node1

ora.DATA.dg ora....up.type ONLINE ONLINE node1

ora....ER.lsnr ora....er.type ONLINE ONLINE node1

ora....N1.lsnr ora....er.type ONLINE ONLINE node1

ora.OVDISK.dg ora....up.type ONLINE ONLINE node1

ora.asm ora.asm.type ONLINE ONLINE node1

ora.db.db ora....se.type ONLINE ONLINE node1

ora.eons ora.eons.type ONLINE ONLINE node1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE node1

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application OFFLINE OFFLINE

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip ora....t1.type ONLINE ONLINE node1

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application OFFLINE OFFLINE

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip ora....t1.type ONLINE ONLINE node2

ora.oc4j ora.oc4j.type OFFLINE OFFLINE

ora.ons ora.ons.type ONLINE ONLINE node1

ora....ry.acfs ora....fs.type ONLINE ONLINE node1

ora.scan1.vip ora....ip.type ONLINE ONLINE node1

[grid@node1 ~]$ crs_stat -ls

terminate called after throwing an instance of 'std::out_of_range'

what(): basic_string::substr

Aborted

王硕 · 发表于 2015-4-19 18:29:57

9.查看各个instance的alert.log

SQL> select name,value from V$diag_info

2 where name in('Diag Trace','Diag Alert');

NAME

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

VALUE

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

Diag Trace

/u01/app/oracle/diag/rdbms/db/db1/trace

Diag Alert

/u01/app/oracle/diag/rdbms/db/db1/alert

3、如果是查看文本格式的alert log，先进入 Diag Trace 目录。用文本编辑器打开alert_SID.log。

4、如果是查看XML格式的 alert log，进入 Diag Alert 目录。用文本编辑器打开log.xml.

帐号		自动登录	找回密码
密码			注册