My Oracle Support Banner

Flashback Data Archive Key Versions Queries Are Failing With : ora-1466 and/or ORA-8181 (Doc ID 2522314.1)

Last updated on JULY 08, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

foo1_ora_328918.trc

*** 2018-12-12 07:30:19.427
*** SESSION ID:(649.37566) 2018-12-12 07:30:19.427
*** CLIENT ID:(xxxxxxxxxxxxxxxxxxxxxxxxxxx) 2018-12-12 07:30:19.427
*** SERVICE NAME:(SERVICE_S2C_SVC) 2018-12-12 07:30:19.427
*** MODULE NAME:(program@lsvra00a0822 (TNS V1-V3)) 2018-12-12 07:30:19.427
*** CLIENT DRIVER:() 2018-12-12 07:30:19.427
*** ACTION NAME:() 2018-12-12 07:30:19.427
*** CONTAINER ID:(5) 2018-12-12 07:30:19.427

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-01466: unable to read data - table definition has changed
----- Current SQL Statement for this session (sql_id=8s13s0twjmrp5) -----
INSERT /*+ parallel (SCHEMA.TABLE_NAME,8,1) */ INTO SCHEMA.TABLE_NAME ( schema_nm , tbl_nm , ky_col_nm , ky_col_val , q_lst_updt_dttm , run_id ) SELECT /*+ parallel(8) */ repl_cdc_qu_hist.schema_nm, repl_cdc_qu_hist.tbl_nm, repl_cdc_qu_hist.prim_ky_1_col_nm, repl_cdc_qu_hist.prim_ky_1_val_num, MAX(repl_cdc_qu_hist.mode_created_dttm), 100 FROM SCHEMA.TABLE_NAME as of scn SYS_CONTEXT('Context_AI', 'SCN_VAL') repl_cdc_qu_hist WHERE repl_cdc_qu_hist.mode_created_dttm > (to_timestamp(SYS_CONTEXT('Context_AI', 'PREV_RUN_DTTM'),'YYYY/MM/DD HH24:MI:SS.FF')) AND repl_cdc_qu_hist.mode_created_dttm <= (to_timestamp(SYS_CONTEXT('Context_AI', 'READY_FOR_USE_DTTM'),'YYYY/MM/DD HH24:MI:SS.FF')) AND repl_cdc_qu_hist.schema_nm = UPPER('SRC_CORE2_DEAL') AND TRIM(repl_cdc_qu_hist.tbl_nm || repl_cdc_qu_hist.prim_ky_1_col_nm) IN ( SELECT TRIM(src_tbl_nm || src_tbl_key_col) FROM SCHEMA.TABLE_NAME ) GROUP BY repl_cdc_qu_hist.schema_nm, repl_cdc_qu_hist.tbl_nm, repl_cdc_qu_hist.prim_ky_1_col_nm, repl_cdc_qu_hist.prim_ky_1_val_num

Addition Symptoms:

ORA-01466 without ddl on table or indexes

 

CDB SMON_SCN_TIME Table

TIME_DP                TIME_MP    SCN_BAS    SCN_WRP        SCN                
------------------- ---------- ---------- ---------- ----------                
2019-05-03 14:21:44 1556893304  854685897       2952 1,2680E+13  MIN
...
2019-03-21 19:28:13 1553196493 1774765297       2948 1,2663E+13  MAX

The mapping time is in the past:  mapping time: 2183781

PDB

TIME_DP                TIME_MP    SCN_BAS    SCN_WRP        SCN                
------------------- ---------- ---------- ---------- ----------                
2019-05-03 13:59:11 1556891951  846694409       2952 1,2680E+13
...
2019-04-28 21:25:18 1556486718 3223052971       2951 1,2678E+13

NSMPRDC1_ora_5924_ORA1466.trc

ktf_fm_3: Found Mapping: <scn: 0x00000b882ea97728, mapping time: 1556880718 >
ktf_fm_3: Found Mapping: <scn: 0x00000b882ea97728, mapping time: 1556880718 >
ktf_fm_3: Found Mapping: <scn: 0x00000b88215e5348, mapping time: 1556841120 >
ktf_fm_3: Found Mapping: <scn: 0x00000b88215e5348, mapping time: 1556841120 >
ktf_fm_3: Found Mapping: <scn: 0x00000b8814ce3395, mapping time: 1556794319 >
ktf_fm_3: Found Mapping: <scn: 0x00000b8814ce3395, mapping time: 1556794319 >
ktf_fm_3: Found Mapping: <scn: 0x00000b8807824735, mapping time: 1556754720 >
ktf_fm_3: Found Mapping: <scn: 0x00000b8807824735, mapping time: 1556754720 >
ktf_fm_3: Found Mapping: <scn: 0x00003726335e5162, mapping time: 2183781 >    <<< The input time is before the mapping time starts

 

----- Error Stack Dump -----
ORA-01466: unable to read data - table definition has changed
----- Current SQL Statement for this session (sql_id=77zc25sdj6h69) -----
select count(*) From schema.table_name AS OF TIMESTAMP TO_TIMESTAMP('2019-05-03 11:52:00', 'YYYY-MM-DD HH24:MI:SS') where process_id = 190924698

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.