重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 12c 在cdb级别开启闪回，pdb是否受影响？ [打印本页]

作者: miss_puff 时间: 2017-12-21 15:22
标题: oracle 12c 在cdb级别开启闪回，pdb是否受影响？
以下实验测试在cdb级别开启数据库闪回，pdb级别是否也会开启？
SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> select  FLASHBACK_ON  from v$database;

FLASHBACK_ON
------------------------------------
YES

SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDB1PDB                   MOUNTED
SQL> alter pluggable database racdb1pdb open;

Pluggable database altered.

SQL> alter session set container=racdb1pdb;

Session altered.

SQL> select  FLASHBACK_ON  from v$database;

FLASHBACK_ON
------------------------------------
YES

SQL>

总结：在cdb级别开启数据库闪回，pdb级别也会开启。

作者: 郑全 时间: 2017-12-22 11:46
那如果在pdb级别,是否可以只关闭某个pdb的闪回呢

作者: miss_puff 时间: 2017-12-22 11:56
经测试，在pdb级别开启或者关闭闪回将提示如下错误：

SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDB1PDB                   READ WRITE NO
SQL> alter session set container=racdb1pdb;

Session altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------------------------
YES

SQL> alter database flashback off;
alter database flashback off
*
ERROR at line 1:
ORA-03001: unimplemented feature

SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDB1PDB                   READ WRITE NO
SQL> alter session set container=racdb1pdb;

Session altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------------------------
NO
SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      3 RACDB1PDB                   READ WRITE NO
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-03001: unimplemented feature

SQL>

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)