程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> 關於Oracle數據庫 >> Oracle 10g RAC 常用維護命令

Oracle 10g RAC 常用維護命令

編輯:關於Oracle數據庫

       所有實例和服務的狀態

      [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

     

    1. 上一頁:
    2. 下一頁:
    Copyright © 程式師世界 All Rights Reserved