Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Migration

RE: Data Migration

From: Carel-Jan Engel <>
Date: Thu, 26 Jan 2006 23:18:02 +0100
Message-Id: <>

No backup plan for 400 GB of data? The stuff in this database can hardly be of any use for your customer.
I don not use backup plans. I do use restore plans, however. Being able to restore the data, that's the whole point. Preferrably within the time constraints of the business. The only thing a backup serves is enabling you to meet the restore requirements. Planning restores, that's the important thing.

You seem to include a platform change as well. The backup wouldn't be very useful in that case.
What Oracle version are we talking? 10gR2 gives you some features of transportable tablespaces combined with datapump. You can transfer tablespaces then.

Otherwise you have two options: Quests SharePlex, or indeed, export/import. (If bandwith is no problem, you have a third option. A database link can be used to copy the data. The time-framed approach would be the same as the export/import description below) With careful planning, the latter option doesn't necessarily require much downtime. It depends, on the way your datamodel is designed. If you have large amounts of time-related data, you can probably export the historical data first, by partial exports. At the final cutover you export the most recent rows, import them at the new platform, enable all constraints and go on.

Best regards,

Carel-Jan Engel

If you think education is expensive, try ignorance. (Derek Bok) ===

On Thu, 2006-01-26 at 12:36 -0500, Seema Singh wrote:

> In case if customer doen't have 400GB Database backup plan currently on
> Sun box then what would be another solutions.
> If they want to change from Solaris to Linux then i think ONLY option we
> have thru export/import right ?
> thx
> >From: "Allen, Brandon" <>
> >To: <>,<>
> >Subject: RE: Data Migration
> >Date: Thu, 26 Jan 2006 10:11:05 -0700
> >
> >Restore a backup to the new server and then ship archive logs and apply
> >them for recovery up until the current online log, then kick all users out
> >of the old server, archive the current log, shutdown the old server and
> >ship the last log to the new server, then apply for recovery and startup
> >the new database, redirect users and let them into the new database.
> >
> >Regards,
> >Brandon
> >
> >
> >
> >-----Original Message-----
> >From:
> >[]On Behalf Of Seema Singh
> >Sent: Thursday, January 26, 2006 10:02 AM
> >To:
> >Subject: Data Migration
> >
> >
> >Hi,
> >
> >We want to migrate 400GB data from one data center to another data
> >center.Please suggest what are the bext way to migrate without downtime or
> >minimize downtime.
> >With regards
> >-Dinesh
> >
> >_________________________________________________________________
> >Don't just search. Find. Check out the new MSN Search!
> >
> >
> >--
> >
> >
> >
> >
> >Privileged/Confidential Information may be contained in this message or
> >attachments hereto. Please advise immediately if you or your employer do
> >not consent to Internet email for messages of this kind. Opinions,
> >conclusions and other information in this message that do not relate to the
> >official business of this company shall be understood as neither given nor
> >endorsed by it.
> >
> _________________________________________________________________
> Is your PC infected? Get a FREE online computer virus scan from McAfee
> Security.
> --

Received on Thu Jan 26 2006 - 16:18:02 CST

Original text of this message