首页 > 代码库 > RAC转换为RAC One Node
RAC转换为RAC One Node
1.查看数据库状态
[oracle@rone1 ~]$ srvctl config database -d roneDatabase unique name: roneDatabase name: roneOracle home: /u01/app/oracle/product/11.2.0/dbhome_1Oracle user: oracleSpfile: +DATA/rone/spfilerone.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: roneDatabase instances: rone_1,rone_2Disk Groups: DATA,CRSMount point paths: Services: bboneType: RACDatabase is administrator managed[oracle@rone1 ~]$ srvctl status database -d roneInstance rone_1 is running on node rone1Instance 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_2Remove 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 roneDatabase unique name: roneDatabase name: roneOracle home: /u01/app/oracle/product/11.2.0/dbhome_1Oracle user: oracleSpfile: +DATA/rone/spfilerone.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: roneDatabase instances: Disk Groups: DATA,CRSMount point paths: Services: bboneType: RACOneNodeOnline relocation timeout: 30Instance name prefix: roneCandidate servers: rone1Database is administrator managed[oracle@rone1 ~]$ srvctl status database -d roneInstance rone_1 is running on node rone1Online relocation: INACTIVE
语法：
srvctl convert database -d <db_unique_name> -c RACONENODE -i <inst prefix> -w <timeout>
RAC转换为RAC One Node
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。