Extract: Captures changes and write in ST.
Source Trail file: Data Captured and written.
Data Pump: It is also extract, that read ST and send over the network.
Collector: Receive the ST and writes as RT (Remote Trail).
Delivery: To apply changes, started as background process by Replicate.
Manager: Manages all, default port is 7840.
Defgen: Use to generate the DDL.
Logdump: use to read the trail file.
Reverse: use to reverse the changes applied.
Veridata: Tool to compare source and target.
Director: Graphical tool to manage Golden-Gate.
Enable Supplement Loging:
alter database add supplemental log data;
Enable table level supplemental loging at table level:
ggsci> add trandata hr.employees
check from dba_log_group.
Disable trigger and cascade constraint at target system:
select ‘alter table’ || owner || ‘.’ || table_name || ‘disable constraint ‘ || constraint_name || ‘;’
from dba_constraint where delete_rule=’CASCADE’ and owner=’HR’;
select ‘alter trigger ‘||owner||’.’||trigger_name|| ‘ disable ;’
from all_triggers where owner = ‘&SCHEMA’;
Same query can be used to enable later !!!
NOTE: from version 11, SUPPRESSTRIGGER & DEFERREFCONST can be use with DBOPTION in Replicate parameter.
Info manager : information for manager
Start manager : to start manager
ggsci> add extract ext, tranlog, begin now
ggsci> add extrail disdat/L1, extract ext, megabytes 100
stop extract ext
start extract ext
info extract ext
info extract ext, detail
stat extract ext
Passthru: to pass all without filtering
Rmthost: remote server name
Mgrport: manager port
Rmttrail: to specify two character name for remote trail file.
HANDLECOLLISION: to ignore if any difference between source and target tables.
ASSUMETARGETDEFS: when source and target are same.
Report: Extract and Replicate DML runtime statistics.
SEND EXTRACT EXT REPORT
SEND EXTRACT REP REPORT
Reportcount: To count DML GG Proccsed since startup. Can be used in EXTRACT AND REPLICATE parameter.
Reportrollover: TO control report file over time.
DISCARDEFILE: To record discard.
Discardfile disdat/ext1.dsc append
Discardrollover at 12:00 ON SUNDAY.
Purging old trail file: (PURGEOLDEXTRACTS), can be used to purge old trail files..
PURGEOLDEXTRACTS DIRDAT/*, USECHECKPOINTS, MINKEEP 2 DAYS
Autostart: can be add in manager paremeter, for auto start.
Checkpoint Table: By default GG maintains checkpoint file on disk to tract the transaction processing. Best practice is to add checkpoint table in target database.
Add in global parameter:
CHECKPOINT TABLE GGES..CHKPT
DBLOGIN USERID GGER PASSWORD PASSWORD
INFO CHECKPINTTABLE GGER.CHKPT
Adding DDL Replication:
Sql> grant execute on utl_transfer to gger;
Add in local extract file:
DDL INCLUDE MAPPED
Info extract ext, detail ( check for sequence number, this should be current redo log group)
>LAG EXTRACT EXT
>SEND EXTRACT EXT, GETLAG
>VIEW REPORT EXT
>STATS EXTRACT EXT