19c OneNode Convert to RAC
一、檢視狀態
[oracle@ora19crac1 ~]$ srvctl config database -d woo Database unique name: woo Database name: woo Oracle home: /u01/app/oracle/product/19.3.0/dbhome_1 Oracle user: oracle Spfile: +DATA_GP01/WOO/PARAMETERFILE/spfile.272.1034102483 Password file: +DATA_GP01/WOO/PASSWORD/pwdwoo.256.1034100671 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DATA_GP01 Mount point paths: Services: onenode,server_taf Type: RACOneNode Online relocation timeout: 30 Instance name prefix: woo Candidate servers: ora19crac1 OSDBA group: dba OSOPER group: oper Database instances: woo_1 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed
二、轉換為RAC
[oracle@ora19crac1 ~]$ srvctl add instance -d woo -i woo2 -n ora19crac2
三、查詢轉換後的結果:
[oracle@ora19crac1 ~]$ srvctl config database -d woo Database unique name: woo Database name: woo Oracle home: /u01/app/oracle/product/19.3.0/dbhome_1 Oracle user: oracle Spfile: +DATA_GP01/WOO/PARAMETERFILE/spfile.272.1034102483 Password file: +DATA_GP01/WOO/PASSWORD/pwdwoo.256.1034100671 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DATA_GP01 Mount point paths: Services: onenode,server_taf Type: RAC Start concurrency: Stop concurrency: OSDBA group: dba OSOPER group: oper Database instances: woo1,woo2 Configured nodes: ora19crac1,ora19crac2 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed
四、啟動節點二例項:
[oracle@ora19crac1 ~]$ srvctl start instance -d woo -n ora19crac2 [oracle@ora19crac1 ~]$ srvctl status database -d woo Instance woo1 is running on node ora19crac1 Instance woo2 is running on node ora19crac2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-2681292/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 11gR2 RAC convert ONENODE
- 11gR2 OneNode Convert RAC
- 19c RAC Convert to OneNde
- 安裝RAC 19C
- 手工清理19c RAC環境
- Oracle 19c RAC INS-40724Oracle
- How To Deal With Split Brain In Oracle 19c RacAIOracle
- Oracle Linux 7.1 silent install 19C RACOracleLinux
- Disable Tfa In Oracle 19c RAC-20220112Oracle
- G003-ORACLE-INS-RAC-01 ORACLE 19C RAC Ins ON OEL 7.8Oracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建(六)建立RAC資料庫UIOracle資料庫
- Oracle:Oracle RAC 11.2.0.4 升級為 19cOracle
- CRS Resource Introduction In Oracle 19c RAC-20220125Oracle
- Rename or Move a datafile In Oracle 19c RAC-20220117Oracle
- Disable Database Audit In Oracle 19c RAC-20220111DatabaseOracle
- 19c rac資料庫如何新增mgmt資料庫
- Oracle 19C RAC腦裂問題分析Oracle
- 【DG】Oracle 19c使用dbca來搭建物理DG--主rac備racOracle
- oracle aix平臺19c rac互信不通案例OracleAI
- 19c rac自動打補丁步驟
- How To Deal With Split Brain In Oracle 19c Rac-202203AIOracle
- Oracle 19c RAC on Linux 7.6安裝手冊OracleLinux
- Log And Trc Location n In Oracle 19c RAC-20220118Oracle
- Overview of Oracle Flex ASM In Oracle 19c RAC-20220111ViewOracleFlexASM
- 靜默安裝19C RAC的指令碼指令碼
- oracle 19c rac打補丁常見錯誤Oracle
- 19c 資料高可用實用配置 RAC + SingleADG
- 19c 探索高可用系列(二) - RAC+DataGuard Broker
- Oracle Database 19c(19.9) RAC On RedHat 8.3 Using VirtualBox and MacBookOracleDatabaseRedhatMac
- 【TUNE_ORACLE】Oracle 19c RAC搭建番外篇之RAC引數配置參考(五)Oracle
- 【TUNE_ORACLE】Oracle 19c RAC搭建番外篇之RAC引數配置參考(四)Oracle
- 【TUNE_ORACLE】Oracle 19c RAC搭建番外篇之RAC引數配置參考(三)Oracle
- 【TUNE_ORACLE】Oracle 19c RAC搭建番外篇之RAC引數配置參考(二)Oracle
- 【TUNE_ORACLE】Oracle 19c RAC搭建番外篇之RAC引數配置參考(一)Oracle
- Oracle 19c RAC打補丁過程避坑指南Oracle
- Oracle 19C RAC open_links_per_instance引數問題Oracle
- 7.60 CONVERT
- 簡單介紹Oracle 19c RAC 手工建庫的過程Oracle