Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

replication is not working when i did DML opetation

Posted on 2009-05-13
3
Medium Priority
?
428 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
  • 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

580 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