一、添加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
