1.查看数据库状态
[oracle@rone1 ~]$ srvctl config database -d rone
Database unique name: rone
Database name: rone
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/rone/spfilerone.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: rone
Database instances: rone_1,rone_2
Disk Groups: DATA,CRS
Mount point paths:
Services: bbone
Type: RAC
Database is administrator managed [oracle@rone1 ~]$ srvctl status database -d rone
Instance rone_1 is running on node rone1
Instance rone_2 is running on node rone2
2.停掉一个instance
[oracle@rone2 trace]$ srvctl stop instance -d rone -n rone2
3.移除一个实例
[oracle@rone1 ~]$ srvctl remove instance -d rone -i rone_2
Remove instance from the database rone? (y/[n]) y
4.正式转换
[oracle@rone1 ~]$ srvctl convert database -d rone -c raconenode -w 30 -i rone
5.转换后验证
[oracle@rone1 ~]$ srvctl config database -d rone
Database unique name: rone
Database name: rone
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/rone/spfilerone.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: rone
Database instances:
Disk Groups: DATA,CRS
Mount point paths:
Services: bbone
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: rone
Candidate servers: rone1
Database is administrator managed [oracle@rone1 ~]$ srvctl status database -d rone
Instance rone_1 is running on node rone1
Online relocation: INACTIVE
语法:
srvctl convert database -d <db_unique_name> -c RACONENODE -i <inst prefix> -w <timeout>