GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How do I migrate two vendor created databases with streams replication to a new platform?

edited Apr 4, 2012 8:11PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
 I have an operational database and a historical database (v10.2.0.3) where records are transferred to the historical database using Oracle Streams.  The databases were set up by a vendor who wants to charge for services to move the databases to a new platform (HP to Linux so there is an endian change).  Is there a resource out there describing the process?

I tried a full export/import, but this doesn't catch the Streams rules.  I can find nothing that describes dumping the rules so that they can be recreated in the new databases.
I tried opening a SAR, but it is maddeningly slow process, and they would not simply describe how to do it - just wanted to keep trying things and running the health check.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center