CONFIGURING EXTRACT ON SOUCE

1)RDBMS INSTALLATION
2)DATABASE CREATION
3)GG INSTALATION
4)GG MANAGER CONFIGURATION ON SOURCE
5)CONFIGURE SOUCRCE DATABASE FOR GOLDEN GATE CONFIGURATION
6)IDENTIFY THE TABLES OR SCHEMA FOR REPLICATION
6)CONFIGURE EXTRACT ON SOURCE DATABASE
7)CONFIGURE GG DATA PUMP
8)START EXTRACT AND DATAPUMP



TARGET
========

1)RDBMS INSTALLATION
2)DATABASE CREATION
3)GG INSTALATION
4)GG MANAGER CONFIGURATION ON SOURCE
5)CONFIGURE SOUCRCE DATABASE FOR GOLDEN GATE CONFIGURATION

6)CONFIGURE REPLICAT
7) START REPLICAT

CONNECT TO SOURCE DATABASE


CREATE EXTARCT PROCESS PARAMATERFILE
GGSCI (PrimeDG) 4> edit params ext
:wq
extract ext1
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
SETENV (ORACLE_SID=PrimeDG)
USERID ggadmin, PASSWORD india123
EXTTRAIL ./dirdat/ex
TABLE syed.*;

>info all


ADD EXTRACT
GGSCI (PrimeDG) 5> dblogin userid ggadmin password india123
Successfully logged into database.

GGSCI (PrimeDG) 6> add extract ext1, tranlog, begin now
EXTRACT added.


GGSCI (PrimeDG) 7> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     EXT1        00:00:00      00:00:04


l
NOW LINK BETWEEN TRAIL FIAL AND EXTRACT

GGSCI (PrimeDG) 8> add exttrail ./dirdat/ex, extract ext1, megabytes 100
EXTTRAIL added.


GGSCI (PrimeDG) 9> start extract ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (PrimeDG) 10> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT1        00:01:03      00:00:00


GGSCI (PrimeDG) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT1        00:00:00      00:00:07


GGSCI (PrimeDG) 12> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT1        00:00:00      00:00:00


GGSCI (PrimeDG) 13> info extract ext1, detail

EXTRACT    EXT1      Last Started 2016-04-11 23:40   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2016-04-11 23:40:54  Seqno 76, RBA 9281024
                     SCN 0.1708623 (1708623)

  Target Extract Trails:

  Remote Trail Name                                Seqno        RBA     Max MB

  ./dirdat/ex                                          0       1023        100

  Extract Source                          Begin             End

  /u01/app/oracle/PrimeDG/redo01.log      2016-04-11 23:39  2016-04-11 23:40
  Not Available                           * Initialized *   2016-04-11 23:39


Current directory    /syed/gg_home

Report file          /syed/gg_home/dirrpt/EXT1.rpt
Parameter file       /syed/gg_home/dirprm/ext1.prm
Checkpoint file      /syed/gg_home/dirchk/EXT1.cpe
Process file         /syed/gg_home/dirpcs/EXT1.pce
Stdout file          /syed/gg_home/dirout/EXT1.out
Error log            /syed/gg_home/ggserr.log


GGSCI (PrimeDG) 14> shell ls -l ./dirdat/

total 4
-rw-rw-rw- 1 oracle oinstall 1023 Apr 11 23:40 ex000000