RE: Moving a 250gig database from SUN to HPUX
- From: Thomas Day <tday6@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 May 2004 08:01:12 -0400
We had to do something similar.
Look-up tables were moved using imp/exp.
Transaction tables where replicated using materialized views.
We froze the master site for a couple of hours overnight, refreshed the
materialized views one last time, dropped the mlogs, dropped the
materialized views, kept the underlying tables and switched the IP address
in the ONAMES.
I'm leaving out the messy details about indexes, triggers, procs, userids,
grants and privileges but for the data move the downtime was a few hours.
"Khedr, Waleed"
<Waleed.Khedr To:
<oracle-l@xxxxxxxxxxxxx>
@FMR.COM> cc:
Sent by: Subject: RE: Moving a 250gig
database from SUN to HPUX
oracle-l-bounce
05/25/2004 06:31
PM
Please respond
to oracle-l
What about copying tables' data over the network, using copy, or
insert/append/parallel dml?
Creating empty structure first without indexes (indexes could be rebuilt
at the end), loading the tables, and building the indexes.
Regards,
Waleed
-----Original Message-----
From: Guerra, Abraham J [mailto:AGUERRA@xxxxxxxxx]=20
Sent: Tuesday, May 25, 2004 4:03 PM
To: ORACLE-L@xxxxxxxxxxxxx
Cc: Morrissey, Jay A
Subject: Moving a 250gig database from SUN to HPUX
Content-Type: text/plain;
charset=3D"us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello group,
=3D20
Has any of you moved a 250+ database from SUN into HPUX? I have a
window of 36 hours to do this. I'm planning to divide the database into
multiple imports/exports and multi-tasks them.
=3D20
Any ideas or tools out there that would be a better approach?
=3D20
Your ideas/comments are appreciated.
=3D20
Abraham Guerra
American Family Insurance
-- Binary/unsupported file stripped by Ecartis --
-- Type: image/jpeg
-- File: Notebook.jpg
-- Desc: Notebook.jpg
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
