8.1 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>