19c RAC Convert to OneNde
一、新增services:
srvctl add service -d woo -s onenode -r "woo1,woo2" srvctl config service -d woo
二、檢視服務狀態:
[oracle@ora19crac1 ~]$ srvctl config service -d woo Service name: onenode Server pool: Cardinality: 2 Service role: PRIMARY Management policy: AUTOMATIC DTP transaction: false AQ HA notifications: false Global: false Commit Outcome: false Failover type: Failover method: Failover retries: Failover delay: Failover restore: NONE Connection Load Balancing Goal: LONG Runtime Load Balancing Goal: NONE TAF policy specification: NONE Edition: Pluggable database name: Hub service: Maximum lag time: ANY SQL Translation Profile: Retention: 86400 seconds Replay Initiation Time: 300 seconds Drain timeout: Stop option: Session State Consistency: DYNAMIC GSM Flags: 0 Service is enabled Preferred instances: woo1,woo2 Available instances: CSS critical: no
三、檢視資料庫狀態:
[oracle@ora19crac1 ~]$ srvctl status database -d woo Instance woo1 is running on node ora19crac1 Instance woo2 is running on node ora19crac2
四、停掉並移除一個例項:
[oracle@ora19crac1 ~]$ srvctl stop instance -d woo -i woo2 [oracle@ora19crac1 ~]$ srvctl remove instance -d woo -i woo2 Remove instance from the database woo? (y/[n]) y [oracle@ora19crac1 ~]$
五、轉換為OneNode
[oracle@ora19crac1 ~]$ srvctl convert database -d woo -c raconenode -w 30 -i woo
六、檢查資料庫角色:
[oracle@ora19crac1 ~]$ srvctl convert database -d woo -c raconenode -w 30 -i woo [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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-2681291/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 19c OneNode Convert to RAC
- 11gR2 RAC convert ONENODE
- 11gR2 OneNode Convert RAC
- 安裝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