?
Solved

Replication Problem in Oracle

Posted on 2011-05-04
3
Medium Priority
?
620 Views
Last Modified: 2012-05-11
I have 2 Sun solaris 10 nodes with Oracle 10g (Release 10.2.0.3.0 - 64bits) and OID 10.1.4.0.1
on each node.
I have ASR replication running between them
I have run a bulk modifcation job using ldapmodify on one node to add a new LDAP attribute to each record, of total number of 8Millions records, but it seems that the bulk  is too much of the replication from node 1 to node 2, where in the replication log in node1 I can see:
2011/05/04:19:44:49 * 19 human intervention changes queued from Node02 to Node01.
2011/05/04:19:47:54 * 10000 new changes (for transport) queued from Node1 to Node1.

And in the replication record in node2:
2011/05/04:19:52:40 * 1413 new changes queued from Node1 to Node2.
2011/05/04:19:53:41 * 823 new changes queued from Node1 to Node2.

If I want to check that the replication is running, and the queue is decreasing can someone guide me how I can do so?
0
Comment
Question by:Ashraf-Hassan
  • 3
3 Comments
 
LVL 16

Expert Comment

by:Swadhin Ray
ID: 36315608
As you are using through a scheduler then try to check if you jobs are4 running or failed from the below query :

elect
   log_date,
   job_name,
   status,
   req_start_date,
   actual_start_date,
   run_duration
from
   dba_scheduler_job_run_details
where
--   job_name = 'MYJOB'
   status <> 'SUCCEEDED'
order by
   actual_start_date;

Open in new window



For more information on fixing broken jobs you can visit the below URL:

http://download.oracle.com/docs/cd/E11882_01/timesten.112/e13075/rep_trouble.htm

http://www.dba-oracle.com/t_fixing_broken_jobs.htm

0
 
LVL 16

Accepted Solution

by:
Swadhin Ray earned 2000 total points
ID: 36317603
Typo mistake for the above query.

Here is the correct one:

select
   log_date,
   job_name,
   status,
   req_start_date,
   actual_start_date,
   run_duration
from
   dba_scheduler_job_run_details
where
--   job_name = 'MYJOB'
   status <> 'SUCCEEDED'
order by
   actual_start_date;

Open in new window

0
 
LVL 16

Expert Comment

by:Swadhin Ray
ID: 36345286
is your problem got resolved?
 
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to recover a database from a user managed backup
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question