Oracle 7.3.2 replication faults

Hello!

I have some troubles with PL/SQL wrapper, because I need some information about procedural replication internals and can't find it in legal documentation. Anybody, can you help me? I have following problem: There is master -site, with correctly defined replication environment. There are little number of snapshot sites with updatable snapshots. Network database links - thrue regular phone line and usual modems, like zyxel. Sometimes , line faults has place.

Well, I defined snapshot site, performed first(complex) refresh and runned modem connections. First time (near 2000 transactions), this environments works correctly. After connection fault, I took some deferred calls (originated from snapshot site) on master site in the def$_call table, but its were invisible from deftran view. Next transactions were visible from deftran, but from deferror too - because first part of transactions were not runned, were freezed in the def$_call, and last part of transactions were desynchronized with master site environment.

First question: How I can run this defered calls. Its are transmitted from snapshot to master site yet, and I need only run it. dbms_defer_sys.execute - for execution deferred transactions on a remote site. This procedure works correctly, but has nothing to perform.

Can you recommend me sources, faqs, documentations for correct and clear undestanding of procedural replication mechanizmes of oracle server? I read legal first and second part of oracle documentation about distributed environment, but it is only about interface. Problem solving needs information about internals.

Can You tell me, how this situation on my replication environment could be created? What means most part of def$_call, def$_error, def$_call table columns, like "destination_list varchar2(1)" and so on?

I hope for experienced and clear consultation, Sincerely You, Alexander S. Khrissanov.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 22 1998 - 18:51:08 CDT