Re: golden gate replication table

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/golden-gate-replication-table-tp8191p8192.html

I have checked doc 2349663.1 and doc 2262603.1

Could you please advise if steps are correct to create the classic replicat and move the table?

current process is shown below:

GGSCI (dware1) 1> all

 

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

 

MANAGER     RUNNING

EXTRACT     RUNNING     EXTDWH      00:00:03      00:00:07 <-------------------- integrated extrract

EXTRACT     RUNNING     PXDWN       00:00:04      00:00:08

REPLICAT    RUNNING     REPLOGGT    00:00:05      00:00:07 <------------------ integrated replicat

The following command was initially used to create the IR. Could you please advise how to proceed to create the classic replicat?

 

add replicat REPLOGGT integrated exttrail /ogg/ora12c/dirdat/cd

 

Please validate steps:

 

1. create classic replicat process

add replicat REP2 exttrail /ogg/ora12c/dirdat/cd

 

2. edit REP2 parameter file:

 

REPLICAT REPLOGGT

include ./dirprm/macro.inc

ASSUMETARGETDEFS

DDLOPTIONS REPORT

USERIDALIAS oraggext

DDL INCLUDE MAPPED &

EXCLUDE INSTR 'ALTER TABLE cbsogg.GPRS_HOME_CDRS  ADD PARTITION' &

EXCLUDE INSTR 'ALTER TABLE cbsogg.GSM_HOME_CDRS  ADD PARTITION'

REPERROR (DEFAULT, EXCEPTION)

REPERROR (DEFAULT2, ABEND)

--REPERROR (1403, DISCARD)

DDLERROR DEFAULT IGNORE

--DBOPTIONS INTEGRATEDPARAMS(PARALLELISM 4, COMMIT_SERIALIZATION FULL)

BATCHSQL BATCHESPERQUEUE 1000,BATCHTRANSOPS 100000, OPSPERBATCH 100000,OPSPERQUEUE 100000

 

MAP CBS_CORE.GPRS_HOME_CDRS,TARGET CBSOGG.GPRS_HOME_CDRS;

 

2. stop replicat(REPLOGGT), pump and extract

 

3. start extract, start pump

 

4. remove table from replicat 'REPLOGGT'

 

5. start replicats.

 
Thanks