rac 日常巡检

王硕

说明：有些语句可能在oracle 或者在grid用户下才 yrh3elMD.txt (81.36 KB, 下载次数: 138)

2015-4-19 18:54 上传

点击文件名下载附件
rac 日常巡检
能操作。

[此贴子已经被作者于2015-04-19 18:54:33编辑过]

王硕

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

SQL> 

select status from v$instance;

STATUS

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

OPEN

SQL> select open_mode from v$database;

OPEN_MODE

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

READ WRITE

王硕

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

[oracle@node1 ~]$ srvctl config database

db

王硕

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

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

Instance db1 is running on node node1 

Instance db2 is running on node node2

王硕

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

SQL> select name from v$database;

NAME

---------

DB

SQL> select instance_name from v$instance;

INSTANCE_NAME

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

db1

王硕

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

王硕

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

王硕

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_

王硕

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

王硕

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.