Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem mounting DATA diskgroup in Exadata machine

melihbasbugJan 8 2018 — edited Jan 9 2018

I can't get mount my DATA_DM01 diskgroup. I use oracle exadata. DB is 11gr2 i got error. That error is;

SQL> alter diskgroup DATA_DM01 mount force;
alter diskgroup DATA_DM01 mount force
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15066: offlining disk "0" in group "DATA_DM01" may result in a data loss
ORA-15042: ASM disk "0" is missing from group number "1"

I will not use one cell of disk in dm01celadm01 because it is broken and i can't change it. We don't need any data in database. It has not used for many years.
I drop that broken cell from celldisk... o/myip1/DATA_DM01_CD_00_dm01celadm01 So should i drop o/myip3/DATA_DM01_CD_00_dm01celadm03 and o/myip2/DATA_DM01_CD_00_dm01celadm02 ?????? thanks

My DATA_DM01 disk list in sysasm:

select group_number, disk_number, state, redundancy, path from v$asm_disk where path like '%DATA_DM01%';
g_n dn state  redund path
--- -- ------ ------ --------------
  0  0 NORMAL UNPROT o/myip3/DATA_DM01_CD_09_dm01celadm03
  0  1 NORMAL UNPROT o/myip3/DATA_DM01_CD_07_dm01celadm03
  0  2 NORMAL UNPROT o/myip3/DATA_DM01_CD_02_dm01celadm03
  0  3 NORMAL UNPROT o/myip3/DATA_DM01_CD_08_dm01celadm03
  0  4 NORMAL UNPROT o/myip3/DATA_DM01_CD_00_dm01celadm03
  0  5 NORMAL UNPROT o/myip3/DATA_DM01_CD_04_dm01celadm03
  0  6 NORMAL UNPROT o/myip3/DATA_DM01_CD_10_dm01celadm03
  0  7 NORMAL UNPROT o/myip3/DATA_DM01_CD_03_dm01celadm03
  0  8 NORMAL UNPROT o/myip3/DATA_DM01_CD_06_dm01celadm03
  0  9 NORMAL UNPROT o/myip3/DATA_DM01_CD_11_dm01celadm03
  0 10 NORMAL UNPROT o/myip3/DATA_DM01_CD_05_dm01celadm03
  0 11 NORMAL UNPROT o/myip3/DATA_DM01_CD_01_dm01celadm03
  0 12 NORMAL UNPROT o/myip2/DATA_DM01_CD_00_dm01celadm02
  0 13 NORMAL UNPROT o/myip2/DATA_DM01_CD_09_dm01celadm02
  0 14 NORMAL UNPROT o/myip2/DATA_DM01_CD_07_dm01celadm02
  0 15 NORMAL UNPROT o/myip2/DATA_DM01_CD_10_dm01celadm02
  0 16 NORMAL UNPROT o/myip2/DATA_DM01_CD_11_dm01celadm02
  0 17 NORMAL UNPROT o/myip2/DATA_DM01_CD_02_dm01celadm02
  0 18 NORMAL UNPROT o/myip2/DATA_DM01_CD_03_dm01celadm02
  0 19 NORMAL UNPROT o/myip2/DATA_DM01_CD_05_dm01celadm02
  0 20 NORMAL UNPROT o/myip2/DATA_DM01_CD_01_dm01celadm02
  0 21 NORMAL UNPROT o/myip2/DATA_DM01_CD_08_dm01celadm02
  0 22 NORMAL UNPROT o/myip2/DATA_DM01_CD_04_dm01celadm02
  0 23 NORMAL UNPROT o/myip2/DATA_DM01_CD_06_dm01celadm02
  0 24 NORMAL UNPROT o/myip/DATA_DM01_CD_09_dm01celadm01
  0 25 NORMAL UNPROT o/myip/DATA_DM01_CD_01_dm01celadm01
  0 26 NORMAL UNPROT o/myip/DATA_DM01_CD_07_dm01celadm01
  0 27 NORMAL UNPROT o/myip/DATA_DM01_CD_06_dm01celadm01
  0 28 NORMAL UNPROT o/myip/DATA_DM01_CD_04_dm01celadm01
  0 29 NORMAL UNPROT o/myip/DATA_DM01_CD_05_dm01celadm01
  0 30 NORMAL UNPROT o/myip/DATA_DM01_CD_02_dm01celadm01
  0 31 NORMAL UNPROT o/myip/DATA_DM01_CD_03_dm01celadm01
  0 32 NORMAL UNPROT o/myip/DATA_DM01_CD_11_dm01celadm01
  0 33 NORMAL UNPROT o/myip/DATA_DM01_CD_10_dm01celadm01
  0 34 NORMAL UNPROT o/myip/DATA_DM01_CD_08_dm01celadm01

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2018

Added on Jan 8 2018

#automatic-storage-management, #performance-availability

2 comments

959 views