Getting 2 databases in sync via ASymmetric Replication

Posted on 2003-02-24
Medium Priority
Last Modified: 2013-12-12
 I have configured asymmetric replication between 2 Oracle databases(8i).
 If 1 database goes down, I intend to get it in sync with the other database when it comes up by using the DBMS_DEFER_SYS.PUSH procedure.My understanding from a thread I had run before in Experts-exchange was that the data in the deffered transaction queue is stored in the system tablespace and hence when I run this procedure the data will be "pushed" to the second database.I have also tried it and the concept I believe is right
  THe Q is this:
 If the database is down for a long period of time, the replication job will fail after 16 attempts.Does this mean that the data will no longer be put in the Deferred Q.Hence when I run the DBMS_DEFER_SYS.PUSH..I will not get all the data but only the data for the first 16 job attmpts..Is that a valid statement
 Please help
Question by:nesterdias
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

tschofiled earned 200 total points
ID: 8024230

All transactions are queued up in (from memeory) def_tran. You will lose nothing until you run out of space then...!! The job transfers from the Q to the second (or other) database.

The important thing here is that by default as you say the Replication suite of tables is in the system tablespace. This can potentially cause system to be filled and cause the database to grind to a halt.
There is an Oracle process to move the replication schema. It was a bit buried in Metalink, and I do have a "written up" version, which I could transcribe to here.

LVL 22

Expert Comment

by:Helena Marková
ID: 10152787
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept tschofiled's comment as answer.

Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question