Forum Stats

  • 3,851,953 Users
  • 2,264,054 Discussions
  • 7,904,915 Comments

Discussions

ORA-01295 trying to do a Flashback Transaction query on a PDB

Arturo Gutierrez
Arturo Gutierrez Member Posts: 337 Bronze Badge
edited May 23, 2018 3:22AM in Multitenant

Hello,

I've a 12.2.0.1 CDB with a PDB, and trying to do a flashback transacction query fails with this error:

ORA-01295: DB_ID mismatch between dictionary USE_ONLINE_CATALOG and logfiles

This is the test.

I do some inserts and deletes.

  SELECT versions_xid, versions_operation,VERSIONS_STARTTIME,deptno,loc FROM dept

  2* VERSIONS BETWEEN scn minvalue and maxvalue;

VERSIONS_XID     V VERSIONS_STARTTIME            DEPTNO LOC

---------------- - ------------------------- ---------- -------------

11000B00185E0000 I 23-MAY-18 01.14.23 AM             60 MADRID

140019005F2F0000 I 23-MAY-18 01.11.05 AM             50 MADRID

0D001800E05D0000 D 23-MAY-18 01.08.11 AM             50 MADRID

0F001400145E0000 I 23-MAY-18 01.01.19 AM             50 MADRID

0E001B000E5E0000 D 23-MAY-18 12.43.22 AM             50 MADRID

0B001E00375E0000 I 23-MAY-18 12.19.28 AM             50 MADRID

                                                     10 NEW YORK

                                                     20 DALLAS

                                                     30 CHICAGO

                                                     40 BOSTON

If I try:

select xid, undo_sql from flashback_transaction_query where xid='0B001E00375E0000';

This error happen.

ERROR at line 1:

ORA-01295: DB_ID mismatch between dictionary USE_ONLINE_CATALOG and logfiles.

Any idea to fix the problem?

Thanks

Arturo

Hairui Tian

Best Answer

Answers

This discussion has been closed.