一、查看状态
[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
当前名称：19cOneNodeConverttoRAC
新闻来源：
http://bzwzjz.com/article/iesgis.html
