Hi
Do not suspend the replication other wise you can insert any row
in both side.
1. First you have to unscheduled the job like push and purge on the
both side.
2.Then all the transaction will accumulated at deftran in your
primary side.
3. Shutdown the database B.
4. Take cold backup for future use.
5. Start the database B and unscheduled the job called
push and purge because these jobs are automatically start.
6. Find out all referential constraint for the database B and disable
all the key.
7. Truncate all the replicated table on side B.
8. Enable the constraints what you did on step 6.
9. Then run exec dbms_reputil.replication_off/on for each DML entry like
when you will insert the rows from the side A. Be careful because
reputil
only do the replication off on session level.
10. Right now both the database are sync.
11. Schedule the push and purge job both side. If you can count on
deftran view on
database A that will start reduce. So all the transaction is replicate
to the side B.
Arata.
-----Original Message-----
From: DBA GURUS [mailto:[Email Address Removed] Friday, June 28, 2002 12:03 PM
To: LazyDBA.com Discussion
Subject: 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page