rac_第二個節點重啟後無法啟動執行個體：磁碟組dismount問題，racdismount

rac_第二個節點重啟後無法啟動執行個體：磁碟組dismount問題，racdismount

原創作品，出自 “深藍的blog” 部落格，歡迎轉載，轉載時請務必註明以下出處，否則追究著作權法律責任。

深藍的blog：http://blog.csdn.net/huangyanlong/article/details/41480075

 

rac第二個節點重啟後無法啟動執行個體：磁碟組dismount問題

實驗案例：

實驗環境：CentOS 6.4、Oracle 11.2.0.1

現象重演：
1. 重啟第二節點伺服器
2. 手工啟動第二節點執行個體，報錯
[root@node2 ~]# su - oracle
[oracle@node2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 23 15:11:04 2014

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 '+DG1/xcky/spfilexcky.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/xcky/spfilexcky.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DG1/xcky/spfilexcky.ora
ORA-17503: ksfdopn:2 Failed to open file +DG1/xcky/spfilexcky.ora
ORA-15001: diskgroup "DG1" does not exist or is not mounted
ORA-06512: at line 4
根據上面的錯誤，鎖定到ORA-15001錯誤，這是代表有磁碟組沒有mount，於是按照這個思路進行查看。

3. grid使用者下，查看磁碟組狀態
[root@node2 ~]# su - grid
[grid@node2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 23 15:27:04 2014

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 name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
CRS                            MOUNTED
DG1                            DISMOUNTED
RCY1                           DISMOUNTED
可以發現，DG1、RCY1磁碟組處於dismounted狀態，於是手工啟動到mount狀態，如下操作：

4. 啟動磁碟組到mount狀態
需要注意，對磁碟組操作時，需要使用sysasm使用者，該使用者有對磁碟組操作的許可權，如下：
SQL> conn /as sysasm
Connected.

SQL> select name,state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
CRS                            MOUNTED
DG1                            DISMOUNTED
RCY1                           DISMOUNTED

SQL> alter diskgroup DG1 mount;
Diskgroup altered.

SQL> alter diskgroup RCY1 mount;
Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
CRS                            MOUNTED
DG1                            MOUNTED
RCY1                           MOUNTED
至此，完成了將全部磁碟組啟動到mount狀態。

5. 再次啟動節點2的執行個體
[root@node2 ~]# su - oracle
[oracle@node2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 23 15:31:11 2014

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  730714112 bytes
Fixed Size                  2216944 bytes
Variable Size             557845520 bytes
Database Buffers          167772160 bytes
Redo Buffers                2879488 bytes
Database mounted.
Database opened.
SQL>  select status,instance_name from gv$instance;
--查詢整個叢集環境，可以看到兩個節點都已經啟動了
STATUS       INSTANCE_NAME
------------ ----------------
OPEN         xcky2
OPEN         xcky1

至此，由於磁碟組處於dismount狀態引起的單節點執行個體無法啟動問題，解決。

 

原創作品，出自 “深藍的blog” 部落格，歡迎轉載，轉載時請務必註明以下出處，否則追究著作權法律責任。

深藍的blog：http://blog.csdn.net/huangyanlong/article/details/41480075