RAC One Node转换为RAC

最新推荐文章于 2025-08-15 10:38:51 发布

weixin_34342905

最新推荐文章于 2025-08-15 10:38:51 发布

阅读量173

点赞数

文章标签：数据库

本文介绍如何将 RAC One Node 数据库转换为 RAC，并添加新实例的过程。首先通过 srvctl 命令检查当前数据库状态，接着执行转换操作，最后添加新实例并验证结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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: 
Disk Groups: DATA,CRS
Mount point paths: 
Services: bbone
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: rone
Candidate servers: rone1,rone2
Database is administrator managed
[oracle@rone1 ~]$ srvctl status database -d rone
Instance rone_1 is running on node rone1
Online relocation: INACTIVE

2.以oracle用户执行转换

[oracle@rone1 ~]$ srvctl convert database -d rone -c rac

3.添加新的实例

[oracle@rone1 ~]$ srvctl add instance -d rone -i rone_2 -n rone2

4.验证转化结果

[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 add instance -d rone -i rone_2 -n rone2
PRKO-2134 : 'srvctl add instance' command is not supported with RAC One Node databases
[oracle@rone1 ~]$ oerr prko 2134
2134, ADD_INST_NOT_SUPPORTED_RACONE, "'srvctl add instance' command is not supported with RAC One Node databases"
//  *Cause: The specified database does not support 'srvctl add instance' command.
// *Action: Convert the RAC One Node database to a RAC database by using the 'srvctl convert database' command and then rerun 'srvctl add instance' command.