RAC转换为RAC One Node

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>