TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
1.环境介绍
源端单机12c non_cdb,目标RAC 19c pdb,使用持续刷新模式克隆源端nocdb到目标端pdb,目标库pdb自动或者手动刷新,当源库时间窗口内read only,目标数据库pdb结束刷新,升级数据字典,运行nocdb_to_pdb.sql,确认组件全部正常后打开,迁移完毕。
2.实施条件
前提条件太多,这里不详细表述,反正都满足。
建立目标库到源库的dblink,在cdb层
- create database link source12 connect to system identified by oracle using '192.168.56.101:1521/orcl';
复制代码
3.开始克隆
使用自动刷新模式克隆远端nocdb到目标端pdb
- SQL> CREATE PLUGGABLE DATABASE pdb2 from non$cdb@source12 REFRESH MODE EVERY 6 minutes;
- Pluggable database created.
- SQL> show pdbs;
- CON_ID CON_NAME OPEN MODE RESTRICTED
- ---------- ------------------------------ ---------- ----------
- 2 PDB$SEED READ ONLY NO
- 3 PDB1 MOUNTED
- 4 PDB2 MOUNTED
复制代码
4.目标库刷新
虽然是地洞刷新,也可手动刷新玩玩,原理是在目标端开了闪回区,把源端的归档拽过来做介质恢复
- SQL> alter pluggable database pdb2 refresh;
- Pluggable database altered.
- SQL> alter pluggable database pdb2 refresh;
- Pluggable database altered.
复制代码
5.源库read only
到了维护窗口了,停业务吧,源库只读啦
- SQL> startup mount
- ORACLE instance started.
- Total System Global Area 2516582400 bytes
- Fixed Size 8623832 bytes
- Variable Size 671090984 bytes
- Database Buffers 1828716544 bytes
- Redo Buffers 8151040 bytes
- Database mounted.
- SQL> alter database open read only;
- Database altered.
- SQL> select count(*) from t;
- COUNT(*)
- ----------
- 84
复制代码
6.关闭刷新
源库只读后,目标库再刷新几次,然后关闭刷新
- SQL> alter pluggable database pdb2 REFRESH MODE NONE;
- Pluggable database altered.
复制代码
7.升级pdb
这个pdb2一直是mount状态,现在需要升级到19c的数据字典了
- [oracle@zy1 ~]$ dbupgrade -c pdb2
复制代码
8.nocdb_to_pdb.sql
切换到pdb2,执行如下脚本
- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql
复制代码
9.确认组件
检查一下组件是否都是正常的
- SQL> show pdbs;
- CON_ID CON_NAME OPEN MODE RESTRICTED
- ---------- ------------------------------ ---------- ----------
- 2 PDB$SEED READ ONLY NO
- 3 PDB1 MOUNTED
- 5 PDB2 MOUNTED
- SQL> alter pluggable database pdb2 open;
- Pluggable database altered.
- SQL> select comp_name,status,version from dba_server_registry;
- Oracle Database Catalog Views VALID 19.0.0.0.0
- Oracle Database Packages and Types VALID 19.0.0.0.0
- Oracle Real Application Clusters VALID 19.0.0.0.0
- JServer JAVA Virtual Machine VALID 19.0.0.0.0
- Oracle XDK VALID 19.0.0.0.0
- Oracle Database Java Packages VALID 19.0.0.0.0
- OLAP Analytic Workspace VALID 19.0.0.0.0
- Oracle XML Database VALID 19.0.0.0.0
- Oracle Workspace Manager VALID 19.0.0.0.0
- Oracle Text VALID 19.0.0.0.0
- Oracle Multimedia VALID 19.0.0.0.0
- Spatial VALID 19.0.0.0.0
- Oracle OLAP API VALID 19.0.0.0.0
- Oracle Label Security VALID 19.0.0.0.0
- Oracle Database Vault VALID 19.0.0.0.0
复制代码
10.确认数据
- [oracle@zy1 ~]$ sqlplus sys/oracle@192.168.56.81:1521/pdb2 as sysdba
- SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 3 10:40:11 2021
- Version 19.12.0.0.0
- Copyright (c) 1982, 2021, Oracle. All rights reserved.
- Connected to:
- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
- Version 19.12.0.0.0
- SQL> desc t
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- T DATE
- SQL> select count(*) from t;
- COUNT(*)
- ----------
- 84
复制代码
|
|