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...
Custom Search
Saturday, January 10, 2009
Subscribe to:
Post Comments (Atom)
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?
ReplyDeleteI 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.
ReplyDeleteYou 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