遇到手动sqlplus 启动实例抛出错误，而用srvctl start instance 没有，重新添加磁盘

数据库环境 11.2.0.4 rac 
 数据库手动关闭了 分区功能 chopt disable partiting
尝试使用sqlplus 启动数据库是否有问题
  
  


  
  

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 25 02:43:09 2017

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

Connected to an idle instance.

SQL> startup
ORA-01565: error in identifying file '+DATA/eimgdb/spfileeimgdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/eimgdb/spfileeimgdb.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
SQL> exit
Disconnected

 

检查asm 磁盘组 

su - grid

asmcmd -p lsdg 磁盘状态也正常 仔细使用sqlplus  / as sysasm

检查磁盘状态发现如下

SQL>  select group_number,disk_number,STATE,PATH,NAME,failgroup from v$asm_disk;

GROUP_NUMBER DISK_NUMBER STATE    PATH                 NAME                           FAILGROUP
------------ ----------- -------- -------------------- ------------------------------ ------------------------------
           0           0 NORMAL   /dev/raw/raw5
           1           0 FORCING                       _DROPPED_0000_DATA             CONTROLLER1
           2           1 NORMAL   /dev/raw/raw2        VOTEDISK_0001                  VOTEDISK_0001
           2           0 NORMAL   /dev/raw/raw1        VOTEDISK_0000                  VOTEDISK_0000
           2           2 NORMAL   /dev/raw/raw3        VOTEDISK_0002                  VOTEDISK_0002
           1           1 NORMAL   /dev/raw/raw6        DISKB1                         CONTROLLER2

原来磁盘组data 的一个磁盘  /dev/raw/raw5 被剔除了 

使用命令强制加进去

SQL> alter diskgroup DATA add disk '/dev/raw/raw5' rebalance power 2 force;
alter diskgroup DATA add disk '/dev/raw/raw5' rebalance power 2 force
                                                                *
ERROR at line 1:
ORA-00905: missing keyword


SQL> alter diskgroup DATA add disk '/dev/raw/raw5' force rebalance power 2;

Diskgroup altered.

SQL>  select group_number,disk_number,STATE,PATH,NAME,failgroup from v$asm_disk;

GROUP_NUMBER DISK_NUMBER STATE    PATH                 NAME                           FAILGROUP
------------ ----------- -------- -------------------- ------------------------------ ------------------------------
           1           0 FORCING                       _DROPPED_0000_DATA             CONTROLLER1
           2           1 NORMAL   /dev/raw/raw2        VOTEDISK_0001                  VOTEDISK_0001
           2           0 NORMAL   /dev/raw/raw1        VOTEDISK_0000                  VOTEDISK_0000
           2           2 NORMAL   /dev/raw/raw3        VOTEDISK_0002                  VOTEDISK_0002
           1           1 NORMAL   /dev/raw/raw6        DISKB1                         CONTROLLER2
           1           2 NORMAL   /dev/raw/raw5        DATA_0002                      DATA_0002

6 rows selected.

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           1 REBAL RUN           2          2         45       9800         28         348

SQL> /

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           1 REBAL RUN           2          2         45       9800         28         348

同步完成后查询asm_disk  

_DROPPED_0000_DATA   已经没有了   

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,name,path from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME                           PATH
------------ ----------- ------- ------------ ------- -------- ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
           1           2 CACHED  MEMBER       ONLINE  NORMAL   DATA_0002                      /dev/raw/raw5
           1           1 CACHED  MEMBER       ONLINE  NORMAL   DISKB1                         /dev/raw/raw6
           2           0 CACHED  MEMBER       ONLINE  NORMAL   VOTEDISK_0000                  /dev/raw/raw1
           2           1 CACHED  MEMBER       ONLINE  NORMAL   VOTEDISK_0001                  /dev/raw/raw2
           2           2 CACHED  MEMBER       ONLINE  NORMAL   VOTEDISK_0002                  /dev/raw/raw3