Oracle

oracle 12c rac 開關從安裝到打開

  • August 22, 2017

如何從“已安裝”狀態正確打開 RAC 數據庫(版本 12.1)?

早些時候,節點 #01 和 #02 是由 command 手動打開的alter database open

現在,處於這種狀態的數據庫:

SQL> select instance_name,status from gv$instance;
INSTANCE_NAME    STATUS
node01          OPEN
node02          OPEN
node04          MOUNTED
node03          MOUNTED

~$ srvctl status database -d cldb -v
Instance node01 is running on node srv-n01. Instance status: Open,Readonly.
Instance node02 is running on node srv-n02. Instance status: Open,Readonly.
Instance node03 is running on node srv-n03. Instance status: Mounted (Closed).
Instance node04 is running on node srv-n04. Instance status: Mounted (Closed).

連接到第三個實例並發出

SQL> alter database open;

然後到第四審並做同樣的事情。

但是如果你想一次打開所有實例,你需要使用srvctl實用程序:

srvctl start database -db db_name

https://docs.oracle.com/database/121/RACAD/GUID-C9DB4DCB-34B9-42F0-8AB4-33199087CE98.htm#RACAD900

引用自:https://dba.stackexchange.com/questions/183966