转换RACOneNode到 RAC测试
1、检查DATABASE配置
[oracle@node1 trace]$ srvctl config database -d ora11g -a
Database unique name: ora11g
Database name: ora11g
Oracle home: /oracle/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATADG/ora11g/spfileora11g.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ora11g
Database instances: ——>数据库实例为空
Disk Groups: DATADG
Mount point paths:
Services: svr11g
Type: RACOneNode ——>当前数据库类型为RACOneNode
Online relocation timeout: 30
Instance name prefix: ora11g —–>实例名前缀
Candidate servers: node1,node2
Database is enabled
Database is administrator managed

检查数据库状态
[oracle@node1 trace]$ srvctl status database -d ora11g
Instance ora11g_1 is running on node node1 ——>实例运行在NODE1
Online relocation: INACTIVE

2、检查切换后的service配置
[oracle@node1 trace]$ srvctl config service -d ora11g -s svr11g
Service name: svr11g
Service is enabled
Server pool: ora11g
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Preferred instances: ora11g_1 ———->优选实例
Available instances:

3、进行RACOneNode转换RAC
[oracle@node1 ~]$ srvctl convert database -d ora11g -c RAC -n node1
此步骤操作在线完成,只是修改OCR里DATABASE的配置信息

4、检查转换后数据库配置
[oracle@node1 ~]$ srvctl config database -d ora11g -a
Database unique name: ora11g
Database name: ora11g
Oracle home: /oracle/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATADG/ora11g/spfileora11g.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ora11g
Database instances: ora11g_1 ———–>转换后实例名变成ORA11G_1
Disk Groups: DATADG
Mount point paths:
Services: svr11g
Type: RAC ————>数据库类型为RAC
Database is enabled
Database is administrator managed

5、检查转换后SERVICE的配置
[oracle@node1 trace]$ srvctl config service -d ora11g -s svr11g
Service name: svr11g
Service is enabled
Server pool: ora11g_svr11g ———->转换后SERVER POOL发生变化
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Preferred instances: ora11g_1
Available instances:

6、为了使2节点启动实例,需要增加INSTANCE
[oracle@node1 trace]$ srvctl add instance -d ora11g -i ora11g_2 -n node2
[oracle@node1 trace]$ srvctl config database -d ora11g -a
Database unique name: ora11g
Database name: ora11g
Oracle home: /oracle/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATADG/ora11g/spfileora11g.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ora11g
Database instances: ora11g_1,ora11g_2 ——->增加ora11g_2实例
Disk Groups: DATADG
Mount point paths:
Services: svr11g
Type: RAC
Database is enabled
Database is administrator managed

7、启动节点2实例
[oracle@node1 trace]$ srvctl start database -d ora11g -n node2
SQL> select thread#,status,enabled,instance from v$thread;
THREAD# STATUS ENABLED INSTANCE
———- —— ——– ——————–
1 OPEN PUBLIC ora11g_1
2 OPEN PUBLIC ora11g_2 —–>2节点成功启动

8、修改SERVICE属性
[oracle@node1 trace]$ srvctl config service -d ora11g -s svr11g
Service name: svr11g
Service is enabled
Server pool: ora11g_svr11g
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Preferred instances: ora11g_1
Available instances: —–>增加可选实例

[oracle@node1 trace]$ srvctl modify service -d ora11g -s svr11g -n -i ora11g_1 -a ora11g_2
[oracle@node1 trace]$ srvctl config service -d ora11g -s svr11g
Service name: svr11g
Service is enabled
Server pool: ora11g_svr11g
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Preferred instances: ora11g_1
Available instances: ora11g_2




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件