Transactions are not propagated from snapshot to master site
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Transactions are not propagated from snapshot to master site

  1. #1
    Join Date
    Dec 2001
    Posts
    320

    Transactions are not propagated from snapshot to master site

    1 Master site 9.0.1.3 on windows2000 advanced server
    15 Snapshot sites 9.0.1.3 on windows2000 advanced server

    these are production databases

    it has been working for a quite some time now (almost 6 months), all of a sudden, transactions are not propagated to the master site, but are propagated from the master to the snapshot sites, no errors in the deferror on the master site are found.

    this started happening 2 days after i made a duplicate database from the master site, but i don't believe it would affect the replication, as all the database links from the snapshot sites are refrencing the master site, not the duplicate one, besides transactions are refreshed every 15 minutes, so the problem should have occured earlier, not after 2 days.


    what could be the problem?
    Anyone can hold the helm when the sea is calm.

  2. #2
    Join Date
    Dec 2001
    Posts
    320
    Thank you guys, i already solved the problem

    Regards.
    Anyone can hold the helm when the sea is calm.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What was it? I also administer AR (the databases/servers are even in different continents :-))
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Dec 2001
    Posts
    320
    hey Julian,
    Sorry for the delay, i had to regenerate the replication support for a materialized view that was altered recently ( i missed that point when i addressed the problem in the thread).

    Happy New Year )

    Regards.
    Anyone can hold the helm when the sea is calm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width