Getting 2 databases in sync via ASymmetric Replication

 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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helena Markováprogrammer-analystCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.