11gR2 OneNode Convert RAC

                           11gR2 OneNode Convert RAC

 

一、查看状态

[oracle@ora11grac1 ~]$ srvctl config database -d woo
Database unique name: woo
Database name: woo
Oracle home: /DBSoft/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA001/woo/spfilewoo.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: woo
Database instances:
Disk Groups: DATA001,ARC_001
Mount point paths:
Services: onenode
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: woo
Candidate servers: ora11grac1
Database is administrator managed

 

二、转换为RAC：

[oracle@ora11grac1 ~]$ srvctl convert database -d woo -c rac

 

三、添加新实例：

[oracle@ora11grac1 ~]$ srvctl add instance -d woo -i woo2 -n ora11grac2

 

四、检查转换后的结果：

[oracle@ora11grac1 ~]$ srvctl config database -d woo
Database unique name: woo
Database name: woo
Oracle home: /DBSoft/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA001/woo/spfilewoo.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: woo
Database instances: woo1,woo2
Disk Groups: DATA001,ARC_001
Mount point paths:
Services: onenode
Type: RAC
Database is administrator managed

 

五、启动节点二的实例：

[oracle@ora11grac1 ~]$ srvctl start instance -d woo -n ora11grac2
[oracle@ora11grac1 ~]$ srvctl status database -d woo
Instance woo1 is running on node ora11grac1
Instance woo2 is running on node ora11grac2