Goldengate – Initial Load

Goldengate Replication – Oracle To Oracle

On existing installed goldengate replication structure;
Re-refresh of table with dblink.

#Source
FGPRO3

#Target
goldenfg01

#Target 
#Abended process and can not resolved problem
info BCK03A01 
REPLICAT ABENDED BCK03A01 01:53:37 02:05:17

#Target
GGSCI (goldenfg01) 41> VIEW PARAM BCK03A01
MAP POST_BILL.XX_STATUS, TARGET FGPRO3_POST_BILL.XX_STATUS; Size 246 MB

#Target
#Dblink to source is discovered
select * from dba_db_links where host like '%FG%' AND OWNER='FG_MAINTAIN';

#Target
#Current scn is find out with dblink
select CURRENT_SCN from v$database@FGPRO3;
--16104375781003

#Target
#Source table is backuped and truncate source table
create table FGPRO3_POST_BILL.XX_STATUS_ydk as select /*+parallel(32)*/ * from FGPRO3_POST_BILL.XX_STATUS;
truncate table FGPRO3_POST_BILL.XX_STATUS;

#Target
#Initial load is completed with selected scn from source database
insert into FGPRO3_POST_BILL.XX_STATUS
select /*+parallel(32)*/ * from POST_BILL.XX_STATUS@FGPRO3 as of scn 16104375781003;
commit;

#Target
#Replicat trail path is discovered.
GGSCI (goldenfg01) > view param BCK03A01
--ADD REPLICAT BCK03A01 EXTTRAIL /ggatea02/FGPRO3_122c/k3 CHECKPOINTTABLE GGS_ADMIN.GGSCHKPT

#Target
#Trails is listed on replicat trail path .
GGSCI (goldenfg01) > shell ls -lrt /ggatea02/FGPRO3_122c/k3*
-rw-r----- 1 ggate oinstall 599999849 May 2 16:38 /ggatea02/FGPRO3_122c/k3000017479
-rw-r----- 1 ggate oinstall 599999680 May 2 17:12 /ggatea02/FGPRO3_122c/k3000017480

#Target
#Replicat sequence and rba are set for first sequence
GGSCI (goldenfg01) > alter BCK03A01 extseqno 17479 extrba 0 
GGSCI (goldenfg01) > start replicat BCK03A01 aftercsn 16104375781003

#Target
#Replicat status is observed.
info all
stats BCK03A01
send BCK03A01 status

Fatih Gençali

- I have supported as Oracle Dba for more than 5.5 years. - I worked in 24x7 production and test environment. - I have 12C OCP certificate. - I have europass diploma supplement. - Saving operations - I have supported databases that are telecommunication , banking, insurance, financial, retail and manufacturing, marketing, e-invoicing . - Providing aligment between prod , prp , stb , dev - Providing management and performance tuning for app and database machines (linux) - Performance tuning and sql tuning - Consolidations, Migration , installation, patch , upgrade , dataguard , shell script writing , backup restore , exadata management , performans management , security management ,goldengate operations - Resolving performance and security problems for databases and linux machines - I managed oracle 10g/11g/12c databases (dev/test/prp/snap/prod/stby) on Linux/HP/AIX/Solaris O.S - Pl/sql operations , supported shell script, (for aligments and others) - Providing highly available it (software-hardware) systems, especially database systems. - Managing and monitoring availabilities and operations of all systems . - Goldengate operations (oracle to oracle , oracle to bigdata (hdfs , kafka)) - Exadata operations (cell management,upgrade,switchover) - My work processes is according to itil. - Preparing automation for everything to reduce human resource requirement and routine works.