Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

replication is not working when i did DML opetation

Posted on 2009-05-13
3
Medium Priority
?
423 Views
Last Modified: 2013-12-18
Hello Experts,

i have a problem with replication (one way)

I created a one-way table replication using streams. The replication would propagate to the target database almost immediately whenever a DML change was made on the source table. I then tried to pause the replication by stopping the apply process at the target database. I then proceeded to insert rows into the source table; and then restarted the apply [ e.g., dbms_apply_adm.start_apply( STRMS_APPLY_HB ) ]. The Streams subsystem is no longer propgating DML changes to the target table.

Did I miss something thats preventing this replication from being paused?

can any one help me

0
Comment
Question by:pavan27
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 24415147
What is apply server doing. Check  V$STREAMS_APPLY_SERVER:

The state of an apply server describes what the apply server is doing currently. You can view the state of each apply server for an apply process by querying the V$STREAMS_APPLY_SERVER dynamic performance view. The following apply server states are possible:

IDLE - Performing no work
RECORD LOW-WATERMARK - Performing an administrative action that maintains information about the apply progress, which is used in the ALL_APPLY_PROGRESS and DBA_APPLY_PROGRESS data dictionary views
ADD PARTITION - Performing an administrative action that adds a partition that is used for recording information about in-progress transactions
DROP PARTITION - Performing an administrative action that drops a partition that was used to record information about in-progress transactions
EXECUTE TRANSACTION - Applying a transaction
WAIT COMMIT - Waiting to commit a transaction until all other transactions with a lower commit SCN are applied. This state is possible only if the COMMIT_SERIALIZATION apply process parameter is set to a value other than none and the PARALELLISM apply process parameter is set to a value greater than 1.
WAIT DEPENDENCY - Waiting to apply an LCR in a transaction until another transaction, on which it has a dependency, is applied. This state is possible only if the PARALELLISM apply process parameter is set to a value greater than 1.
WAIT FOR NEXT CHUNK - Waiting for the next set of LCRs for a large transaction
TRANSACTION CLEANUP - Cleaning up an applied transaction, which includes removing LCRs from the apply process queue
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 2000 total points
ID: 24415207
To find out the state of the capture process:

 

select state from v$streams_capture;

 

STATE

---------------------------------

CAPTURING CHANGES

 

 

 

To find out total number of messages propagated on sending side:

select total_msgs from v$propagation_sender

 

TOTAL_MSGS

--------------------

15863766

 

 

To find out what is the state of apply reader:

select state from v$streams_apply_reader;

STATE

--------------

SPILLING

 

0
 
LVL 48

Expert Comment

by:schwertner
ID: 25332478
Good luck!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

719 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