检查数据库及服务节点状态

“STORE_NUM”与“MAJOR_NUM”表示数据库存储节点所拥有的存储数量以及当前节点中的主版本存储数据量，若节点配置拥有存储角色, 则该两项必定非零; 若查询结果中 NODE_STATE 属性值为 4 则表示当前节点异常, 已被集群管理节点置为失效, 不再对外提供服务。

SQL> SELECT DB_NAME,CHAR_SET,TIME_ZONE,CREATE_TIME,MODIFY_TIME,ONLINE FROM DBA_DATABASES;

DB_NAME | CHAR_SET | TIME_ZONE | CREATE_TIME | MODIFY_TIME | ONLINE |  
----------------------------------------------------------------------------------------------------------------
QXRDB| UTF8| GMT+08:00| 2014-10-22 15:38:44.482 AD | 2014-10-22 15:38:44.482 AD | T |


# 其中NODE_STATE为节点状态信息，值为2则代表其正常，若为4，则出现异常；

SQL> SHOW CLUSTERS;

NODE_ID | RACK_NO | NODE_IP | NODE_TYPE | NODE_STATE | LPU_NUM | STORE_WEIGHT | STORE_NUM | MAJOR_NUM| CPU_LOAD |  
----------------------------------------------------------------------------------------------------------------
1 | 1 | 192.168.10.101:50000,192.168.20.101:50001| 29 | 2 | 8 | 1 | 518851 | 173000 | 50 |
2 | 1 | 192.168.10.102:50000,192.168.20.102:50001| 31 | 2 | 8 | 1 | 519293 | 173000 | 50 |
3 | 1 | 192.168.10.103:50000,192.168.20.103:50001| 28 | 2 | 8 | 1 | 518791 | 173000 | 50 |
4 | 1 | 192.168.10.104:50000,192.168.20.104:50001| 28 | 2 | 8 | 1 | 519538 | 173000 | 50 |
5 | 1 | 192.168.10.105:50000,192.168.20.105:50001| 28 | 2 | 8 | 1 | 518929 | 173000 | 50 |
6 | 1 | 192.168.10.106:50000,192.168.20.106:50001| 28 | 2 | 8 | 1 | 519758 | 173000 | 50 |