Berikut cara untuk men-set goldengate agar dapat mengcapture DDL operation (drop table, extend tablespace, add datafile, dll)
- disable recyclebin pada database; SQL>alter system set recyclebin=off scope=both
- Jalankan script ddl instal dari GoldenGate, yang lokasinya ada di GG_HOME; sql>@marker_setup.sql; sql>@ddl_setup.sql===>initial setup; sql>@role_setup.sql; sql>@ddl_enable.sql
- Verifikasi; sql>@marker_status.sql; sql>@ddl_setup.sql=====>initial setup
Tambahkan parameter pada EXTRACTKU, PUMPKU dan REPLICATKU
EXTRACTKU
userid gg, password gg
exttrail ./dirdat/AA
DDL INCLUDE ALL
--ddl include mapped
tracetable GG.GGS_TRACE
--DDLERROR 942 IGNORE
ddloptions addtrandata, report
TABLE GGSOURCE.*;
PUMPKU
passthru
rmthost 172.16.59.113(IP/Host Target), mgrport 7809
rmttrail ./dirdat/BB
TABLE GGSOURCE.*;
REPLICATKU
assumetargetdefs
userid gg, password gg
DDL INCLUDE ALL,EXCLUDE INSTRWORDS 'ORGANIZATION EXTERNAL', EXCLUDE INSTRWORDS 'BEGIN BACKUP', EXCLUDE INSTRWORDS 'END BACKUP'
ddloptions report
--REPERROR (DEFAULT, DISCARD)
handlecollisions
discardfile ./dirrpt/replnx.dsc, PURGE
tracetable GG.GGS_TRACE
map GGSOURCE.*, TARGET GGTARGET.*;
Tidak ada komentar:
Posting Komentar