rac的环境起来了,现在弄点命令检查、维护rac(命令来自oracle、互联网)
查看下库的名字:
SQL> select name from v$database;
NAME
---------
DEVDB-----------------------------------------------------这就是库的名字了。
 
登陆节点1.
rac1->srvctl status database -d devdb                 上面得到的库的名字。
Instance devdb1 is running on node rac1
Instance devdb2 is running on node rac2
 
登陆节点2
rac2->srvctl status database -d devdb
Instance devdb1 is running on node rac1
Instance devdb2 is running on node rac2
 
登陆节点1
rac1->echo $ORACLE_SID
devdb1-----------------------------------------------------第一个节点的实例名
 
登陆节点2
rac2->echo $ORACLE_SID
devdb2-----------------------------------------------------第二个节点的实例名
 
登陆节点1
rac1->srvctl status instance -d devdb -i devdb1
Instance devdb1 is running on node rac1
 
登陆节点2
rac2->srvctl status instance -d devdb -i devdb2
Instance devdb2 is running on node rac2
 
登陆节点1
rac1->srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1
 
登陆节点2
rac2->srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2
 
登陆节点1
rac1->srvctl status asm -n rac1
ASM instance +ASM1 is running on node rac1.
 
登陆节点2
rac2->srvctl status asm -n rac2
ASM instance +ASM2 is running on node rac2.
 
列出配置的数据库(在任何一个节点都可以)
rac1->srvctl config database
devdb
 
显示RAC数据库的配置(在任何一个节点都可以)
rac1->srvctl config database -d devdb
rac1 devdb1 /u01/app/oracle/product/10.2.0/db_1
rac2 devdb2 /u01/app/oracle/product/10.2.0/db_1
 
显示指定集群数据库的所有服务(在任何一个节点都可以)
rac1->srvctl config service -d devdb
CRM PREF: devdb1 AVAIL: devdb2
 
显示节点应用程序的配置—(VIP、GSD、ONS、监听器)
rac1->srvctl config nodeapps -n rac1 -a -g -s -l
VIP exists.: /rac1-vip.mycorpdomain.com/172.20.52.223/255.255.248.0/eth0
GSD exists.
ONS daemon exists.
Listener exists.
 
显示ASM实例的配置
登陆节点1
rac1->srvctl config asm -n rac1
+ASM1 /u01/app/oracle/product/10.2.0/db_1
 
登陆节点2
rac2->srvctl config asm -n rac2
+ASM2 /u01/app/oracle/product/10.2.0/db_1
 
集群中所有正在运行的实例
SELECT inst_id,instance_number inst_no , instance_name inst_name , parallel , status , database_status db_status,active_state state , host_name host FROM gv$instance ORDER BY inst_id;
   INST_ID    INST_NO INST_NAME        PAR STATUS       DB_STATUS
---------- ---------- ---------------- --- ------------ -----------------
STATE     HOST
--------- ----------------------------------------------------------------
         1          1 devdb1           YES OPEN         ACTIVE
NORMAL    rac1.mycorpdomain.com
         2          2 devdb2           YES OPEN         ACTIVE
NORMAL    rac2.mycorpdomain.com