OraFAQ Forum: Replication » Advanced Replication (ASR) Got Stuck

Home » Server Options » Replication » Advanced Replication (ASR) Got Stuck (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi - OID 10.1.4.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Advanced Replication (ASR) Got Stuck [message #505846]

Thu, 05 May 2011 04:42

Asma2103
Messages: 1
Registered: May 2011
Location: Netherlands

Junior Member

Hi All,
We have 2 Sun Solaris (Solaris 10) nodes each has an oracle db, and OID of the above versions.
There is an ASR running between both nodes, and it has been setup as follow:
$ ./ldap/bin/remtool -asrsetup -v
------------------------------------------------------------------------------
ASR Setup for OID Replication
WARNING:
Make sure that the replication administrator that you
enter below does not exist already in any of the nodes
that will be part of the DRG to be created now. If the
user exists, that user will be dropped and will be
created newly.
------------------------------------------------------------------------------
Enter replication administrator's name : repadmin

Enter replication administrator's password :
Reenter replication administrator's password :
Enter Master Definition Site (MDS) details :
Enter global name of MDS : node1

Enter SYSTEM user password of MDS :
Enter Remote Master Site (RMS) details :
Enter global name of RMS # 1 : node2

Enter SYSTEM user password of RMS # 1 :
Are there more Remote Master Sites in the group? [y/n/q] : n

Verify the details you had entered.
------------------------------------------------------------------------------
Replication administrator's name : repadmin
Master Definition Site : node1
Remote Master Site # 1 : node2
Are these details correct? [y/n/q] : y

------------------------------------------------------------------------------
ASR setup in progress...

The ASR configuration issues messages detailing the progress of the replication setup until the following completion notice:

------------------------------------------------------------------------------
ASR setup has been configured successfully.
------------------------------------------------------------------------------
Directory Replication Group (DRG) details :

-------- ------------- ----------------------- ------------- ------------- ----
Instance Host Name Global Name Version Replicaid Site
Name Type
-------- ------------- ----------------------- ------------- ------------- ----
node1 ldap01 NODE1.WORLD OID 10.1.4.0. ldap01_node1 MDS
node2 ldap02 NODE2.WORLD OID 10.1.4.0. ldap02_node2 RMS
-------- ------------- ----------------------- ------------- ------------- ----

We ran a perl script which is using ldapmodify to change the value of one attribute in all records (7 Millions records).
That has been done by creating many of LDIF files each of 10,000 records in 26.04, and by mistake this script has ran 3 times in parallel.
Currently the replication between both nodes are stuck, and when I query the ods_chg_log on the master node (node1):
SQL> select count(*) from ods_chg_log;

COUNT(*)
----------
6690594
And the number is not decreasing.
And I queried on the asr_chg_log on the master node (node1):
SQL> select count(*) from asr_chg_log;

COUNT(*)
----------
178287
And it is increasing.

I queried on the ods_chg_log on the slave node (node2):
SQL> select count(*) from ods_chg_log;

COUNT(*)
----------
0
And it is equal to 0 always
And I queried on th asr_chg_log on the slave node (node2):
SQL> select count(*) from asr_chg_log;

COUNT(*)
----------
249392
And it is increasing.

I bounced the oridrepld on both nodes but it did not help, any clue please?

Report message to a moderator