使用dg将单实例oracle12c迁移升级到oracle19.22 RAC
1.基本环境说明
源端环境oracle12.2.0.1 CDB linux x86架构,地址为192.168.56.232 实例名为ora12c
目标端为oracle 19.22.0 linux x86架构,详细地址如下:
[oracle@rac19c1 admin]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
#public IP
192.168.56.191 rac19c1
192.168.56.192 rac19c2
#VIP
192.168.56.193 rac19c1-vip
192.168.56.194 rac19c2-vip
#private IP
11.11.11.1 rac19c1-priv
11.11.11.2 rac19c2-priv
#scanip
192.168.56.195 rac19c-cluster rac19c-cluster-scan
192.168.56.196 rac19c-cluster rac19c-cluster-scan
192.168.56.197 rac19c-cluster rac19c-cluster-scan
2.搭建好目标端RAC,并升级到19.22,(可以不创建实例,但是建议创建实例,防止参数有问题)
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac19c1 STABLE
ONLINE OFFLINE rac19c2 STABLE
ora.chad
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora.net1.network
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora.ons
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac19c2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac19c1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac19c1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac19c1 Started,STABLE
2 ONLINE ONLINE rac19c2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac19c1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac19c1 STABLE
ora.rac19c.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
ora.rac19c1.vip
1 ONLINE ONLINE rac19c1 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac19c2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac19c1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac19c1 STABLE
--------------------------------------------------------------------------------
版本:
[oracle@rac19c1 ~]$ sqlplus -v
SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.22.0.0.0
3.配置源端adg环境
配置好源端12c的adg环境参数,包括log_archive_dest_2 log_archive_config tnsnames.ora其中tnsnames.ora配置目标端的的静态监听
ORA12CDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.191)(PORT = 1522)) #这里是1522端口
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora12c)
(UR = A)
)
)