GOLDEN GATE : Configuring Extract

. oraenv
PrimedFG
sqlplus / as sysdba
startup;

exit
go to golden gate home and startup manager process

cd /syed/gg_home/
./ggsci
>info all
>start mgr
>info all

Now create few tables that are part of replication
>exit


SOURCE --- UNIDIRECTIONAL REPLICATION

1) RDBMS SOFTWARE INSTALLATION== COMPLETED
2)DATABASE CREATION --COMPLETED
3)CONFIGURE GOLDENGATE INSTALLATION
4)GG MANAGER STARTED COMPLETD
5)CONFIGURE  SOURCE DATABASE FOR GG COMPLETED
6)IDENTIFY TABLES OR SCHEMA FOR REPLICATION
7) CONFIGURE EXTRACT
8)CONFIGURE GG DATAPUMP
9)START EXTATRACR AND DATAPUMP



tARAGET


1) RDBMS SOFTWARE INSTALLATION==
2)DATABASE CREATION --
3)CONFIGURE GOLDENGATE INSTALLATION
4)GG MANAGER STARTED COMPLETD
CONFIGURE  TARGET  DATABASE FOR GG
6) CONFIGURE REPLICAT
7)START REPLICAT

connect to source database
sqlplus / as sysdba
SQL>connect syed/india123
SQL>select tname from tab;

CONFIGURE EXTRACT
===============
IT HAS TO BE DONE FROM GOLDENGATE PROMPT
cd /syed/gg_home/
./ggsci
>edit  params ext1
:wq!
>edit  params ext1
extract ext1
SETENV (ORACLE_SID=prime)
USERID ggadmin,PASSWORD india123
EXTTRAIL ./dirdat/ex
TABLE syed.*;
OR
TABLE syed.mytab;
TABLE syed.mytab;
:wq!
./ggsci
>info all

>dblogin userid ggadmin, password india123
>add extract ext1, tranlog,begin now
>info all

link between trailfile and extract
>add extrail ./dirdat/ex, extract ext1, megabyte 100
>info all
START EXTRACT
>start extract ext1
>info all
>info extract ext1, detail
>

Delete Extract
In case the Extract process needs to be deleted, you can run the “DELETE EXTRACT ..” to remove the extract process. However before you can delete the processes make sure that you connect to the database to remove the process entry from the database.

ggsci>dblogin userid ggadmin, password india123
ggsci> DELETE EXTRACT ext1


===============================================================