Subscriber Count

    448

Subscribe2

Pages

Contact for Online learnings
* indicates required field
Thanks for the inquiry. You will be receiving a mail shortly with course details. If not please check the spam folder once and mark our mail as not a spam.

Example 18: Start, Stop, Report , Altering Replicat – Repositioning etc.

As like extract altering, you can also alter the replicat process to reposition to start over replication process from a trail file, Along with reposition with specific Extseqno , you can also reposition to specific date and time especially useful when you regenerate extract trail files or replication abended for some reasons.

Start Stop Replicat

start replicat rep3

stop replicat rep3

stop replicat r*

start replicat r*

starting and stopping replicat process

stop/start replicat process or group that start with r*

Kill Replicat kill replicat rep3 Kill the replicat process when the stop command does not respond
Lag Replicate lag replicat rep3 Shows how much lag replicat is from the extract.
From paritcular extract sequence
ALTER REPLICAT rep3, EXTSEQNO 53
Useful when you know which sequence the replicat stop and restart from that point
From particular RBA address
ALTER REPLICAT rep3, EXTRBA 0
ALTER REPLICAT rep3, EXTRBA 1001

Useful when the extrail is available and you want to read from particular place to avoid duplicacy of data

0 - means from header

n - means from particular that point.

From Particular date
ALTER REPLICAT rep3, BEGIN 2011-01-07 08:00:00
Reads and start replicate from particular date and time
Unregister Unregister replicat rep3  Rather delete if you want to unregister the replicat from database, so ti removes the information from the goldengate metadata.
Delete delete replicat rep3 deletes the replicat from process
cleanup cleanup replicate rep3 cleansup records from checkpoint table , does not delete the replicat