RE: How to turn on or turn off replication manually.

RE: How to turn on or turn off replication manually.

 

  

Folks,

My situation is like this.

I have two nodes with Oracle replication Primary node A with good data and
secondary B with corurupted data. I would like to follow the instruction
below to rebuild B. Before I do it, I will halt all transaction in A and
turn off replication between A to B. After rebuilt B, I need to turn
replications on so that transaction can be pushed to B.

Any good approaches for this situation, Please advice.



III. You can also drop the table in question from the replicated group from
all master sites, resynchronize and then add it back:

a. Drop the object from the replication group using
DBMS_REPCAT.DROP_MASTER_REPOBJECT.
b. Export the 'correct' table. This is the table you have deemed
the most accurate.
c. Truncate the table on all other master sites and import using
the export from the previous step.
d. Add the object back to the replication group using
DBMS_REPCAT.CREATE_MASTER_REPOBJECT, specifying parameter
COPY_ROWS=>FALSE
e. GENERATE_REPLICATION_SUPPORT


>From: "Lewis, John (Litton)" <John.[Email Address Removed] 'DBA GURUS' <[Email Address Removed] "'[Email Address Removed]
><[Email Address Removed] RE: How to turn on or turn off replication manually.
>Date: Fri, 28 Jun 2002 10:25:41 -0500
>
>Seriously, folks.
>
>Quick way to break it is break the oracle job that sends the data.
>You need to be system or 'repadm'. This off course will cause transactions
>to backup.
>
>The PREFERRED way is to use the Oracle supplied instance manager
>and stop the service.
>
>The problem is if you start it back up - what do you do with
>the table inconsistencies - esp. if you have updates on records that may
>not
>exist because you stopped the service.
>
>Point being is if it's turned off you need a plan to resync or throw away
>transactions.
>
>The scope of that goes far beyond what we can discuss here.
>
>
>
>
>
>-----Original Message-----
>From: DBA GURUS [mailto:[Email Address Removed] Friday, June 28, 2002 10:13 AM
>To: Lewis, John (Litton); [Email Address Removed] RE: How to turn on or turn off replication manually.
>
>
>Could you please list the most common approaches?
>
>
><< InterScan_Disclaimer.txt >>




_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Oracle LazyDBA home page