Re: Migrate 9i VLDB Cross Platform - Using Streams? Or ??

From: Oracle Dba Wannabe <>
Date: Wed, 13 Jan 2010 05:03:18 -0800 (PST)
Message-ID: <>

golden gate is certainly on the cards - but as you said it comes with a cost. However it does provided an added benefit where it supports long's and certain other data types and objects which aren't supported in oracle 9i streams. What it comes down to though (and will eventually be tested) is whether either technology can help the target catch up with the source. Seeing as both will require time to instantiate the target database. That said the source only generates about 300k/s so hopefully it shouldnt be an issue. I was also curious whether anyone had any ideas on how best to instantiate the target database via export/import or perhaps an idea on how long it would take for the this process on a 4TB database.


From: Job Miller <>
Sent: Wed, January 13, 2010 11:15:40 AM
Subject: Re: Migrate 9i VLDB Cross Platform - Using Streams? Or ??

oracle's golden gate would be another viable although there are licensing implications..


--- On Tue, 1/12/10, Oracle Dba Wannabe <> wrote:

> From: Oracle Dba Wannabe <>
> Subject: Migrate 9i VLDB Cross Platform - Using Streams? Or ??
> To:
> Date: Tuesday, January 12, 2010, 12:24 PM
> Hi
> All,
> I was wondering whether anyone has used 9i streams to
> facilitate a migration across platforms for a VLDB -
> approximately 4TB.
> I need to migrate a 9i database from Solaris 8 to HP-UX
> 11.31. I've had
> a look at the various options for migration across
> platforms - bearing
> in mind this is 9i and downtime will be at 6 hours - it
> appears that
> perhaps, streams is the best option available (unless
> anyone has some
> experience they are willing to share). That said, does
> anyone have any
> experience in a similar activity (leveraging streams) or at
> least in
> cross platform migration for large 9i databases they would
> be willing
> to share?
> What I'm concerned about is instantiating this large
> database and whether streams will be able to catch up (Have
> yet to test
> it), so if anyone has some great ideas on how to say
> leverage
> export/import - like multiple export to pipe, import from
> pipe sessions
> - I would love to hear em.
> On
> a side note, does anyone have any numbers for how long its
> taken them
> to export import databases in the terabyte range? I do
> realize this
> would differ from case to case, but any numbers at this
> point would be
> helpful.
> Thanks


Received on Wed Jan 13 2010 - 07:03:18 CST

Original text of this message