oracle_12_goldengate_zero_downtime_config [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
TODO BORDEL


<Code:bash|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> 
</Code>