Re: Streams for one-time single source replication
- From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 6 Feb 2014 16:19:53 -0600 (CST)
Reed replies:
> One of the gotchas we had was with sequences.
Not in use for these schemas. Yay! We do have a few triggers though...
> Another issue we dealt with was record updates. Connections on the source
> were making changes to records while connections on the destination were
> making updates to the same records. This would cause a conflict in the
> apply process and cause the apply to stop working. It would add an entry in
> the error log but would need to be restarted. The biggest problem with this
> was due to the applications updating the entire record even though only one
> or two fields were changed.
Hmmmm...I could see that happening a lot here. :|
> How are you
> applications connecting to the database. Are they using remote resolution
> with an alias? That would provide an easier cut over, just updating where
> the alias points.
The app server is being cutover at the same time as well, as we have all-new
hardware for all tiers. So no worries from that standpoint.
Thanks!
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
