멀티 테넌트 컨테이너 데이터베이스에는 이러한 Oracle Flashback 기능을 사용할 수 없습니다. (CDB):

–    For Oracle Database 12c Release 1 (12.1.0.1), Flashback Data Archive (FDA) is not supported in a CDB.  For Oracle Database 12c Release 1 (12.1.0.2), this restriction is removed.

–    Flashback Transaction Query is not supported in a CDB.

–    Flashback Transaction Backout is not supported in a CDB.

 

 

SQL> conn system/oracle@pdb2

Connected.

SQL> select count(*) from flashback_transaction_query;

select count(*) from flashback_transaction_query

                     *

ERROR at line 1:

ORA-01295: DB_ID mismatch between dictionary USE_ONLINE_CATALOG and logfiles

 

Features Not Available or Restricted for a Multitenant Container Database in Oracle Database 12c Release 2 (12.2)

The following is a list of features that are not available or are restricted for a multitenant container database (CDB):

  • Flashback Transaction Query (in both local undo mode and shared undo mode)
  • Database Recovery Advisor
  • Oracle Sharding

 

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/readm/features-not-available-12-2-beta.html#GUID-F3D717CD-13DA-408B-8FE8-43CABAD21B58

 

By haisins

오라클 DBA 박용석 입니다. haisins@gmail.com 으로 문의 주세요.

답글 남기기

이메일 주소를 발행하지 않을 것입니다. 필수 항목은 *(으)로 표시합니다