oracleoggreplicate参数

oracleoggreplicate参数
1、选择可用的源和目标数据库
Oracle GoldenGate replicates data between two databases, a source database and a target database. The source database is usually a production database. The target database could be another production database, a reporting database, or simply a duplicate of the source database.
2、源库及目标端的提取复制参数
SOURCEDBEXTRACTPARAMETERS
•G oldenGate Extract name
•E xtract file format (normal or binary)
•N umber of extract threads
•D ML Handler process on source systems
•C heckpoint table name
•C heckpoint Interval
•D iscard file directory
•D iscard file name
•E nabling Table level filtering
TARGETDBREPLICATPARAMETERS
•G oldenGate Replicat name
•R eplicat file format (normal or binary)
•N umber of replicat threads
•R eplicat discard file directory
•R eplicat discard file name
•E nabling Table level filtering
•D atabase roles
•R eplicate load options
•M ap parameters
•E asily enabling conflict resolution
3、OGG抽取复制管理参数
GGSCIPARAMETERS:
•G oldenGate home path
•E nable process parameters
•V iew and edit parameter files
•C heckpoint Interval
•C heckpoint table name
•N umber of threads (extract and replicat)
•E nable, start, stop and view extract and replicat •C onfigure replicat and extract parameters
•D efine, view and delete GoldenGate trails
•V iew and delete GoldenGate report files
•V iew and delete GoldenGate discard files
•V iew transactions reports
•V iew GoldenGate lag report
•A dd, view and delete GoldenGate Extract or Replicat files •G enerate and view GoldenGate statistics
•C reate, view and delete GoldenGate checkpoints
•C heck and view GoldenGate Tasks
•C heck trails view and delete them。