番外：如何克隆可刷新的PDB

刷新前查看

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- --------- ---------- ----------
     2 PDB$SEED      READ ONLY  NO
     3 PDB1          MOUNTED
     4 PDB_REF       READ ONLY  NO
     5 PDB_REFAUTO   MOUNTED
SQL> alter session set container=pdb_ref;

Session altered.

SQL> select count(*) from test_ref;
select count(*) from test_ref
                     *
ERROR at line 1:
ORA-00942: table or view does not exist

?

目标库关闭PDB_REF进行手工刷新

注意：执行刷新时，必须关闭可刷新的PDB。如果尝试自动刷新时未关闭可刷新的PDB，则将刷新延迟到下一次计划。如果执行手动刷新时未关闭可刷新的PDB，则会报告错误。自动刷新模式的PDB也可以执行手工刷新。

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- --------- ---------- ----------
     4 PDB_REF       READ ONLY  NO

SQL> alter pluggable database pdb_ref close immediate;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- --------- ---------- ----------
     4 PDB_REF       MOUNTED

SQL> alter pluggable database pdb_ref refresh;

Pluggable database altered.

?

8.3 目标库刷新后查看

SQL> alter pluggable database pdb_ref open read only;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- --------- ---------- ----------
     4 PDB_REF       READ ONLY  NO

SQL> select count(*) from test_ref;

  COUNT(*)
----------
       500

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!