Oracle RAC One Node convert to RAC操作步骤
5墨值下载
Oracle RAC One Node convert to RAC
操作步骤
CopyRight By Jieyancai
环境说明：
Redhat 6.3x64+oracle11.2.0.3 racone+asm
数据库名：zxm 应用服务名：app
目标转换为 RAC zxm1,zxm2
以下操作均用 oracle 用户操作。
1.
转换操作
srvctl stop database -d zxm
srvctl convert database -d zxm -c RAC
2.
移除原来的服务和实例
移除服务：
srvctl remove service -d zxm -s app
移除实例：
srvctl remove instance -d zxm -i zxm_1
srvctl remove instance -d zxm -i zxm_2
查看原来的实例及服务名称：
srvctl config service -d zxm
srvctl config database -d zxm
oracle@rac01:/home/oracle(jyc1)>srvctl config database -d zxm -a
Database unique name: zxm
Database name: zxm
Oracle home: /home/oracle/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/zxm/spfilezxm.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: zxm
Database instances:
Disk Groups: DATA,RECO
Mount point paths:
Services: app
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: zxm
Candidate servers: rac01,rac02
Database is enabled
Database is administrator managed
oracle@rac02:/home/oracle(jyc2)>srvctl config service -d zxm
Service name: app
Service is enabled
Server pool: zxm
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: BASIC
Edition:
Preferred instances: zxm_2
Available instances:
3.
添加实例
srvctl add instance -d zxm -i zxm1 -n rac01
srvctl add instance -d zxm -i zxm2 -n rac02
crsctl stat res -t
oracle@rac01:/home/oracle(jyc1)>srvctl modify instance -d zxm -i zxm1 -s +ASM1
Warning:-s option has been deprecated and will be ignored.
of 30
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论