Question: I notice that GoldenGate
uses data pump to replicate data. Is this the esame
data pump that does export (expdp) and import(impdp).
Answer: No, when Oracle acquired GoldenGate,
they inherited the utility named data pump, and oracle now
has two distinct tools called data pump:
Data Pump export/import: This
is a command-line utility used to backup individual tables
and schemas into flat files and import from flat files.
Goldengate Data Pump extract:
This is a process in Goldengate that takes
and applies archived redo logs to a remote database.
So there we
have it, two separate and distinct utilities named Data
Pump.
Configure Data Pump for
GoldenGate tips
To avoid the primary extract
failure in case of network disconnections, the secondary
group epmp02 is
configured. The data pump extract routes the data to the
target system leaving the primary extract dedicated to
perform change data capture only. The data pump uses the
parameter passthru
to send data as is, unaltered.
rmttrail identifies the remote trail name followed by
the list of tables.
From within GGSCI
command-line prepare parameter file
epmp02.prm, it's
saved on the default location of ./dirprm/ directory.
GGSCI (ggs-source) 1> EDIT PARAMS
epmp02
EXTRACT EPMP02
USERID ggs_admin@S1E2, PASSWORD oracle
PASSTHRU
RMTHOST ggs-target, MGRPORT 7812
RMTTRAIL ./dirdat/tb
TABLE osm$repapi.policy_types;
TABLE osm$repapi.discount_types;
TABLE osm$repapi.customers;
TABLE osm$repapi.policies;
Create
the secondary group in GoldenGate
The
add extract command creates the secondary group. The data pump
extract epmp02
reads the local trail file identified by the option
exttrailsource.
GGSCI (ggs-source) 2> ADD EXTRACT
epmp02, EXTTRAILSOURCE ./dirdat/sb
EXTRACT added.
GGSCI (ggs-source) 3> ADD RMTTRAIL ./dirdat/tb,
EXTRACT epmp02, MEGABYTES 128
RMTTRAIL added.
Starting
the secondary extract in GoldenGate
Upon successful startup of
the data pump group, local trail transaction are shipped
over TCP/IP to the designated server by
rmtrail and
manager port, mgrport.
GGSCI (ggs-source) 9> START EXTRACT
epmp02
Sending START request to MANAGER ...
EXTRACT EPMP02 starting
Before proceeding to
configure the change data delivery group, we verify the data
pump status is running,
remote trail is created, and remote trail files are
receiving transactional data. In case of errors, we correct
the cause of the error and re-attempt restarting the
database pump.
GGSCI (ggs-source) 10> INFO EXTRACT
epmp02
EXTRACT
EPMP02
Last Started 2015-10-30 19:14
Status RUNNING
Checkpoint Lag
00:00:00 (updated 00:00:05 ago)
Process ID
24022
Log Read Checkpoint
File ./dirdat/sb000000
First Record
RBA 0
