RAC One Node转换为RAC

1.查看状态

?

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

[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,rone2 Database is administrator managed [oracle@rone1 ~]$ srvctl status database -d rone Instance rone_1 is running on node rone1 Online relocation: INACTIVE

2.以oracle用户执行转换

?

1	[oracle@rone1 ~]$ srvctl convert database -d rone -c rac

3.添加新的实例

?

1	[oracle@rone1 ~]$ srvctl add instance -d rone -i rone_2 -n rone2

4.验证转化结果

?

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

[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

 

要先执行转换，然后再添加实例，否则会报以下错误：

?

1 2 3 4 5 6

[oracle@rone1 ~]$ srvctl add instance -d rone -i rone_2 -n rone2 PRKO-2134 : 'srvctl add instance' command is not supported with RAC One Node databases [oracle@rone1 ~]$ oerr prko 2134 2134, ADD_INST_NOT_SUPPORTED_RACONE, "'srvctl add instance' command is not supported with RAC One Node databases" //  *Cause: The specified database does not support 'srvctl add instance' command. // *Action: Convert the RAC One Node database to a RAC database by using the 'srvctl convert database' command and then rerun 'srvctl add instance' command.