Home » Server Options » Replication » lose snapshot changes in replication
lose snapshot changes in replication [message #75400] Tue, 28 October 2003 05:16
ingenio
Messages: 1
Registered: October 2003
Junior Member
Hi!

we have a replcation environment. This composed for 3 snapshot and 1 master. A modification in a snapshot site is pushed to the master site, and this modification is replied in the another snapshot.

But now, an insert in a table (member) of the snapshot group (there are 4 members), the new data are pushed to the master, but this modifications are delete (lose) in the origin table and are not replicated in the other snapshot.

The transactions are in fact being pushed back to the master site and the transactions are successfully purged from deftran (DEF$_AQCALL), but the insert in the snapshot is lost, and the changes are not being reflected in the others snapshot tables.

I have read the Metalink note 1040975.6, and the parameter PUSH_DEFERRED_RPC is TRUE. In the SYSTEM.DEF$_AQERROR table in the master, there is a lot of errors (around 3.000.000 rows) and in the MLOG$_... table in the master, the inserts in the snapshot aren't reflected.

In Alert log I donīt see nothing.

The refresh job in the snapshot is:

dbms_refresh.refresh('"SNAPADMIN"."CRM_RG"').

If I do a manual complete refresh in the snapshot of the table that is not refresh by the job, this complete refresh is ejecuted successfully.

Could be a solution to delete the table of the replication group in the master and then incorporate this again in the group and then to execute a complete refresh of this table in the snapashot to synchronize?

Sorry my english.
Thanks!
Previous Topic: What is best to use for signature data?
Next Topic: materialized views
Goto Forum:
  


Current Time: Mon May 16 01:08:37 CDT 2022