您当前的位置: 首页 > 数据库教程 > Oracle教程 > Oracle 10g RAC 常用维护命令

Oracle 10g RAC 常用维护命令

作者:不详 来源:网络 发布时间: 2014-08-26 11:23 点击:
所有实例和服务的状态 [oracle@vzwc1 ~]$ srvctl status database -d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 单个实例的状态 [oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc1 Instance zwc1 is running on nod

Oracle 10g RAC 常用维护命令

  所有实例和服务的状态

  [oracle@vzwc1 ~]$ srvctl status database -d zwc

  Instance zwc1 is running on node vzwc1

  Instance zwc2 is running on node vzwc2

  单个实例的状态

  [oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc1

  Instance zwc1 is running on node vzwc1

  [oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc2

  Instance zwc2 is running on node vzwc2

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

  [oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc1

  VIP is running on node: vzwc1

  GSD is running on node: vzwc1

  Listener is running on node: vzwc1

  ONS daemon is running on node: vzwc1

  [oracle@vzwc1 ~]$

  [oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc2

  VIP is running on node: vzwc2

  GSD is running on node: vzwc2

  Listener is running on node: vzwc2

  ONS daemon is running on node: vzwc2

  ASM 实例的状态

  [oracle@vzwc1 ~]$ srvctl status asm -n vzwc1

  ASM instance +ASM1 is running on node vzwc1.

  [oracle@vzwc1 ~]$

  [oracle@vzwc1 ~]$ srvctl status asm -n vzwc2

  ASM instance +ASM2 is running on node vzwc2.

  显示 RAC 数据库的配置

  [oracle@vzwc1 ~]$ srvctl config database -d zwc

  vzwc1 zwc1 /u01/app/oracle/product/10.2.0/db_1

  vzwc2 zwc2 /u01/app/oracle/product/10.2.0/db_1

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

  [oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc1 -a -g -s -l

  VIP exists.: /vzwc1-vip/192.168.1.151/255.255.255.0/eth0

  GSD exists.

  ONS daemon exists.

  Listener exists.

  [oracle@vzwc1 ~]$

  [oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc2 -a -g -s -l

  VIP exists.: /vzwc2-vip/192.168.1.152/255.255.255.0/eth0

  GSD exists.

  ONS daemon exists.

  Listener exists.

  显示 ASM 实例的配置

  [oracle@vzwc1 ~]$ srvctl config asm -n vzwc1

  +ASM1 /u01/app/oracle/product/10.2.0/db_1

  [oracle@vzwc1 ~]$

  [oracle@vzwc1 ~]$ srvctl config asm -n vzwc2

  +ASM2 /u01/app/oracle/product/10.2.0/db_1

  RAC正在运行的实例

  SQL> SELECT

  2 inst_id

  , instance_number inst_no

  , instance_name inst_name

  , parallel

  6 , status

  7 , database_status db_status

  8 , active_state state

  9 , host_name host

  10 FROM gv$instance

  11 /

  INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST

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

  1 1 zwc1 YES OPEN ACTIVE NORMAL vzwc1

  2 2 zwc2 YES OPEN ACTIVE NORMAL vzwc2

  磁盘组中的所有数据文件

  SQL> select name from v$datafile

  2 union

  3 select member from v$logfile

  4 union

  5 select name from v$controlfile

  6 union

  7 select name from v$tempfile

  8 /

  NAME

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

  +DATADG/zwc/controlfile/current.260.810684377

  +DATADG/zwc/datafile/example.264.810684397

  +DATADG/zwc/datafile/sysaux.257.810684333

  +DATADG/zwc/datafile/system.256.810684333

  +DATADG/zwc/datafile/undotbs1.258.810684333

  +DATADG/zwc/datafile/undotbs2.265.810684503

  +DATADG/zwc/datafile/users.259.810684333

  +DATADG/zwc/onlinelog/group_1.261.810684379

  +DATADG/zwc/onlinelog/group_2.262.810684383

  +DATADG/zwc/onlinelog/group_3.266.810684557

  +DATADG/zwc/onlinelog/group_4.267.810684559

  +DATADG/zwc/tempfile/temp.263.810684393

  +FLASHDG/zwc/controlfile/current.256.810684377

  +FLASHDG/zwc/onlinelog/group_1.257.810684381

  +FLASHDG/zwc/onlinelog/group_2.258.810684385

  +FLASHDG/zwc/onlinelog/group_3.259.810684559

  +FLASHDG/zwc/onlinelog/group_4.260.810684561

  OCR存放路径

  [oracle@vzwc1 ~]$ ocrcheck

  Status of Oracle Cluster Registry is as follows :

  Version : 2

  Total space (kbytes) : 1043916

  Used space (kbytes) : 3832

  Available space (kbytes) : 1040084

  ID : 1906841437

  Device/File Name : /dev/raw/raw1

  Device/File integrity check succeeded

  Device/File not configured

  Cluster registry integrity check succeeded

  VOTEDISK存放路径

  [oracle@vzwc1 ~]$ crsctl query css votedisk

  0. 0 /dev/raw/raw2

  located 1 votedisk(s).

  clusterware版本

  [oracle@vzwc1 ~]$ crsctl query crs activeversion

  CRS active version on the cluster is [10.2.0.5.0]

  RAC资源查看

  [oracle@vzwc1 ~]$ crs_stat -t

  Name Type Target State Host

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

  ora....SM1.asm application ONLINE ONLINE vzwc1

  ora....C1.lsnr application ONLINE ONLINE vzwc1

  ora.vzwc1.gsd application ONLINE ONLINE vzwc1

  ora.vzwc1.ons application ONLINE ONLINE vzwc1

  ora.vzwc1.vip application ONLINE ONLINE vzwc1

  ora....SM2.asm application ONLINE ONLINE vzwc2

  ora....C2.lsnr application ONLINE ONLINE vzwc2

  ora.vzwc2.gsd application ONLINE ONLINE vzwc2

  ora.vzwc2.ons application ONLINE ONLINE vzwc2

  ora.vzwc2.vip application ONLINE ONLINE vzwc2

  ora.zwc.db application ONLINE ONLINE vzwc2

  ora....c1.inst application ONLINE ONLINE vzwc1

  ora....c2.inst application ONLINE ONLINE vzwc2

  停止 Oracle 实例,当此实例(和相关服务)关闭后,关闭 ASM 实例。最后,关闭节点应用程序(虚拟 IP、GSD、TNS 监听器和 ONS)。

  export ORACLE_SID=zwc1

  emctl stop dbconsole

  srvctl stop instance -d zwc -i zwc1

  srvctl stop asm -n vzwc1

  srvctl stop nodeapps -n vzwc1

  启动节点应用程序(虚拟 IP、GSD、TNS 监听器和 ONS)。当成功启动节点应用程序后,启动 ASM 实例。最后,启动 Oracle 实例(和相关服务)以及EM。

  export ORACLE_SID=zwc1

  srvctl start nodeapps -n vzwc1

  srvctl start asm -n vzwc1

  srvctl start instance -d zwc -i zwc1

  emctl start dbconsole

  启动/停止所有实例及其启用的服务

  srvctl start database -d zwc

  srvctl stop database -d zwc
分享到:
本文"Oracle 10g RAC 常用维护命令"由远航站长收集整理而来,仅供大家学习与参考使用。更多网站制作教程尽在远航站长站。
顶一下
(0)
0%
踩一下
(0)
0%
[点击 次] [返回上一页] [打印]
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 密码: 验证码:
关于本站 - 联系我们 - 网站声明 - 友情连接- 网站地图 - 站点地图 - 返回顶部
Copyright © 2007-2013 www.yhzhan.com(远航站长). All Rights Reserved .
远航站长:为中小站长提供最佳的学习与交流平台,提供网页制作与网站编程等各类网站制作教程.
官方QQ:445490277 网站群:26680406 网站备案号:豫ICP备07500620号-4