重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-15001: diskgroup "DATA" does not exist or is not mounted [打印本页]

作者: mahan 时间: 2022-7-13 15:23
标题: ORA-15001: diskgroup "DATA" does not exist or is not mounted

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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)