Adding the extract in the GoldenGate with thread options for RAC database

Adding the extract in the Golden Gate with thread options 

To add the extract in the golden latest version 11.2. we have to download the golden gate from the edelivery .oracle.com fusion middle ware and unzip in the appropriate  location if you are using  the RAC database unzip the contents  in the shared directory which is accessible to all the nodes

Step 1 

For golden gate there is a command prompt knows as ggsci and go to the golden gate root directory [the directory which you have unzipped the contents of the file and type ./ggsci

oraprod@db[PROD1]:$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

HP/UX, IA64, 64bit (optimized), Oracle 10g on Apr 23 2012 22:20:31

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (db) 1>

Now you will get the ggsci command prompt 

Step 2

Creating the sub directories there are may sub directories to be created as the empty directory   for  various operations of the gg

GGSCI (db) 3> create SUBDIRS

Creating subdirectories under current directory /fah/ggtest/gg

Parameter files                       /fah/ggtest/gg/dirprm: created

Report files                           /fah/ggtest/gg/dirrpt: created

Checkpoint files                    /fah/ggtest/gg/dirchk: created

Process status files                /fah/ggtest/gg/dirpcs: created

SQL script files                     /fah/ggtest/gg/dirsql: created

Database definitions files      /fah/ggtest/gg/dirdef: created

Extract data files                    /fah/ggtest/gg/dirdat: created

Temporary files                     /fah/ggtest/gg/dirtmp: created

Stdout files                            /fah/ggtest/gg/dirout: created

Step 3

exit from the ggsci command prompt and create the necessary Parameter files and add it in the dirprm directory

GGSCI (db) 3> exit

oraprod@db[PROD1]:$ cd dirprm

oraprod@db[PROD1]:$ ls

defgen.prm    jagent.prm    mgr.prm       setupini.prm  setupr.prm    trane.prm     tranp.prm     tranr.prm

Step 4

start the manager first

GGSCI (db) > start MGR

Manager started.

GGSCI (db) > info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

Step 5

Add the extract into the gg and check the extract according to the number of instance's we need to specify the thread if you have more that 2 nodes then you have to specify according to it

GGSCI (db) > ADD EXTRACT TRANE, TRANLOG, BEGIN NOW, THREADS 2

EXTRACT added.

GGSCI (db) > info *

EXTRACT    TRANE     Initialized     2012-08-26 12:13 Status STOPPED

Checkpoint Lag       00:00:00 (updated 00:00:04 ago)

Log Read Checkpoint  Oracle Redo Logs

                     2012-08-27 12:11:10  Thread 1, Seqno 0, RBA 0

                     SCN 0.0 (0)

Log Read Checkpoint  Oracle Redo Logs

                     2012-08-27 12:11:10 Thread 2, Seqno 0, RBA 0

                     SCN 0.0 (0)

EXTRACT    TRANE     Last Started 2012-08-26 12:13   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:10 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-27 13:57:41  Thread 1, Seqno 73117, RBA 97613824
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-27 13:57:41  Thread 2, Seqno 85862, RBA 82908040