Passos para começar a usar o Godengate

goldengate starter

Architecture:
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.
Basic Replication:
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
Adding extract:
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
Data pump:
Passthru: to pass all without filtering
Rmthost: remote server name
Mgrport: manager port
Rmttrail: to specify two character name for remote trail file.
Replicate:
HANDLECOLLISION: to ignore if any difference between source and target tables.
ASSUMETARGETDEFS: when source and target are same.
Advanced Feature:
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
ELSE
DBLOGIN USERID GGER PASSWORD PASSWORD
ADD CHECKPOINTTABLE
INFO CHECKPINTTABLE GGER.CHKPT
Adding DDL Replication:
Sql> grant execute on utl_transfer to gger;
Sql> @marker_setup.sql
Sql> @ddl_setup.sql
Sql> @role_setup.sql
Sql> @ddl_enable.sql
Add in local extract file:
DDL INCLUDE MAPPED
Monitoring Goldengate:
Info all
Info extract ext, detail ( check for sequence number, this should be current redo log group)
Checking LAG
>LAG EXTRACT EXT
>SEND EXTRACT EXT, GETLAG
>VIEW REPORT EXT
>STATS EXTRACT EXT

Sobre Alexandre Pires

ORACLE OCS Goldengate Specialist, OCE RAC 10g R2, OCP 12C, 11g, 10g , 9i e 8i - Mais de 25 anos de experiência na área de TI. Participei de projetos na G&P alocado na TOK STOK, EDINFOR alocado na TV CIDADE "NET", 3CON Alocado no PÃO DE AÇUCAR, DISCOVER alocado na VIVO, BANCO IBI e TIVIT, SPC BRASIL, UOLDIVEO alocado no CARREFOUR e atualmente na ORACLE ACS atendendo os seguintes projetos: VIVO, CLARO, TIM, CIELO, CAIXA SEGUROS, MAPFRE, PORTO SEGURO, SULAMERICA, BRADESCO SEGUROS, BANCO BRADESCO, BASA, SANTANDER, CNJ, TSE, ELETROPAULO, EDP, SKY, NATURA, ODEBRESHT, NISSEI, SICREDI, CELEPAR, TAM, TIVIT, IBM, SMILES, CELEPAR, SERPRO,OKI,BANCO PAN, etc
Esse post foi publicado em GOLDENGATE e marcado , , , , , , , , , , , . Guardar link permanente.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s