本文共 1562 字,大约阅读时间需要 5 分钟。
[无解] Oracle 12c 可插拔数据库中遭遇 ORA-01295
今天在Oracle 12c Pluggable Database环境中,准备 Flashback Transaction Query 案例时,遇到了 ORA-01295的错误。
SQL> SELECT versions_xid XID, versions_startscn START_SCN, 2 versions_endscn END_SCN, versions_operation OPERATION, 3 empname, salary 4 FROM emp 5 VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE 6 WHERE empno = 111;XID START_SCN END_SCN OP EMPNAME SALARY---------------- ---------- ---------- -- -------------------------------- ----------0700170051040000 3913350 D Mike 555 3913350 Mike 555SQL> SELECT xid, start_scn, commit_scn, operation, logon_user, undo_sql 2 FROM flashback_transaction_query 3 WHERE xid = HEXTORAW('0700170051040000');WHERE xid = HEXTORAW('0700170051040000') *第 3 行出现错误:ORA-01295: 字典 USE_ONLINE_CATALOG 和日志文件之间的 DB_ID 不匹配
查询了很久,如何解决这个问题。因为在之前的版本上,这个问题很容易解决;但是Oracle 12c 的Pluggable数据库中怎么都解决不了。
最后终于发现问题所在,发帖“纪念”一下,我用掉的2个多小时时间。
参考Oracle官方文档:
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
Audit Vault Redo Collector
需要好好读读最新版的文档:
Oracle Database Readme 12c Release 2(12.2)_E85881-02(August 2018)
转载地址:http://jytdi.baihongyu.com/