[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-warehouse-l
Subject: Re: Migration
From: "Amin Adatia" <amin_adatia () hotmail ! com>
Date: 2003-11-06 2:24:21
[Download RAW message or body]
Does IBM-AIX read HP-UX files? If it does then you can copy the files and create that \
database with "new control files" which will be the fastest way.
With the amount of data, I would not import the indexes but create them after using \
the unrecoverable option. Also have the archive log mode turned off. I would guess it \
will be more than hours and hopefully less than a week.
By the way, why the switch from HP to IBM? The downtime of the DW must surely be more \
than the cost difference between the two.
Regards
Amin Adatia (amin@knowtech.ca)
KnowTech Solutions Inc (www.knowtech.ca)
(613) 226-8378 Fax (613) 226-7004 Mobile (613) 864-8378
----- Original Message -----
From: A. Teles
To: Multiple recipients of list ODTUG-WAREHOUSE-L
Sent: Wednesday, November 05, 2003 17:44
Subject: Migration
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
2.. Witch is the time frame in a worst case for this (how many hours,
days or weeks!!)?
3.. It is possible to apply the mentioned technique or some other (witch
one?) in uptime, totally or partially?
4.. Witches are the main tasks to consider in a planning schedule?
5.. Witches are the time frames associated to these tasks?
Thanks
Arménio Teles
--
Thanks to everyone for making ODTUG 2003 a great success! See you in 2004!
If you want to volunteer for a committee, visit http://www.odtug.com
--
Author: A. Teles
INET: ateles@netcabo.pt
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-WAREHOUSE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Does IBM-AIX read HP-UX files? If it does then you
can copy the files and create that database with "new control files" which will
be the fastest way.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>With the amount of data, I would not import the
indexes but create them after using the unrecoverable option. Also have the
archive log mode turned off. I would guess it will be more than hours and
hopefully less than a week.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>By the way, why the switch from HP to IBM? The
downtime of the DW must surely be more than the cost difference between the
two.</FONT></DIV>
<DIV><BR>Regards<BR>Amin Adatia (<A
href="mailto:amin@knowtech.ca">amin@knowtech.ca</A>)<BR>KnowTech Solutions Inc
(<A href="http://www.knowtech.ca">www.knowtech.ca</A>)<BR>(613) 226-8378
Fax (613) 226-7004 Mobile (613) 864-8378</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 \
2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original Message \
----- </DIV> <DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ateles@netcabo.pt href="mailto:ateles@netcabo.pt">A. Teles</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=ODTUG-WAREHOUSE-L@fatcity.com
href="mailto:ODTUG-WAREHOUSE-L@fatcity.com">Multiple recipients of list
ODTUG-WAREHOUSE-L</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, November 05, 2003
17:44</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Migration</DIV>
<DIV><BR></DIV>Hi List,<BR><BR>Could someone please help me?<BR><BR>Assumption
situation - Platform migration of Oracle DW on Oracle DB (data<BR>volume 3.5
TB) from HP-UX to IBM-AIX<BR><BR> 1.. DB migration; it is correct to use
Export/Import technique/method in<BR>the above assumption?<BR> 2..
Witch is the time frame in a worst case for this (how many hours,<BR>days or
weeks!!)?<BR> 3.. It is possible to apply the mentioned technique or
some other (witch<BR>one?) in uptime, totally or partially?<BR> 4..
Witches are the main tasks to consider in a planning schedule?<BR> 5..
Witches are the time frames associated to these
tasks?<BR><BR>Thanks<BR>Arménio Teles<BR><BR><BR>-- <BR>Thanks to everyone for
making ODTUG 2003 a great success! See you in 2004!<BR>If you want to
volunteer for a committee, visit <A
href="http://www.odtug.com">http://www.odtug.com</A><BR>-- <BR>Author: A.
Teles<BR> INET: <A
href="mailto:ateles@netcabo.pt">ateles@netcabo.pt</A><BR><BR>Fat City Network
Services -- 858-538-5051 <A
href="http://www.fatcity.com">http://www.fatcity.com</A><BR>San Diego,
California -- Mailing list and web
hosting
services<BR>---------------------------------------------------------------------<BR>To \
REMOVE yourself from this mailing list, send an E-Mail message<BR>to: <A
href="mailto:ListGuru@fatcity.com">ListGuru@fatcity.com</A> (note EXACT
spelling of 'ListGuru') and in<BR>the message BODY, include a line containing:
UNSUB ODTUG-WAREHOUSE-L<BR>(or the name of mailing list you want to be removed
from). You may<BR>also send the HELP command for other information (like
subscribing).<BR></BLOCKQUOTE></BODY></HTML>
--
Thanks to everyone for making ODTUG 2003 a great success! See you in 2004!
If you want to volunteer for a committee, visit http://www.odtug.com
--
Author: Amin Adatia
INET: amin_adatia@hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-WAREHOUSE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic