AIX oracle RAC运维命令

Oracle RAC 运行状态查询

以下命令以grid用户执行

查看RAC集群运行状态

zdb1:/home/grid>crs_stat -t

Name           Type           Target    State     Host        

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

ora.ARCH.dg    ora....up.type ONLINE    ONLINE    zdb1       

ora.DATA.dg    ora....up.type ONLINE    ONLINE    zdb1       

ora....ER.lsnr ora....er.type ONLINE    ONLINE    zdb1       

ora....N1.lsnr ora....er.type ONLINE    ONLINE    zdb1       

ora....VOTE.dg ora....up.type ONLINE    ONLINE    zdb1       

ora.asm        ora.asm.type   ONLINE    ONLINE    zdb1       

ora.cvu        ora.cvu.type   ONLINE    ONLINE    zdb1       

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....network ora....rk.type ONLINE    ONLINE    zdb1       

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    zdb1       

ora.ons        ora.ons.type   ONLINE    ONLINE    zdb1       

ora....ry.acfs ora....fs.type ONLINE    ONLINE    zdb1       

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    zdb1       

ora.zdb.db    ora....se.type ONLINE    ONLINE    zdb1       

ora....SM1.asm application    ONLINE    ONLINE    zdb1               

ora....B1.lsnr application    ONLINE    ONLINE    zdb1       

ora.zdb1.gsd  application    OFFLINE   OFFLINE               

ora.zdb1.ons  application    ONLINE    ONLINE    zdb1       

ora.zdb1.vip  ora....t1.type ONLINE    ONLINE    zdb1       

ora....SM2.asm application    ONLINE    ONLINE    zdb2       

ora....B2.lsnr application    ONLINE    ONLINE    zdb2       

ora.zdb2.gsd  application    OFFLINE   OFFLINE               

ora.zdb2.ons  application    ONLINE    ONLINE    zdb2       

ora.zdb2.vip  ora....t1.type ONLINE    ONLINE    zdb2       

zdb1:/home/grid>

查看RAC数据库运行状态

zdb1:/home/grid>srvctl status database -d zdb

Instance zdb1 is running on node zdb1

Instance zdb2 is running on node zdb2

zdb1:/home/grid>

3、查看RAC注册表磁盘状态

[grid@zdb1 ~]$ ocrcheck

zdb1:/home/grid>ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       3100

         Available space (kbytes) :     259020

         ID                       :  436901300

         Device/File Name         :  +OCR_VOTE

                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

zdb1:/home/grid>

4、查看RAC仲裁盘状态

zdb1:/home/grid>crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   1a4419e58a2e4fd8bfddd85d0ea16b5b (/dev/rhdisk10) [OCR_VOTE]

 2. ONLINE   1f30dc1eb6b74f59bf78c98e5cb611f5 (/dev/rhdisk8) [OCR_VOTE]

 3. ONLINE   8487c76c2f864f82bf5530f41b9fe31d (/dev/rhdisk9) [OCR_VOTE]

Located 3 voting disk(s).

zdb1:/home/grid>

5、查看监听运行状态

zdb1:/home/grid>lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 21-SEP-2015 16:20:05

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production

Start Date                18-SEP-2015 18:21:21

Uptime                    2 days 21 hr. 58 min. 44 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      ON

Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora

Listener Log File         /u01/app/grid/diag/tnslsnr/zdb1/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.150)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.152)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "zdb" has 1 instance(s).

  Instance "zdb1", status READY, has 1 handler(s) for this service...

Service "zdbXDB" has 1 instance(s).

  Instance "zdb1", status READY, has 1 handler(s) for this service...

The command completed successfully

三、Oracle RAC 启动与关闭

在Oracle 11gR2 下的RAC，架构发生了变化。CRS的信息也是放在ASM 实例里的，所以要关asm必须关闭crs。如果还使用了acfs的话，一关crs那么acfs里的信息也不能访问了，所以一般不重启机器，不轻易关crs, 其他的service可以根据自己的需要去stop/start。注意：11g RAC 开启资源相对比较慢(即使命令后面显示的资源都start succeeded,通过crs_stat -t查看都不一定online), 需要耐心并查看log。

Oracle RAC关闭

关闭数据库：

这个和以前是一样的，还是以grid用户执行srvctl命令：

zdb1:/home/grid> srvctl stop database -d zdb （关闭所有节点）

zdb1:/home/grid> srvctl stop database -d -i zmd1  （关闭单示例）

然后查看状态：

zdb1:/home/grid> srvctl status database -d zdb      

Instance zdb1 is not running on node zdb1

Instance zdb2 is not running on node zdb2

2、停止节点集群服务，必须以root用户：

zdb1:/home/grid># cd /u01/app/11.2.0/grid/bin/

zdb1:/home/grid>./crsctl stop cluster -all  ----停止所有节点服务

Oracle RAC启动

情况一：重启两节点服务器

1、crs集群启动

重启服务器crs集群会自动启动，但是启动过程较慢，需要几分钟时间

通过crs_stat  -t 命令查看crs集群启动是否成功。

2、数据库启动

数据库需要手动启动

zdb1:/home/grid> srvctl start database -d zdb

然后查看状态：

zdb1:/home/grid>srvctl status database -d zdb      

Instance zdb1 is running on node zdb1

Instance zdb2 is running on node zdb2

情况二：服务器未重启

1、启动节点集群服务，必须以root用户：

zdb1:/home/grid> cd /u01/app/11.2.0/grid/bin/

zdb1:/home/grid> ./crsctl start cluster -all  ----启动所有节点服务

启动数据库：

以grid用户执行srvctl命令：

zdb1:/home/grid>srvctl start database -d zdb

然后查看状态：

zdb1:/home/grid> srvctl status database -d zdb      

Instance zdb1 is running on node zdb1

Instance zdb2 is running on node zdb2

注：两个节点zdb1和zdb2的root用户下，共有四个脚本。oracle_start.sh和oracle_stop.sh为数据库的启停脚本，crs_start.sh和crs_stop.sh为crs集群启停脚本。可以root用户下执行脚本即可。

四、日志查看

1、RAC集群日志查看

RAC集群日志位置：

/opt/crs/log

重点查看alert*.log、ocssd.log、crsd.log

RAC数据库日志查看

实例zdb1

/u01/app/oracle/diag/rdbms/zdb/zdb1/trace/alert.log

实例zdb2

/u01/app/oracle/diag/rdbms/zdb/zdb2/trace/alert.log

操作系统日志

errpt -a