不同CDB之间克隆PDB

绝地灬酷狼 2022-09-09 09:55 127阅读 0赞

## 1 查看源端数据库信息 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_13_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][9f0bcb70b7b64ceea2f6068ab47e5483.png]

select userenv('language') from dual;

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

## 2 源端创建具有create session和create pluggable database权限的用户CP ##

grant create session,create pluggable database to cp;

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

grant create session,create pluggable database to cp;

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

## 3 将源端数据库置于read only 模式 ##

![在这里插入图片描述][7cd90504bf5b4cceaea4d6ae1b5b043a.png]  
![在这里插入图片描述][131a1fad803f4998bc288018981cb32f.png]  
![在这里插入图片描述][f30386ed45ba4af9836a5a250c0a32c8.png]

## 4 配置TNS ##

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

## 5 通过DBLink克隆 ##

![在这里插入图片描述][7cab0eb5b27541be92d2c6215ea4c508.png]  
![在这里插入图片描述][6281440dc4b345b8acf8fd8911b760b3.png]

## 6 克隆完成 ##

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

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

## 7 源端置于read write 模式 ##

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

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_13_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/2209e5f6a6484fe39fd1c922228588c9.png
[9f0bcb70b7b64ceea2f6068ab47e5483.png]: /images/20220829/26c32614870e4d94837825f843468924.png
[65681703b869478baec175560b8d8663.png]: /images/20220829/b587919d0cbd48db9d83dd9f15e4b3af.png
[590924263fa041d49a6ddb29d0fd4a38.png]: /images/20220829/42386fa573214ad09cd0f0b68b190e1d.png
[f9f1c2a24cc44653adf71766bf38ac67.png]: /images/20220829/6ce5451fa4ad47bf890f2df612baec4e.png
[7cd90504bf5b4cceaea4d6ae1b5b043a.png]: /images/20220829/2a350e70346f40ed9f531c815a69434a.png
[131a1fad803f4998bc288018981cb32f.png]: /images/20220829/4c0dadec788b469e985a3588c71acccf.png
[f30386ed45ba4af9836a5a250c0a32c8.png]: /images/20220829/9642da0cfcf84399b3befc743ae4616a.png
[353b217896d44948823ff8ca97372535.png]: /images/20220829/651186a63b9447209645671a637e46fb.png
[db4995a35d2f436bb2017fdfd8f48e91.png]: /images/20220829/08b99668c85d4f48adae58ee5368dfad.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/9c351af4765e427e907e28358cbaaef4.png
[7cab0eb5b27541be92d2c6215ea4c508.png]: /images/20220829/7ac3f73a7a9e494085c5be0226b4e925.png
[6281440dc4b345b8acf8fd8911b760b3.png]: /images/20220829/9c760fa0a7e74b72a777fda074c6e68d.png
[bed77055483246508ef288533c59b7bd.png]: /images/20220829/c1b3b1a885774bae805c1cae9ec992e6.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220829/c57d9fcc4f8341df99d3ea460d771b66.png
[b4f50b613c874683a8fa4e3a8845e2f8.png]: /images/20220829/aefe418d63b34b2c8ece2f203c416452.png