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

mahan

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

问题：

sqlplus / as sysdba

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATADG/orcl/spfileorcl.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATADG/orcl/spfileorcl.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATADG/orcl/spfileorcl.ora

ORA-17503: ksfdopn:2 Failed to open file +DATADG/orcl/spfileorcl.ora

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

ORA-06512: at line 4

SQL> exit

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

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

su - grid

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