当前位置:   article > 正文

oracle11g中ASM磁盘组的mount

oracle11g中ASM磁盘组的mount

1.进入grid用户下,查看磁盘组状态

[root@node2 ~]# su - grid
[grid@node2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 23 15:27:04 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select name,state from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
CRS MOUNTED
DG1 DISMOUNTED
RCY1 DISMOUNTED
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19

其中DG1、RCY1处于dismounted状态。
2.接着mountDG1和RCY1

SQL> alter diskgroup DG1 mount;
Diskgroup altered.

SQL> alter diskgroup RCY1 mount;
Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
DG1 MOUNTED
RCY1 MOUNTED
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12

3.mount 上之后用root用执行/home/oracle/11.2.0/grid/bin/crsctl start cluster -n 主机名
4.在grid用户下执行一下crsctl status res -t查看状态

grid@node2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               OFFLINE ONLINE       node1                                       
               ONLINE  ONLINE       node2                                          
ora.LISTENER.lsnr
               ONLINE  ONLINE       node1                                          
               ONLINE  ONLINE       node2                                       
ora.OCR.dg
               ONLINE  ONLINE       node1                                          
               ONLINE  ONLINE       node2                                          
ora.asm
               ONLINE  ONLINE       node1                      Started             
               ONLINE  ONLINE       node2                      Started             
ora.gsd
               OFFLINE OFFLINE      node1                                          
               OFFLINE OFFLINE      node2                                          
ora.net1.network
               ONLINE  ONLINE       node1                                          
               ONLINE  ONLINE       node2                                          
ora.ons
               ONLINE  ONLINE       node1                                          
               ONLINE  ONLINE       node2                                          
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node1                                          
ora.cnmos.db
      1        ONLINE  ONLINE       node1                      Open                
      2        ONLINE  ONLINE       node2                      Open                
ora.cvu
      1        ONLINE  ONLINE       node1                                          
ora.db1.vip
      1        ONLINE  ONLINE       node1                                          
ora.db2.vip
      1        ONLINE  ONLINE       node2                                          
ora.oc4j
      1        ONLINE  ONLINE       node1                                          
ora.scan1.vip
      1        ONLINE  ONLINE       node1        
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/小丑西瓜9/article/detail/347016
推荐阅读
相关标签
  

闽ICP备14008679号