Avatar of nesterdias
nesterdias
 asked on

Getting 2 databases in sync via ASymmetric Replication

Hi,
 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
Oracle Database

Avatar of undefined
Last Comment
Helena Marková

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
tschofiled

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Helena Marková

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.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes