Shulou(Shulou.com)06/01 Report--

Data Migration between oracle and oracle under GoldenGate Framework

The data from the scott user on the host updba is synchronized to scott on the host upgg.

1: the scott data on updba and upgg are the same. (can be achieved through migration)

2: install GG software and create administrative user ggm authorization on the two hosts respectively.

3: configure manager management process GGSCI > edit params mgr

Port 7809

GGSCI > info mgr

GGSCI > start mgr

GGSCI > info mgr

4: configure DML synchronization

4.1 crawl process GGSCI > add extract escott,tranlog,begin now

GGSCI > info extract escott

GGSCI > edit params escott

Extract escott

Userid ggm,password oracle

Rmthost upgg,mgrport 7809

Rmttrail. / dirdat/es * trail folder

Table scott.dept

GGSCI > add rmttrail. / dirdat/es, extract escott

GGSCI > info rmttrail. / dirdat/es

GGSCI > info extract escott,detail

4.2 configure trail (destination side) GGSCI > edit params. / GLOBALS

GGSCHEMA GGM

CHECKPOINTTABLE GGM.CKPTAB

GGSCI > dblogin userid ggm,password oracle

GGSCI > add checkpointtable ckptab

4.3replication process (destination side) GGSCI > add replicat rscott, exttrail. / dirdat/es

GGSCI > edit params rscott

Replicat rscott

Userid ggm,password oracle

Handlecollisions

Assumetargetdefs

Discardfile. / dirrpt/rscott.dsc,purge

Map scott.dept,target scott.dept

4.4 start replication (destination side) GGSCI > start replicat rscott

GGSCI > info replicat rscott

4.5 start crawling (source side) GGSCI > start extract escott

GGSCI > info extract escott

4 verify the synchronization effect

Source side: check whether there are any changes on the destination side after update\ insert commit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.