RAC CONERT TO RACOneNode
1、检查当前数据库状态
[oracle@node2 trace]$ srvctl status database -d ora11g
Instance ora11g_1 is running on node node1
Instance ora11g_2 is running on node node2

2、转换RAC to RACOneNode
[oracle@node2 trace]$ srvctl convert database -d ora11g -c RACONENODE -i ora11g_1
PRCD-1214 : Administrator-managed RAC database ora11g has more than one instance

转到RACOneNode时,必须配置service
转到RACOneNode时,需要关闭其他实例,并删除其他节点的instance
[oracle@node2 trace]$ srvctl stop instance -d ora11g -n node2
[oracle@node2 trace]$ srvctl remove instance -d ora11g -i ora11g_2
Remove instance from the database ora11g? (y/[n]) y

3、检查数据库配置
[oracle@node2 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 —->只有一个节点
Disk Groups: DATADG
Mount point paths:
Services: svr11g —–>必须存在service
Type: RAC
Database is enabled
Database is administrator managed

4、转换到RACOneNode
[oracle@node2 trace]$ srvctl convert database -d ora11g -c RACONENODE -i ora11g_1
[oracle@node2 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 ————>转换成功
Online relocation timeout: 30
Instance name prefix: ora11g
Candidate servers: node1
Database is enabled
Database is administrator managed

5、进行RACOneNode relocate测试
[oracle@node1 ~]$ srvctl relocate database -d ora11g -n node2




Related posts

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

only 1 comment untill now

  1. convert@barden.longitudinal” rel=”nofollow”>.…

    ñïàñèáî!!…

Add your comment now

无觅相关文章插件