RAC转换为RAC One Node

1.查看数据库状态

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

[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

?

1	[oracle@rone2 trace]$ srvctl stop instance -d rone -n rone2

3.移除一个实例

?

1 2	[oracle@rone1 ~]$ srvctl remove instance -d rone -i rone_2 Remove instance from the database rone? (y/[n]) y

4.正式转换

?

1	[oracle@rone1 ~]$ srvctl convert database -d rone -c raconenode -w 30 -i rone

5.转换后验证

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

[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

　　

 

语法：

?

1	srvctl convert database -d <db_unique_name> -c RACONENODE -i <inst prefix> -w <timeout>