[重庆思庄每日技术分享]-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

DATADGDISMOUNTED

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

ARCHDGMOUNTED

切换到数据库实例的用户

sqlplus / as sysdba

SQL> startup

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值