rac的环境起来了,现在弄点命令检查、维护rac(命令来自oracle、互联网)
查看下库的名字:
SQL> select name from v$database;
NAME
---------
DEVDB-----------------------------------------------------这就是库的名字了。
---------
DEVDB-----------------------------------------------------这就是库的名字了。
登陆节点1.
rac1->srvctl status database -d devdb 上面得到的库的名字。
Instance devdb1 is running on node rac1
Instance devdb2 is running on node rac2
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
Instance devdb1 is running on node rac1
Instance devdb2 is running on node rac2
登陆节点1
rac1->echo $ORACLE_SID
devdb1-----------------------------------------------------第一个节点的实例名
devdb1-----------------------------------------------------第一个节点的实例名
登陆节点2
rac2->echo $ORACLE_SID
devdb2-----------------------------------------------------第二个节点的实例名
devdb2-----------------------------------------------------第二个节点的实例名
登陆节点1
rac1->srvctl status instance -d devdb -i devdb1
Instance devdb1 is running on node rac1
Instance devdb1 is running on node rac1
登陆节点2
rac2->srvctl status instance -d devdb -i devdb2
Instance devdb2 is running on node rac2
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
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
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.
ASM instance +ASM1 is running on node rac1.
登陆节点2
rac2->srvctl status asm -n rac2
ASM instance +ASM2 is running on node rac2.
ASM instance +ASM2 is running on node rac2.
列出配置的数据库(在任何一个节点都可以)
rac1->srvctl config database
devdb
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 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
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.
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
+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
+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
---------- ---------- ---------------- --- ------------ -----------------
STATE HOST
--------- ----------------------------------------------------------------
1 1 devdb1 YES OPEN ACTIVE
NORMAL rac1.mycorpdomain.com
2 2 devdb2 YES OPEN ACTIVE
NORMAL rac2.mycorpdomain.com
NORMAL rac2.mycorpdomain.com
转载于:https://blog.51cto.com/qhd2004/265823