CDC not capturing changed data from the source tables
edited Jun 18, 2012 2:36AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
After drop and impdp in source database, CDC configuration appears to be ok, but changed data is not in change tables.
This is what we have done:
- CDC is working fine and change data is captured
- drop user in source database
- impdp schema in source database
- create unconditional log group on source tables (alter table TAB1 add supplemental log data (all) columns)
- rebuild data dictionary in source database and get the SCN (first_scn)
- prepare source tables (dbms_capture_adm.prepare_table_instantiation (table_name => 'OWN1.TAB1');
- reinstantiate SCN in target databse (DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN(source_object_name=> 'OWN1.TAB1',source_database_name=>'DBNAME1',instantiation_SCN=>first_scn);)
This is what we have done:
- CDC is working fine and change data is captured
- drop user in source database
- impdp schema in source database
- create unconditional log group on source tables (alter table TAB1 add supplemental log data (all) columns)
- rebuild data dictionary in source database and get the SCN (first_scn)
- prepare source tables (dbms_capture_adm.prepare_table_instantiation (table_name => 'OWN1.TAB1');
- reinstantiate SCN in target databse (DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN(source_object_name=> 'OWN1.TAB1',source_database_name=>'DBNAME1',instantiation_SCN=>first_scn);)
0