This discussion is archived
1 Reply Latest reply: Mar 27, 2012 11:12 AM by Iordan Iotzov RSS

Move Capture to New Host and Oracle Versoin

924878 Newbie
Currently Being Moderated
I need to move my current Streams Capture configuration (10gR2) to a new host (11gR2), both systems are AIX 6.1.

Capture Side:
AIX 6.1
Oracle 10.2.0.5.0
200 GB of data
table level capture

Apply Side:
AIX 6.1
Oracle 11.2.0.3.0

Option A: upgrade capture side to 11.2.0.3.0 using dbua then do an RMAN duplicate

Option B: datapump? What about the streams instantiation (SCN)?

Any help would be appreciated.

Thanks,
Bernie
  • 1. Re: Move Capture to New Host and Oracle Versoin
    Iordan Iotzov Expert
    Currently Being Moderated
    Another way to go is to do the upgrade/migration (any way you want) and re-build Streams configuration.
    You need to make sure the target and the source are in sync in terms of data content.
    One way to do that is to start your upgrade/migration only after all pending changes from the source are applied to the target.

    Iordan Iotzov
    http://iiotzov.wordpress.com/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points