Refresh PDB

谁借莪１个温暖的怀抱￠ 2022-09-09 10:54 278阅读 0赞

## 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 ##

![在这里插入图片描述][353b217896d44948823ff8ca97372535.png]  
![在这里插入图片描述][db4995a35d2f436bb2017fdfd8f48e91.png]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]

## 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;

![在这里插入图片描述][afc97618298e43c49eee378fea89c6ae.png]

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

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

![在这里插入图片描述][484b902498154991be19f3076f9e5043.png]

## 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;

![在这里插入图片描述][1699979c2b534ea9b74aef07a32bdacf.png]

## 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;

![在这里插入图片描述][b187aa75de85434096e999f735386c88.png]

![在这里插入图片描述][b9961327a5cc4635ba30dcf903197846.png]

## 8 将数据库置于read only 模式 ##

alter pluggable database auto open read only;
    
    alter pluggable database manual open read only;

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_13_color_FFFFFF_t_70_g_se_x_16]

## 9 手动刷新 ##

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

[353b217896d44948823ff8ca97372535.png]: /images/20220829/833715815b8b4da5b2160007c85a1533.png
[db4995a35d2f436bb2017fdfd8f48e91.png]: /images/20220829/4e995ca720dd4ca9907cceccfe0e1621.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/f3c08708dbf84b119736b40ab361190b.png
[afc97618298e43c49eee378fea89c6ae.png]: /images/20220829/a309fe4dae2547e7b2dba96461a1f22f.png
[484b902498154991be19f3076f9e5043.png]: /images/20220829/e4871c65e3c8441494d596c44bd3fc71.png
[1699979c2b534ea9b74aef07a32bdacf.png]: /images/20220829/44f9ea1ffab846949ca187b36bc4cbcc.png
[b187aa75de85434096e999f735386c88.png]: /images/20220829/285eb1599e13429381766b4761c9af3c.png
[b9961327a5cc4635ba30dcf903197846.png]: /images/20220829/90fe9be0a80841a0a225ab54ded87d9e.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_13_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/aa16f9ea81c14f0faa278be84d4539f1.png