Streams for one-time single source replication
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Thu, 6 Feb 2014 13:35:07 -0600 (CST)
Message-ID: <693b071d08ee5ba095a7047761e99544.squirrel_at_society.servebeer.com>
Hey all,
Date: Thu, 6 Feb 2014 13:35:07 -0600 (CST)
Message-ID: <693b071d08ee5ba095a7047761e99544.squirrel_at_society.servebeer.com>
Hey all,
So I'm looking at a shrinking downtime window for an 11.2.0.3.x->11.2.0.3.8 (both EE) production DB move/reconfigure across two systems with only 1Gb network connecting them. The move is going from AIX 5.3 to AIX 7.1 with a subset of schemas/tablespaces.
Not only is the downtime short for the cutover, but time until the cutoff is very short (3-4 months), so I was thinking to use Streams to get this done. Basically, I was hoping for this at a *very* high level:
- Create new DB on destination server.
- Sometime before cutover, use Streams to sync schemas from source to dest.
- At cutover, stop Streams.
- Start business on new dest DB.
First, does this one-shot one-way replication sound doable?
Second, a week in the Oracle Streams class (online, at 3:00AM???) seems to be a waste. I see a few books out there -- any recommendations on firehose-to-a-teacup learning materials?
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 06 2014 - 20:35:07 CET