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

Data Migration between oracle and oracle under GoldenGate Framework

1: make sure the database version downloads the corresponding GG software, enables the archive mode, modifies the archive file format, adds additional logs, creates the installation catalog, decompresses the software, sets variables and initializes GG, creates and authorizes the administrative user ggm. (this part of the operation can be done in accordance with the previously published installation paper)

2: configure the manager management process $GG_HOME/ggsci > edit manager mgr

Port 7809

Start mgr

Info mgr

3: prepare target users and objects set long 999

Set pagesize 99

Set heading off

Set feedback off

Spool / tmp/s1.sql rep

Select replace (dbms_metadata.get_ddl ('TABLE','DEPT'),' SCOTT','S1') | |'; 'from dual

Spool off

Ho sed'/ ^ SQL > / d'- I / tmp/s1.sql

Grant connect,resource to S1 identified by tiger

Start / tmp/s1.sql

4: increase the table level to add logs GGSCI > dblogin userid ggm@updb,password oracle

GGSCi > list tables scott.*

GGSCI > info trandata scott.dept

GGSCI > add trandata scott.dept

5: configure crawl process GGSCI > add extract eupdba,sourceistable

GGSCI > edit params eupdba

Extract eupdba

Userid ggm,password oracle

Rmthost upgg (target hostname), mgrpt 7809

Rmttask replicat,group rupgg (target application process)

Table SCOTT.DEPT

View params eupdba

6: configure the replication process (another host) GGSCI > info mgr

GGSCI > add replicat rupgg,specialrun

GGSCI > edit params rupgg

Replicat rupgg

Userid ggm,password oracle

Assumetargetdefs

Map SCOTT.DEPT,target S1.DEPT

GGSCI > view params rupgg

7: the source host starts the crawling process GGSCI > start extract eupdba

GGSCI > info extract eupdba

GGSCI > view report eupdba

8: view GGSCI > info replicat rupgg on the destination CVM

GGSCI > view report rupgg

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.