11gR2 OneNode Convert RAC

11gR2 OneNode Convert RAC

一、查看状态：

[oracle@ora11grac1 ~]$ srvctl config database -d wooDatabase unique name: wooDatabase name: wooOracle home: /DBSoft/oracle/product/11.2.0/dbhome_1Oracle user: oracleSpfile: +DATA001/woo/spfilewoo.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: wooDatabase instances: Disk Groups: DATA001,ARC_001Mount point paths: Services: onenodeType: RACOneNodeOnline relocation timeout: 30Instance name prefix: wooCandidate servers: ora11grac1Database 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 wooDatabase unique name: wooDatabase name: wooOracle home: /DBSoft/oracle/product/11.2.0/dbhome_1Oracle user: oracleSpfile: +DATA001/woo/spfilewoo.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: wooDatabase instances: woo1,woo2Disk Groups: DATA001,ARC_001Mount point paths: Services: onenodeType: RACDatabase is administrator managed

启动节点二的实例：

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