Oracle RAC convert to RAC One Node操作步骤

鸿惊九天

561

30页

7次

2020-04-28

5墨值下载

Oracle RAC convert to RAC One Node

操作步骤

环境说明：

Redhat 6.3x64+oracle11.2.0.3 rac+asm

数据库名：zxm

实例名：zxm1,zxm2

目标转换为 racone

以下操作均用 oracle 用户在节点 rac01 操作。

停止和移除原来的实例

srvctl stop database -d zxm

srvctl remove instance -d zxm -i zxm1

srvctl remove instance -d zxm -i zxm2

增加一个实例

srvctl add instance -d zxm -i zxm_1 -n rac01

添加服务

手动添加服务：

begin

dbms_service.CREATE_SERVICE

('APP',

'APP',

FAILOVER_METHOD=>dbms_service.FAILOVER_METHOD_BASIC,

FAILOVER_TYPE=>dbms_service.FAILOVER_TYPE_SELECT,

FAILOVER_RETRIES=>300

);

end;

srvctl add service -d zxm -s app -r zxm_1 -P BASIC -e SELECT -m BASIC -y AUTOMATIC

检查服务：

oracle@rac01:/home/oracle(zxm1)>srvctl config service -d zxm

Service name: app

Service is enabled

Server pool: zxm_app

Cardinality: 1

Disconnect: false

Service role: PRIMARY

Management policy: AUTOMATIC

DTP transaction: false

AQ HA notifications: false

Failover type: SELECT

Failover method: BASIC

TAF failover retries: 0

TAF failover delay: 0

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: NONE

TAF policy specification: BASIC

Edition:

Preferred instances: zxm_1

Available instances:

手动启动服务

srvctl start service -d zxm -s app

转换为

RAC One Node

srvctl convert database -d zxm -c RACONENODE -i zxm_1

检查结果：

oracle@rac01:/home/oracle(zxm1)>srvctl config database -d zxm

Database unique name: zxm

Database name: zxm

Oracle home: /home/oracle/11.2.0/db_1

Oracle user: oracle

Spfile: +DATA/zxm/spfilezxm.ora

Domain:

Start options: open

of 30

5墨值下载

oracle 安装部署

关注

评论