本文共 3248 字，大约阅读时间需要 10 分钟。
???????????? Oracle GoldenGate?OGG??????????????????orcl????????ogg????????????????????????????????????
??????????????????????????????
/u01/app/ogg ???Oracle GoldenGate ?? DDL ????????????????
?? Oracle GoldenGate ???ogg????????? DDL ????????? SQL ???
grant CONNECT, RESOURCE to ogg;grant SELECT ANY DICTIONARY, SELECT ANY TABLE to ogg;grant ALTER ANY TABLE to ogg;grant FLASHBACK ANY TABLE to ogg;grant EXECUTE on DBMS_FLASHBACK to ogg;grant INSERT ANY TABLE to ogg;grant UPDATE ANY TABLE to ogg;grant DELETE ANY TABLE to ogg;grant EXECUTE on UTL_FILE to ogg;grant CREATE TABLE, CREATE SEQUENCE to ogg;grant CREATE VIEW to ogg;grant CREATE PROCEDURE to ogg;grant CREATE INDEX to ogg;grant CREATE TRIGGER to ogg;
????????? DDL ?????
# Marketer SetupSYS@ orcl > @/u01/app/ogg/marker_setup.sql# DDL SetupSYS@ orcl > @/u01/app/ogg/ddl_setup.sql# Role SetupSYS@ orcl > @/u01/app/ogg/role_setup.sql# Enable DDL ReplicationSYS@ orcl > @/u01/app/ogg/ddl_enable.sql
????????????????????
# ???? 1SYS@ orcl > @/u01/app/ogg/ddl_setup.sqlLine/pos: 126/9, PL/SQL: SQL ?????
??????????????????????????
??? DDL ????????????????????????????????
??????? archive mode??????????????
# ??????mkdir -p /u01/app/oracle/dump
?????????????
# ?????????expdp scott@orcl /orcl schemas=scott directory=/u01/app/oracle/dump dumpfile=scott_schemas_%Y%m%d.dmp# ??????impdp scott@ogg /orcl schemas=scott directory=/u01/app/oracle/dump dumpfile=scott_schemas_%Y%m%d.dmp
?? Oracle GoldenGate Manager????????????
# ?? params ??> edit params mgrport 7839> DYNAMICPORTLIST 7840-7850> AUTOSTART EXTRACT *> AUTORESTART EXTRACT *> RETRIES 5> WAITMINUTES 3> PURGEOLDEXTRACTS ./dirdat/*> usecheckpoints> minkeepdays 7> LAGREPORTHOURS 1> LAGINFOMINUTES 30> LAGCRITICALMINUTES 45
?? Extract ? Replicat ?????
# ?? Extract ????> add extract ext1, tranlog, begin now> edit param ext1> MEGABYTES 100> REPORTCOUNT EVERY 1 MINUTES> DISCARDFILE ./dirrpt/ext1.dsc> APPEND> MEGABYTES 1024> DISCARDROLLOVER AT 3:00> exttrail ./dirdat/r1,megabytes 100> include all ddl & include mapped objtype 'table' & include mapped objtype 'index'> table scott.emp_ogg; table scott.dept_ogg; table scott.dept
# ?? Replicat ????> add replicat rep1> edit param rep1> MEGABYTES 1000> REPORTCOUNT EVERY 30 MINUTES> DISCARDFILE ./dirrpt/rep1.dsc> APPEND> DISCARDROLLOVER AT 3:00> checkpointtable ogg.ggschkpt> map scott.emp_ogg, target scott.emp_ogg> map scott.dept_ogg, target scott.dept_ogg> map scott.dept, target scott.dept> start rep1
# ?? Extract> start ext1# ?? Pump> start pump1# ?? Replicat> start rep1
???????????????
# ?? Extract ??GGSCI (DSI) 5 > info all
?????????????????
/u01/app/ogg/ggserr.log ????????????????????? Oracle GoldenGate?OGG???????????????Oracle GoldenGate ????????????????????????????????????????????????? Oracle ????????????
转载地址：http://jvpfk.baihongyu.com/