首页 > 其他 > 详细

RAC转换为RAC One Node

时间:2016-09-23 16:36:12      阅读:173      评论:0      收藏:0      [点我收藏+]

1.查看数据库状态

[oracle@rone1 ~]$ srvctl config database -d rone
Database unique name: rone
Database name: rone
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/rone/spfilerone.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: rone
Database instances: rone_1,rone_2
Disk Groups: DATA,CRS
Mount point paths: 
Services: bbone
Type: RAC
Database is administrator managed

[oracle@rone1 ~]$ srvctl status database -d rone
Instance rone_1 is running on node rone1
Instance rone_2 is running on node rone2

2.停掉一个instance

[oracle@rone2 trace]$ srvctl stop instance -d rone -n rone2

3.移除一个实例

[oracle@rone1 ~]$ srvctl remove instance -d rone -i rone_2
Remove instance from the database rone? (y/[n]) y

4.正式转换

[oracle@rone1 ~]$ srvctl convert database -d rone -c raconenode -w 30 -i rone

5.转换后验证

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

[oracle@rone1 ~]$ srvctl status  database -d rone
Instance rone_1 is running on node rone1
Online relocation: INACTIVE

  

 

语法:

srvctl convert database -d <db_unique_name> -c RACONENODE -i <inst prefix> -w <timeout>

  

RAC转换为RAC One Node

原文:http://www.cnblogs.com/abclife/p/5900399.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!