遇到手动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 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to an idle instance.SQL> startupORA-01565: error in identifying file '+DATA/eimgdb/spfileeimgdb.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/eimgdb/spfileeimgdb.oraORA-15001: diskgroup "DATA" does not exist or is not mountedORA-15040: diskgroup is incompleteSQL> exitDisconnected

 

检查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 keywordSQL> 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_00026 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         348SQL> /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