Jayesh Pande

 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...