Oracle to Oracle Replication - Scenario 1 (No Data pump)

 

Replication Scenario 1

• Replication Type          : Uni-Directional (Reporting)
  
• Replicat                          : Non-integrated (Classic)
• Datapump                      :  No Datapump used
• USERIDALIAS used      : No
  
• Trail File Encrypted     : No
• Extract                             : Classic
  

 

Setup Extract Process Group

·       Extract Parameter file:

EXTRACT ext02

Userid ogg, password oracle

RMTHOST localhost, MGRPORT 7809

RMTTRAIL ./dirdat/ex

TABLE src.*;

 

·       Add Extract Group

GGSCI > ADD Extract ext02, TRANLOG, BEGIN NOW

·       Add the Remote trail file

GGSCI > ADD RMTTRAIL ./dirdat/ex. EXTRACT ext02

 

Setup Replicat Process Group

·       Replicat Parameter files

REPLICAT rct02

Userid ogg, password oracle

MAP src.*, TARGET trg.*;

 

·       Add Replicat group

GGSCI > ADD replicat rct02, EXTTRAIL ./dirdat/ex , CHECKPOINTTABLE ogg.cjkpt, BEGIN NOW

** EXTTRAIL should be the trail file location on the target server.

·       Start Extract and Replicat Process

GGSCI > start extract ext02

GGSCI > start replicat rct02