DOC Id - 1276058.1 - Instantiation from an Oracle Source Database - expdp?
Source DB -
OGG Version 19c, Oracle DB version 12.1
Target DB -
OGG Version 19c, Oracle DB version 19c
With this new method of instantiation using expdp, should the expdp parameter take a
option 1 :- consistent backup with FLASHBACK_TIME="TO_TIMESTAMP('27-10-2022 13:16:00', 'DD-MM-YYYY HH24:MI:SS')" or FLASHBACK_SCN=XXXXXX or CONSISTENT=Y
option 2- No need of consistent backup.
For option 1: Should the replicat use the handlecollision and/or insertmissingupdates?
For option 2: Should the replicat use the handlecollision and/or insertmissingupdates?
The document says - Replicat will handle it automatically when the Replicat Parameter DBOPTIONS ENABLE_INSTANTIATION_FILTERING is enabled. It also eliminates the need of specification of individual MAP for each imported table with the @FILTER(@GETENV(‘TRANSACTION’,‘CSN’) or HANDLCOLLISIONS clause .