Oracle資料庫叢集管理工具停止RAC注意事項

在rac1節點使用Oracle資料庫叢集管理工具停止rac1上面的執行個體，使用crs叢集工具停掉CRS叢集服務：

停止注意：先停止執行個體，在停止CRS服務

啟動注意：先啟動CRS，在啟動執行個體  ---啟動執行個體需要在CRS叢集中註冊

[oracle@HBCADB001 tablespace]$srvctl stop instance -d hbcadb -i hbcadb1

[oracle@HBCADB001 tablespace]$

在節點2上面通過叢集工具檢查當前兩個執行個體的狀態，我們可以看到節點1上面的執行個體已經不在運行了：

[oracle@HBCADB002 ~]$srvctl status database -d hbcadb

Instance hbcadb1 is not running on node hbcadb001

Instance hbcadb2 is running on node hbcadb002

[oracle@HBCADB002 ~]$

 

觀察節點rac1停止的資訊，注意查看oracle的相關進程資訊

[oracle@HBCADB001allbak]$

tail-f /u01/sys_software/oracle/diag/rdbms/hbcadb/hbcadb1/trace/alert_hbcadb1.log

Wed Oct 24 17:41:21 2012

Shutting down instance (immediate)              ----停掉執行個體

Stopping background process SMCO              -----停掉後台進行

Shutting down instance: further logons disabled   

Wed Oct 24 17:41:22 2012

Stopping background process CJQ0             

Stopping background process QMNC

Stopping background process MMNL

Stopping background process MMON

License high water mark = 13

All dispatchers and shared servers shutdown

ALTER DATABASE CLOSENORMAL

Wed Oct 24 17:41:27 2012

SMON: disabling tx recovery

Stopping background process RCBG

SMON: disabling cache recovery

Wed Oct 24 17:41:29 2012

Redo thread 1 internally disabled at seq 2041 (LGWR)

LGWR: Waiting for ORLs to be archived...

Wed Oct 24 17:41:29 2012

ARC1: Archiving disabled thread 1 sequence 2041

Archived Log entry 4117 added for thread 1 sequence 2041 ID 0xe8957542 dest 1:

LGWR: ORLs successfully archived

Shutting down archive processes

Archiving is disabled

Wed Oct 24 17:41:30 2012

ARCH shutting down

Wed Oct 24 17:41:30 2012

ARCH shutting down

Wed Oct 24 17:41:30 2012

ARCH shutting downARCH shutting down

ARC3: Archival stopped

ARC2: Archival stopped

ARC1: Archival stopped

ARC0: Archival stopped

Thread 1 closed at log sequence 2041

Successful close of redo thread 1

Wed Oct 24 17:41:32 2012

Completed: ALTER DATABASE CLOSENORMAL

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Wed Oct 24 17:41:33 2012

NOTE: Shutting down MARK background process

Wed Oct 24 17:41:33 2012

Stopping background process VKTM:

Wed Oct 24 17:41:35 2012

freeing rdom 0

Wed Oct 24 17:41:38 2012

Instance shutdown complete