bay——RAC_ASM ORA-15001 diskgroup DATA does not exist or is not mounted.docx

RAC ORA-15001: diskgroup "DATA" does not exist or is not mounted

 

 

Oracle数据库识别不了存储Diskgroup ORA-01078，需要Mount

问题：

HOST-> sqlplus "/as sysdba"

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATADG/xcoms/spfilexcoms.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATADG/xcoms/spfilexcoms.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATADG/xcoms/spfilexcoms.or

a

ORA-17503: ksfdopn:2 Failed to open file +DATADG/xcoms/spfilexcoms.ora

ORA-15001: diskgroup "DATADG" does not exist or is not mounted

ORA-06512: at line 4

SQL> exit

 

需要把存储的磁盘diskgroup组mount进来。

1、进入到asm的用户，asm已经启动

HOST-> su - grid

Password:

 SQL> select * from v$instance;

SQL> select name,state from v$asm_diskgroup;

 

NAME                          STATE

------------------------------ -----------

GRIDDG                        MOUNTED

DATADG                        DISMOUNTED

ARCHDG                        DISMOUNTED

 

解决：

Oracle11g中asm实例不能使用sys用户，使用sysasm用户：

SQL> conn /as sysasm

Connected.

SQL> alter diskgroup archdg mount;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;

NAME                          STATE

------------------------------ -----------

GRIDDG                        MOUNTED

DATADG                        DISMOUNTED

ARCHDG                        MOUNTED

 

 切换到数据库实例的用户

sqlplus "/as sysdba"

SQL> startup