Re: Porting a VLDB to a different platform (quickly)?

A few ways you can minimize this. If the version of Oracle you are running is exactly the same, then you can "clone" your database using the principles of backup and recovery.

Basically, copy all datafiles and log files from a full-offline backup, preferably with SHUTDOWN IMMEDIATE. You will then simulate the loss of a control file and recover the database and rename it.

All the time it takes is the time to copy the data files. Once that is done, takes very little time to "clone". I do it all the time and works just fine.

Have fun,

doid_at_usa.net wrote:
>
> Fellow users,
>
> I'm looking into moving a ~200Gb Oracle instance onto a hot new platform. The
> new machine comes from a different manufacturer than the old one, and uses a
> much different architecture.
>
> Exports run very slowly on the old server. Based on tests that I've done, I
> expect that the Export/Import route would take at least 5 months.
>
> My manager doesn't seem willing to accept that kind of timeframe:(
>
> Can somebody here draw upon his/her experience and suggest an alternative
> strategy? I hope to shorten the timeline significantly, if possible.
>
> For example, I'm beginning to consider 3rd-party backup/recovery tools. Does
> anyone here have experience using such products to move from one platform to
> another?
>
> I look forward to seeing any suggestions you may have.
>
> doid
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 19 1998 - 22:00:38 CDT