Oracle
oracle 12c rac 開關從安裝到打開
如何從“已安裝”狀態正確打開 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