RAC转换为RAC One Node

最新推荐文章于 2021-10-25 22:48:33 发布

转载最新推荐文章于 2021-10-25 22:48:33 发布 · 73 阅读

0 ·

CC 4.0 BY-SA版权

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

文章标签：

#数据库

本文介绍如何通过srvctl命令查看Oracle数据库状态、停止实例、移除实例，并最终将RAC数据库转换为RAC One Node模式。转换过程中包括实例的移除及正式转换步骤，并验证了转换后的数据库配置。

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>

转载于:https://www.cnblogs.com/abclife/p/5900399.html