Also called as active to active configuration Source will send the changes to target Both the sites are actively doing transactions and sending changes to each other There are several configuration need to take consideration while create active active configuration. EG. Conflict Detetion and resolution: Conflict Resolution: Resolveconflict Built in Methods: Sequence Considerations: Truncate considerations: ================================= Setup: edit param BE_SCOTT EXTRACT BE_SCOTT SETENV (ORACLE_HOME = "/u008/app/oracle/product/19.3.0/dbsoft") SETENV (ORACLE_SID = "SRC") useridalias boggsource TRANLOGOPTIONS EXCLUDEUSER OGG_CLASS --logallsupcols supports IR and conflict resolution feature LOGALLSUPCOLS --GETUPDATEBEFORES TRANLOGOPTIONS integratedparams (max_sga_size 200, parallelism 2) GETTRUNCATES --ENCRYPTTRAIL AES192 exttrail ./dirdat/bl TABLE BSCOTT.*,GETBEFORECOLS (ON UPDATE ALL,ON DELETE ALL); --- add extract BE_SCOTT, integrated TRANLOG , begin now...
Source RAC3 HOST / db ora_pmon_SRC / 19c DB & GG /SCHEMA HR / load1 Target RAC 4 HOST/ db ora_pmon_TRGT/ 19c DB & GG / SCHEMA HR /load2 You can use Oracle GoldenGate to: 1.Perform a standalone batch load to populate database tables for migration or other purposes. 2.Load data into database tables as part of an initial synchronisation run in preparation for change synchronisation with Oracle GoldenGate. Prerequisites for Initial Load Disable DDL Processing Before executing an initial load, disable DDL extraction and replication. DDL processing is controlled by the DDL parameter in the Extract and Replicat parameter files. Prepare the Target Tables The following are suggestions that can make the load go faster and help you to avoid errors. Data: Make certain that the target tables are empty. Otherwise, there may be duplicate-row errors or conflicts between existing rows and rows that are being loaded. Constraints: Disable foreign-key constraints and check cons...