TODO BORDEL
Config params
--Source GGSCI (edbxr3p0 as C##OGG_ADMIN@SOURCE/CDB$ROOT) 60> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EZDTA 00:00:02 00:00:04 EXTRACT RUNNING PZDTA 00:09:26 00:00:02 REPLICAT STOPPED RFBM 00:00:00 00:01:04 GGSCI (edbxr3p0 as C##OGG_ADMIN@SOURCE/CDB$ROOT) 61> view param EZDTA extract ezdta SETENV(ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1") SETENV(ORACLE_SID = "SOURCE") Exttrail ./dirdat/du UserIdAlias ogg_admin LOGALLSUPCOLS TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 128) UPDATERECORDFORMAT COMPACT SOURCECATALOG ogg1 TABLE simulapp.*; GGSCI (edbxr3p0 as C##OGG_ADMIN@SOURCE/CDB$ROOT) 62> view param PZDTA extract pzdta SETENV (ORACLE_SID='SOURCE') UserIdAlias ogg_admin RMTHOST ogg_target, MGRPORT 7909 rmttrail ./dirdat/qu passthru SOURCECATALOG ogg1 table simulapp.*; GGSCI (edbxr3p0 as C##OGG_ADMIN@SOURCE/CDB$ROOT) 63> view param RFBM replicat rfbm SETENV(ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1") SETENV(ORACLE_SID = "SOURCE") DBOPTIONS INTEGRATEDPARAMS(parallelism 4) UserIdAlias ogg1_repl discardfile ./dirrpt/RFBM.dsc, append assumetargetdefs map oggdwn1.simulapp.*, target ogg1.simulapp.*; --Destination GGSCI (edbxr3p0 as C##OGG_DWNADM@DESTINATION/CDB$ROOT) 57> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EFBM 00:00:12 00:03:35 EXTRACT STOPPED PFBM 00:00:00 00:03:06 REPLICAT RUNNING RZDTA 00:00:00 00:00:05 GGSCI (edbxr3p0 as C##OGG_DWNADM@DESTINATION/CDB$ROOT) 58> view param EFBM extract efbm SETENV(ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1") SETENV(ORACLE_SID = "DESTINATION") UserIdAlias ogg_dwnadm discardfile ./dirrpt/EFBM.dsc, Append LOGALLSUPCOLS TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 128) UPDATERECORDFORMAT COMPACT exttrail ./dirdat/fb SOURCECATALOG oggdwn1 TABLE simulapp.*; GGSCI (edbxr3p0 as C##OGG_DWNADM@DESTINATION/CDB$ROOT) 59> view param PFBM extract pfbm SETENV(ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1") SETENV(ORACLE_SID = "DESTINATION") UserIdAlias ogg_dwnadm passthru discardfile ./dirrpt/PFBM.dsc, append rmthost ogg_source, mgrport 7809 rmttrail ./dirdat/bf SOURCECATALOG oggdwn1 TABLE simulapp.*; GGSCI (edbxr3p0 as C##OGG_DWNADM@DESTINATION/CDB$ROOT) 60> view param RZDTA replicat rzdta SETENV(ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1") SETENV(ORACLE_SID = "DESTINATION") UserIdAlias ogg_dwnadm1 discardfile ./dirrpt/RZDTA.dsc, Append assumetargetdefs MAPEXCLUDE ogg1.simulapp.SYS_EXPORT_SCHEMA_01; MAP ogg1.simulapp.*, TARGET oggdwn1.simulapp.*; GGSCI (edbxr3p0 as C##OGG_DWNADM@DESTINATION/CDB$ROOT) 61>