dg迁移windows到linux,单实例到RAC 数据库迁移方案之DG方式迁移

14.重启主库使修改的参数生效

1)停主库前，先停掉备库的日志应用

alter database recover managed standby database cancel;

2)停主库

shutdown immediate;

3)startup;

--查看rac相关参数是否生效，tail -f 主备库的alert日志，观察是否有报错，DG是否正常

show parameter cluster;

15.添加其他节点的redo及undo

1)redo

alter database

add logfile thread 2

group 4('/data01/egapdb/redo04.log') size 50M,

group 5('/data01/egapdb/redo05.log') size 50M,

group 6('/data01/egapdb/redo06.log') size 50M;

alter database enable publicthread 2;

2)undo

create undo tablespace UNDOTBS2 datafile '/data01/egapdb/undotbs02.dbf'size 200m;

alter system setundo_tablespace='undotbs2'sid='egapdb2';--如果参数文件中已修改则可以省略此步

16.在备库添加第二个实例的standby log(不建好像也可以)

17.在备库设置db_recovery_file_dest，db_recovery_file_dest_size参数

--如果不设该参数，备库会报错(主库添加第二个实例日志，在备库应用会报错)

OpenVMS: Error Creating Redo Logs In Standby Database ORA-01264: Unable to create logfile file name (Doc ID 1376892.1)

8.在第二个节点打开数据库

--tail -f 主备库alert日志，查看是否有报错，DG是否正常

export Oracle_SID=egapdb2

sqlplus / as sysdba

startup

19.向crs中注册资源

1)查看注册前集群中资源

grid@egapdb2:/home/grid$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE ONLINE egapdb1

ora....N1.lsnr ora....er.type ONLINE ONLINE egapdb1

ora....N2.lsnr ora....er.type ONLINE ONLINE egapdb2

ora....N3.lsnr ora....er.type ONLINE ONLINE egapdb2

ora.asm ora.asm.type OFFLINE OFFLINE

ora.cvu ora.cvu.type ONLINE ONLINE egapdb2

ora....SM1.asm application OFFLINE OFFLINE

ora....B1.lsnr application ONLINE ONLINE egapdb1

ora....db1.gsd application OFFLINE OFFLINE

ora....db1.ons application ONLINE ONLINE egapdb1

ora....db1.vip ora....t1.type ONLINE ONLINE egapdb1

ora....SM2.asm application OFFLINE OFFLINE

ora....B2.lsnr application ONLINE ONLINE egapdb2

ora....db2.gsd application OFFLINE OFFLINE

ora....db2.ons application ONLINE ONLINE egapdb2

ora....db2.vip ora....t1.type ONLINE ONLINE egapdb2

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE egapdb1

ora.oc4j ora.oc4j.type ONLINE ONLINE egapdb2

ora.ons ora.ons.type ONLINE ONLINE egapdb1

ora....ry.acfs ora....fs.type OFFLINE OFFLINE

ora.scan1.vip ora....ip.type ONLINE ONLINE egapdb1

ora.scan2.vip ora....ip.type ONLINE ONLINE egapdb2

ora.scan3.vip ora....ip.type ONLINE ONLINE egapdb2

2)注册(在任意一个节点添加即可)

srvctl add database -d -o -p

srvctl add instance -d -i -n

srvctl add instance -d -i -n

--如果用的是asm的话还需要添加数据库实例同asm实例的对应关系

srvctl modify instance -d -i -s

srvctl modify instance -d -i -s

3)查看注册后的集群资源

grid@egapdb2:/home/grid$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE ONLINE egapdb1

ora....N1.lsnr ora....er.type ONLINE ONLINE egapdb1

ora....N2.lsnr ora....er.type ONLINE ONLINE egapdb2

ora....N3.lsnr ora....er.type ONLINE ONLINE egapdb2

ora.asm ora.asm.type OFFLINE OFFLINE

ora.cvu ora.cvu.type ONLINE ONLINE egapdb2

ora.egapdb.db ora....se.type OFFLINE OFFLINE

ora....SM1.asm application OFFLINE OFFLINE

ora....B1.lsnr application ONLINE ONLINE egapdb1

ora....db1.gsd application OFFLINE OFFLINE

ora....db1.ons application ONLINE ONLINE egapdb1

ora....db1.vip ora....t1.type ONLINE ONLINE egapdb1

ora....SM2.asm application OFFLINE OFFLINE

ora....B2.lsnr application ONLINE ONLINE egapdb2

ora....db2.gsd application OFFLINE OFFLINE

ora....db2.ons application ONLINE ONLINE egapdb2

ora....db2.vip ora....t1.type ONLINE ONLINE egapdb2

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE egapdb1

ora.oc4j ora.oc4j.type ONLINE ONLINE egapdb2

ora.ons ora.ons.type ONLINE ONLINE egapdb1

ora....ry.acfs ora....fs.type OFFLINE OFFLINE

ora.scan1.vip ora....ip.type ONLINE ONLINE egapdb1

ora.scan2.vip ora....ip.type ONLINE ONLINE egapdb2

ora.scan3.vip ora....ip.type ONLINE ONLINE egapdb2

4)srctl start instance启动实例(添加资源后DB资源是offline状态)

--检验crs能否正常启停数据库