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)
icon8.gif  Advanced Replication (ASR) Got Stuck [message #505846] Thu, 05 May 2011 04:42 Go to next message
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?
Re: Advanced Replication (ASR) Got Stuck [message #506129 is a reply to message #505846] Fri, 06 May 2011 11:05 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Just want to know are you discussing here oracle replication / oracle advanced replication?

Babu
Previous Topic: Refresh fails on MV with CLOB data type
Next Topic: SNAPSHOT Refresh Problem
Goto Forum:
  


Current Time: Sat May 30 07:57:36 CDT 2020