19c OneNode Convert to RAC

一、查看状态

[oracle@ora19crac1 ~]$ srvctl config database -d wooDatabase unique name: wooDatabase name: wooOracle home: /u01/app/oracle/product/19.3.0/dbhome_1Oracle user: oracleSpfile: +DATA_GP01/WOO/PARAMETERFILE/spfile.272.1034102483Password file: +DATA_GP01/WOO/PASSWORD/pwdwoo.256.1034100671Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: Disk Groups: DATA_GP01Mount point paths: Services: onenode,server_tafType: RACOneNodeOnline relocation timeout: 30Instance name prefix: wooCandidate servers: ora19crac1OSDBA group: dbaOSOPER group: operDatabase instances: woo_1CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default 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 wooDatabase unique name: wooDatabase name: wooOracle home: /u01/app/oracle/product/19.3.0/dbhome_1Oracle user: oracleSpfile: +DATA_GP01/WOO/PARAMETERFILE/spfile.272.1034102483Password file: +DATA_GP01/WOO/PASSWORD/pwdwoo.256.1034100671Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: Disk Groups: DATA_GP01Mount point paths: Services: onenode,server_tafType: RACStart concurrency: Stop concurrency: OSDBA group: dbaOSOPER group: operDatabase instances: woo1,woo2Configured nodes: ora19crac1,ora19crac2CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services: Database is administrator managed

四、启动节点二实例：

[oracle@ora19crac1 ~]$ srvctl start instance -d woo -n ora19crac2[oracle@ora19crac1 ~]$ srvctl status database -d wooInstance woo1 is running on node ora19crac1Instance woo2 is running on node ora19crac2