当前位置:Gxlcms > mysql > OracleRAC日常基本维护命令

OracleRAC日常基本维护命令

时间:2021-07-01 10:21:17 帮助过:19人阅读

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 所有实例和服务的状态 $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2 is running on node linux2 单个实例的状态 $ srvctl status instance -d orcl

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

  所有实例和服务的状态

  $ srvctl status database -d orcl

  Instance orcl1 is running on node linux1

  Instance orcl2 is running on node linux2

  单个实例的状态

  $ srvctl status instance -d orcl -i orcl2

  Instance orcl2 is running on node linux2

  在数据库全局命名服务的状态

  $ srvctl status service -d orcl -s orcltest

  Service orcltest is running on instance(s) orcl2, orcl1

  特定节点上节点应用程序的状态

  $ srvctl status nodeapps -n linux1

  VIP is running on node: linux1

  GSD is running on node: linux1

  Listener is running on node: linux1

  ONS daemon is running on node: linux1

  ASM 实例的状态

  $ srvctl status asm -n linux1

  ASM instance +ASM1 is running on node linux1.

  列出配置的所有数据库

  $ srvctl config database

  orcl

  显示 RAC 数据库的配置

  $ srvctl config database -d orcl

  linux1 orcl1 /u01/app/oracle/product/10.2.0/db_1

  linux2 orcl2 /u01/app/oracle/product/10.2.0/db_1

  显示指定集群数据库的所有服务

  $ srvctl config service -d orcl

  orcltest PREF: orcl2 orcl1 AVAIL:

  显示节点应用程序的配置 ―(VIP、GSD、ONS、监听器)

  $ srvctl config nodeapps -n linux1 -a -g -s -l

  VIP exists.: /linux1-vip/192.168.1.200/255.255.255.0/eth0:eth1

  GSD exists.

  ONS daemon exists.

  Listener exists.

  显示 ASM 实例的配置

  $ srvctl config asm -n linux1

  +ASM1 /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 orcl1 YES OPEN ACTIVE NORMAL rac1

  2 2 orcl2 YES OPEN ACTIVE NORMAL rac2

[1] [2]

人气教程排行