Hello,
I'm curious why ORA-26786 and ORA-26787 still occur in unidirectional streams replication. As there's no update in destination database, in theory (AFAIK) this couldn't be happen. This is schema replication.
Oracle DB version: 11gR2
1st DB configuration (master):
SUPPLEMENTAL_LOG_DATA_MIN : YES
SUPPLEMENTAL_LOG_DATA_PK : YES
SUPPLEMENTAL_LOG_DATA_UI : YES
SUPPLEMENTAL_LOG_DATA_FK : YES
SUPPLEMENTAL_LOG_DATA_ALL : YES
SUPPLEMENTAL_LOG_DATA_PL : NO
FORCE_LOGGING : YES
2nd DB configuration (destination):
SUPPLEMENTAL_LOG_DATA_MIN : NO
SUPPLEMENTAL_LOG_DATA_PK : NO
SUPPLEMENTAL_LOG_DATA_UI : NO
SUPPLEMENTAL_LOG_DATA_FK : NO
SUPPLEMENTAL_LOG_DATA_ALL : NO
SUPPLEMENTAL_LOG_DATA_PL : NO
FORCE_LOGGING : YES
Adjusted APPLY parameter:
allow_duplicate_rows : y
disable_on_error : n
I use datapump exp imp to move entire schema:
expdp SYSTEM directory=TMP_EXPORT_DIR schemas="SCHEMA1,SCHEMA2" parallel=4 dumpfile=SCHEMA_%u.dmp logfile=SCHEMA.log
impdp SYSTEM directory=TMP_EXPORT_DIR full=y parallel=4 table_exists_action=truncate dumpfile=SCHEMA_%u.dmp logfile=SCHEMA.implog
The expdp was run when database is operating. But this shouldn't be a problem since all changes while exporting and importing the data will be propagated to destination DB.
Here's example of APPLY errors (there's a lot of them):
"ORA-26786: A row with key ("CDDATE") = (2015-10-05:00:00:00) exists but has conflicting column(s) "JOBSASSGND", "RTEASSIGN", "TOTTECHS" in table SCHEMA1.CDWCATALOG
ORA-01403: no data found
"
"ORA-26787: The row with key ("SERVICE_GROUP_OBSOLETE", "LEDGER_SEQ", "TRANS_HDR_SEQ", "CUST_ACCT") = (0, 811922323, 134869403, 10366659) does not exist in table SCHEMA1.CUST_LEDGER_HEADER
ORA-01403: no data found
"
Need your advice please.
Thanks,
Yusata