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

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

HOST-> sqlplus "/as sysdba"

 

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 1 10:13:58 2011

 

Copyright (c) 1982, 2009, Oracle. All rights reserved.

 

Connected to an idle instance.

 

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:

 

HOST-> sqlplus "/as sysdba"

 

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 1 10:32:27 2011

 

Copyright (c) 1982, 2009, Oracle. All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

 

SQL> select * from v$instance;

 

 

SQL> select name,state from v$asm_diskgroup;

 

NAME                          STATE

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

GRIDDG                        MOUNTED

DATADG                        DISMOUNTED

ARCHDG                        DISMOUNTED

 

 

SQL> alter diskgroup archdg mount;

alter diskgroup archdg mount

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15260: permission denied on ASM disk group

 

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

 

SQL> alter diskgroup datadg mount;

 

Diskgroup altered.

 

SQL> select name,state from v$asm_diskgroup;

 

NAME                          STATE

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

GRIDDG                        MOUNTED

DATADG                        MOUNTED

ARCHDG                        MOUNTED

 

SQL>

 

 

切换到数据库实例的用户

su - oraoms

 

 

sqlplus "/as sysdba"

SQL> startup

ORACLE instance started.

 

Total System Global Area 4.7835E+10 bytes

Fixed Size                 2180736 bytes

Variable Size           4.3889E+10 bytes

Database Buffers        3892314112 bytes

Redo Buffers              51732480 bytes

Database mounted.

Database opened.

SQL>