Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Replication not pushing Data as needed

Status
Not open for further replies.

pshetal

IS-IT--Management
Jul 8, 2004
6
CA
Hi!

I have just started on a Oracle DBA Role and need help with fixing Replication.
Problem: Replication has been set up and is running, however data is not being replicated properly. Only some changes make it to replicated tables.

Replication setup is like this:
1 Master Group called - "GROUP1", Site - HLCAPROD.WORLD
376 Registered Materialized Views

Administrative Job - scheduled to run every 10 minutes.
Purge Job - runs every hour
Push Job - should run every 10 minutes but fails

I am at a beginner level as far as replication is concerned. Please advise:
1 -How I can gather more information about the way replication is setup?
2 - How can I refresh all the data on replicated site from the Master Site
3 - Is it possible to SYNCHRONIZE the Data from Master?
4 - Any links to Online resources on the matter?

I will greatly appreciate all you assistance in this issue>

Thanks
Shetal
 
Oh! One important detail I missed is - this is running on Oracle 8.1.7. Oracle Management Server is not set up, I am able to connect directly to the DB only - thru Replication Manager or EM Console.

Thks
Shetal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top