RAC One Node与RAC互相转换

A琳琳

1499

4页

5次

2020-04-27

10墨值下载

Oracle RACOne Node -- Changes in 11.2.0.2 (Doc ID 1232802.1)

http://docs.oracle.com/cd/E11882_01/rac.112/e41960/onenode.htm#RACAD7894

一、RAC One Node 转换为 RAC

备份 spfile

SQL> create pfile='/home/oracle/1.txt' from spfile;

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

--查看服务配置

[oracle@rone1 ~]$ srvctl config service -d rone

2.以 oracle 用户执行转换

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

3.添加新的实例

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

[oracle@rac11g01 ~]$ srvctl stop service -d rone -s onesrv

[oracle@rac11g01 ~]$ srvctl remove service -d rone -s onesrv

[oracle@rac11g01 ~]$ srvctl stop instance -d rone -i rone_1

[oracle@rac11g01 ~]$ srvctl remove instance -d rone -i rone_1

Remove instance from the database rone? (y/[n]) y

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

[oracle@rac11g01 ~]$ srvctl add service -d rone -s onesrv -r "rone1,rone2" -P

BASIC

4.验证转化结果

[oracle@rac11g01 ~]$ srvctl config database -d rone

Database unique name: rone

Database name: rone

Oracle home: /u01/app/oracle/product/11.2.0/db_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: rone1,rone2

Disk Groups: DATA

Mount point paths:

Services: onesrv

Type: RAC

Database is administrator managed

5.启动实例

[oracle@rac11g01 dbs]$ srvctl start instance -d rone -i rone1

[oracle@rac11g01 dbs]$ srvctl start instance -d rone -i rone2

####可能会报错

PRCR-1013 : Failed to start resource ora.rone.db

PRCR-1064 : Failed to start resource ora.rone.db on node rac11g02

CRS-5017: The resource action "ora.rone.db start" encountered the following

error:

ORA-29760: instance_number parameter not specified

. For details refer to "(:CLSN00107:)" in

"/u01/app/11.2.0/grid/log/rac11g02/agent/crsd/oraagent_oracle/oraagent_oracle.lo

处理方法，重建参数：

cat /tmp/rone.ora

*.audit_file_dest='/u01/app/oracle/admin/rone/adump'

*.audit_trail='none'

*.cluster_database=true

*.compatible='11.2.0.4.0'

*.control_files='+DATA/rone/controlfile/current.268.1036519315'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_name='rone'

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=roneXDB)'

*.open_cursors=300

*.pga_aggregate_target=182452224

*.processes=150

*.remote_listener='scan-mesprd:1521'

*.remote_login_passwordfile='exclusive'

*.sga_target=547356672

rone2.instance_number=2

rone1.instance_number=1

rone2.thread=2

rone1.thread=1

rone1.undo_tablespace='UNDOTBS1'

rone2.undo_tablespace='UNDOTBS2'

SQL> startup pfile='/tmp/rone.ora';

SQL> create spfile='+DATA' from pfile='/tmp/rone.ora';

su - grid

ASMCMD> mkalias +DATA/RONE/PARAMETERFILE/spfile.280.1036573657 spfilerone.ora

ASMCMD> ls -lrt

WARNING:option 'r' is deprecated for 'ls'

please use 'reverse'

Type Redund Striped Time Sys Name

of 4

10墨值下载

关注

评论