Cookbook – Goldengate Integrated Extract on Pluggable Database

#Export ORACLE_SID of container DATABASE, – my Container DB is “cdb01”.

[oracle@greporalab]$ export ORACLE_SID=cdb01

[oracle@greporalab]$ sqlplus / as sysdba

#Change to CONTAINER’s ROOT session.

SQL> alter session set container=CDB$ROOT;

#Create user and ADD Roles.

SQL> create user c##ggate identified by your_passowrd container=all
SQL> grant connect to c##ggate container=all;
SQL> grant dba to c##ggate container=all;
SQL> grant unlimited tablespace to c##ggate container=all;
SQL> grant create session to c##ggate container=all;
SQL> grant alter session to c##ggate container=all;
SQL> grant select any dictionary to c##ggate container=all;
SQL> alter system set enable_goldengate_replication=true scope=both;
SQL> alter database add supplemental log data;
SQL> alter database force logging;

#Change to PLUGGABLE DB Session, my Pluggable db name is plugg01.

SQL> alter session set container=plugg01;
SQL> create tablespace GOLDENGATE datafile '+DGDATA/' size 100M autoextend on;
SQL> alter user c##ggate default tablespace GOLDENGATE;

#Create Integrated EXTRACT.

[oracle@greporalab]$ cd $GGATE_HOME

[oracle@greporalab gg12c]$./ggsci

GGSCI (greporalab) 1> add extract E_INT01 INTEGRATED TRANLOG, BEGIN NOW

EXTRACT (Integrated) added.

GGSCI (greporalab) 1> edit param E_INT01

EXTRACT E_INT01

userid C##ggate password you_password

CACHEMGR CACHESIZE 5GB

exttrail ./dirdat/a1, FORMAT RELEASE 12.1

SOURCECATALOG plugg01

TABLE OWNER.TABLE_NAME;
TABLE OWNER.TABLE_NAME_1;
TABLE OWNER.TABLE_NAME_2;

GGSCI (greporalab) 1> dblogin userid C##ggate password your_password
Successfully logged into database CDB$ROOT.

GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> REGISTER EXTRACT E_INT01 DATABASE CONTAINER (plugg01)
2017-10-20 19:35:20 INFO OGG-02003 Extract E_INT01 successfully registered with database at SCN 7338138479501.

GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> add extract P_INT01 exttrailsource ./dirdat/a1
EXTRACT added.

GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> edit param P_INT01

extract P_INT01

--connection to database--
userid C##ggate password your_password

CACHEMGR CACHESIZE 1GB

rmthost greporalab02, mgrport 9809
rmttrail ./dirdat/b1

-- Tabelas
SOURCECATALOG plugg01

TABLE *.*;

GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> add rmttrail ./dirdat/b1 extract P_INT01
RMTTRAIL added.

If you need help to configure Replicat Process, send a smoke signal.

Enjoy.

One comment

  1. Man with a Van | Man and Van | UK Movers | Removal Service | London Removals | Hire Van and truck | Flat Movers | Hire Van with a Van | London Movers

    Whether you are moving or shipping furniture purchaing online, you have several options. When it comes to delivery or when you are looking van or truck with driver to delivery your furniture in UK. Just visitor web deliveryd2d.com or call us at our toll free number and get the get instant quotes.

    Removal drivers can help you move anything you need to be transported, from dishes to furniture. It does not matter if you are moving your belongings in next streets over or miles away. No household job is too small or too big. When you hire a local professional on DeliveryD2D, you can be sure that your job will get done at best price that suits you.

    Why waste time when you can find man with a van in your area at the best price you want.

    Call us on our free phone number 0800 0 119 116
    http://www.deliveryd2d.com (Delivery Door 2 Door)

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.