<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Accept tschofiled's comment as answer.<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
Henka<br />
EE Cleanup Volunteer
</div>


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

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp;I have configured asymmetric replication between 2 Oracle databases(8i).<br />
&nbsp;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 &quot;pushed&quot; to the second database.I have also tried it and the concept I believe is right<br />
&nbsp; THe Q is this:<br />
&nbsp;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<br />
&nbsp;Please help
</div>
</div>


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

Getting 2 databases in sync via ASymmetric Replication

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.