Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Saturday, January 10, 2009

Re-Synchronize/Refresh a Table in Oracle Streams

The purpose of this article is to outline the steps for Re-Synchronize/Refresh a single table if it is out of sync with source site in one-way replication between two ORACLE databases in Streams environment.

Example:
Schema:SCOTT
Table:EMP

Steps for Refreshing a Table in Streams:

If one of the tables on the Target site is out of Sync with Source site then follow below steps to re-synchronize both:

1. Stop Capture Process on Source(S)
2. Stop Propagation Process on Source(S)
3. Stop Apply Process on Target(T)
4. Delete the apply errors on Target(T)
5. Truncate the problem table on Target(T)
6. Re-instantiate the problem table on Source(S)
7. Synchronize the problem table through exp/imp
8. Start the apply Process on Target(T)
9. Start the propagation Process on the Source(S)
10. Start the Capture Process on the Source(S)

read the full post...

3 comments:

  1. Anonymous6:24 AM

    Good one. I was searching for a specific task which involves streams. I need to rebuild two instances from production using RMAN. These two instances in production are replicated using streams. I want to retain replication configuration in the new environment as well. Do I need to change anything in stream setting as the database name and global names will change in new environment?

    ReplyDelete
  2. I haven't tried this before, rebuilding the Instances. As it would be a different environment, it requires to rebuild with few changes, Not sure on this. May be a SR from Oracle will help you to give more details on this.

    ReplyDelete
  3. You need to reconfigure streams as you said dbname & global name changes in new environment because streams process(capture,propagation & apply) uses source & target database name while configuring.

    ReplyDelete

 
Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved