OGG同步流程

alter database add supplemental log data ;
alter system switch logfile;
alter database force logging;

select log_mode from v$database;

./ggsci

create subdirs

cd /OGG/ogg_software/fbo_ggs_AIX_ppc_shiphome/Disk1/response

./runInstaller -silent -responseFile /OGG/ogg_software/fbo_ggs_AIX_ppc_shiphome/Disk1/response/oggcore.rsp

cd /OGG/ogg_soft
./ggsci
ggsci> create subdirs

netstat -na|grep 7809

./ggsci
ggsci> edit params mgr

port 7809
DYNAMICPORTLIST 7810-7890
purgeoldextracts ./dirdat/* ,usecheckpoints,minkeepdays 4
AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45

Start mgr

CREATE TABLESPACE ogg DATAFILE +DATA SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE 5G;

CREATE USER goldengate IDENTIFIED BY Ogg2022 DEFAULT TABLESPACE ogg;
grant connect,resource,unlimited tablespace to goldengate;
grant  CREATE SESSION, ALTER SESSION to goldengate;
grant  alter system to goldengate;
grant  SELECT on dba_clusters to goldengate;
grant  execute on utl_file to goldengate;
grant  select any dictionary to goldengate;
grant select any table to goldengate;
grant  alter any table to goldengate;
grant  flashback any table to goldengate;
grant  execute on DBMS_FLASHBACK to goldengate;
grant  EXEMPT ACCESS POLICY to goldengate;
grant select any transaction to goldengate;
grant EXP_FULL_DATABASE to goldengate;

export GG_HOME=/oraclelog/OGG/ogg/ogg_insta
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin:$GG_HOME

cd /oracle/goldengate
./ggsci

create subdirs

edit param mgr
PORT 7809
DYNAMICPORTLIST 7810-7840
PURGEOLDEXTRACTS /oraclelog/OGG/ogg/ogg_install/dirdat/tsap*, USECHECKPOINTS, MINKEEPDAYS 3
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
用户密码加密
ggsci >encrypt password Ogg#2022 encryptkey default

GGSCI> edit params exttsap1
EXTRACT EXTTSAP1
dynamicresolution
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_HOME=/oracle/app/oracle/product/19.0.0/db)
userid goldengate, password 秘钥, encryptkey default
DISCARDFILE ./dirrpt/EXTTSAP1.dsc,APPEND,MEGABYTES 1024
DBOPTIONS LOBBUFSIZE 1048576
TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance amptest1 /oraclelog, ALTARCHIVELOGDEST instance amptest2 /oraclelog
EXTTRAIL ./dirdat/ap
gettruncates
table *.*
dblogin userid goldengate, password #加密秘钥#, encryptkey default

GGSCI (ogg-test) 1>dblogin userid goldengate,password Ogg#2022
GGSCI (ogg-test) 1> add extract exttsap1, tranlog, begin now ----注明：rac数据库需要加[threads 2]
GGSCI (ogg-test) 1> add exttrail ./dirdat/ap, extract exttsap1, megabytes 200

edit params dptsap1
EXTRACT dptsap1
PASSTHRU
SETENV (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
RMTHOST 134.176.15.135, MGRPORT 7809
RMTTRAIL /oradata/ogg/dirdat/ap
table *.*

GGSCI>add extract dptsap1, exttrailsource ./dirdat/ap

GGSCI>add rmttrail ./dirdat/ap, extract dptsap1, megabytes 200
start dptsap1

GGSCI> edit params retsap1
replicat retsap1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid goldengate, password 秘钥, encryptkey default
--sourcedefs ./dirdef/retsap1.def
reperror default,discard
discardfile ./dirrpt/retsap1.dsc,append,megabytes 1024
gettruncates
handlecollisions
dynamicresolution
map *.*, target *.*; --------注：*.* 属主.表名

GGSCI>DBLOGIN USERID goldengate, PASSWORD Ogg#2022
GGSCI>add checkpointtable goldengate.checkpoint
GGSCI>add replicat retsap1, exttrail ./dirdat/ap,checkpointtable goldengate.checkpoint

alter retsap1 extseqno 1, extrba 0
start retsap1, aftercsn XXXXXXXX