Re: Migrating large database between platforms: using snapshots

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Sun, 1 Oct 2006 03:05:41 GMT
Message-ID: <J6FsMA.AKG@igsrsparc2.er.usgs.gov>

> I need to migrate 500 GB Oracle 9.2.database from one platform (Sun
> SPARC Solaris) to another (Sun x86 Solaris) with minimal outage. The
> plan is:

One man's large database is another man's small tablespace...... :)

Have you looked at Transportable Tablespaces? Since you are changing platforms, you will have to upgrade to 10g first since Solaris SPARC is big-endian and Solaris x86 is little endian. But this will let you perform the platform switch much quicker than exp/imp.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Sat Sep 30 2006 - 22:05:41 CDT