Refresh PDB

1 检查源端和目标端归档模式

archive log list

2 源端创建用户并授权

create user c##refresh identified by pdb;
grant create session, create pluggable database, create any table to c##refresh container=all;
grant sysoper, resource, unlimited tablespace to c##refresh container=all;

3 目标端配置TNS

4 目标端创建DBLink

create database link DBLink名 connect to 用户 identified by 密码 using 'TNS';
create database link refresh_pdb connect to c##refresh identified by pdb using 'pdb2';

select owner, db_link, username from dba_db_links;

5 目标端创建PDB#手动刷新

create pluggable database manual from 源端数据库名@DBLink refresh mode manual;
create pluggable database manual from pdb2@refresh_pdb refresh mode manual;

6 目标端创建PDB#自动刷新

create pluggable database auto from 源端数据库名@DBLink refresh modeevery 15 minutes;
create pluggable database auto from pdb2@refresh_pdb refresh mode every 15 minutes;

select pdb_name, status, refresh_mode, refresh_interval from cdb_pdbs;
alter pluggable database auto refresh mode every 30 minutes;
select pdb_name, status, refresh_mode, refresh_interval from cdb_pdbs;

7 刷新模式转化

alter pluggable database auto refresh mode manual;

select pdb_name, status, refresh_mode, refresh_interval from cdb_pdbs;

alter pluggable database auto refresh mode every 15 minutes;

8 将数据库置于read only 模式

alter pluggable database auto open read only;

alter pluggable database manual open read only;

9 手动刷新

alter pluggable database manual close immediate;
alter pluggable database manual refresh;