RE: Re: Migration
Hi Stephane, The way you put it here would mean that the internal format of the tablespaces will be big/little-endian independant. That would mean either an extra amount of overhead in the low level IO, or Oracle-specific arithmatic everywhere in the kernel. I doubt whether Oracle would do that. It might (will!) cause severe performance penalties. A few weeks ago I had an interview with Chuck Rozwat. I asked him this specific question. He was quite convinced telling me that the transport mechanism (data pump?) performs the HW-dependent conversions whenever you transfer a tablespace from one platform to another. He told me also that the HW-dependant differences will remain in place, and it isn't possible to have a R/O tablespace opened simultaneously by instances running on different platforms. (Not even Windoze/Linux combined) So the binary incompatability will remain in place. Alas, I haven't got a beta version, so I haven't been able to test it yet :( Regards, Carel-Jan At 06:54 10-11-03 -0800, you wrote: It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF >- --- Original Message --- - >From: "Yechiel Adar" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 10 Nov 2003 05:54:25 > >Wait for 10g. They say that you could just copy the >datafiles and them plug >them in to he new database, even across platforms. > >Yechiel Adar >Mehish >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Monday, November 10, 2003 12:24 AM > > >> 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>o Teles >> >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
Re: Re: Re: Migration
Well, I don't know about it's performance, but I think this conversion doesn't require any temporary space, because the byte values of some structures in blocks have to be swapped, and this a trivial operation. I think it may still be faster, especially if we are dealing with huge amounts of data, swapping bytes in blocks is faster than reading and parsing data through buffer cache, transferring it over sqlnet and formatting + writing it back to datablocks... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 10, 2003 6:14 PM > Tanel, > > Any idea about speed and temporary storage requirements? Especially for 32G+ datafiles ;-) ? > Wondering if it will really be useful in practice, compared to what is available today. Well, it may do for simpler operations, but not necessarily faster. > > SF > > >- --- Original Message --- - > >From: "Tanel Poder" <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > >Sent: Mon, 10 Nov 2003 07:49:26 > > > >You can't just copy over the files with os commands > >and hope that Oracle > >will somehow recognize them. > >You have to use RMANs new convert tablespace > >command to do the byte order > >conversion. > > > >Tanel. > > > >- Original Message - > >To: "Multiple recipients of list ORACLE-L" > ><[EMAIL PROTECTED]> > >Sent: Monday, November 10, 2003 4:54 PM > > > > > >> It raises an interesting question. As of today, > >we have datafiles which > >are OS dependent and _not_ binary compatible from > >one system to another. We > >upgrade to 10g and it will become magically binary > >compatible. Which means > >that the upgrade process will do more intimate > >things than updating some > >file header block, creating a couple of new tables > >in the data dictionary > >and recreating view. > >> > >> Has anybody tried to upgrade from 9.x to 10g yet, > >on some database of > >decent size ? > >> > >> SF > >> > >> >- --- Original Message --- - > >> >From: "Yechiel Adar" <[EMAIL PROTECTED]> > >> >To: Multiple recipients of list ORACLE-L > >> ><[EMAIL PROTECTED]> > >> >Sent: Mon, 10 Nov 2003 05:54:25 > >> > > >> >Wait for 10g. They say that you could just copy > >the > >> >datafiles and them plug > >> >them in to he new database, even across > >platforms. > >> > > >> >Yechiel Adar > >> >Mehish > >> >- Original Message - > >> >To: "Multiple recipients of list ORACLE-L" > >> ><[EMAIL PROTECTED]> > >> >Sent: Monday, November 10, 2003 12:24 AM > >> > > >> > > >> >> 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>o Teles > >> >> > >> >> > >> -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Re: Re: Migration
Tanel, Any idea about speed and temporary storage requirements? Especially for 32G+ datafiles ;-) ? Wondering if it will really be useful in practice, compared to what is available today. Well, it may do for simpler operations, but not necessarily faster. SF >- --- Original Message --- - >From: "Tanel Poder" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 10 Nov 2003 07:49:26 > >You can't just copy over the files with os commands >and hope that Oracle >will somehow recognize them. >You have to use RMANs new convert tablespace >command to do the byte order >conversion. > >Tanel. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Monday, November 10, 2003 4:54 PM > > >> It raises an interesting question. As of today, >we have datafiles which >are OS dependent and _not_ binary compatible from >one system to another. We >upgrade to 10g and it will become magically binary >compatible. Which means >that the upgrade process will do more intimate >things than updating some >file header block, creating a couple of new tables >in the data dictionary >and recreating view. >> >> Has anybody tried to upgrade from 9.x to 10g yet, >on some database of >decent size ? >> >> SF >> >> >- --- Original Message --- - >> >From: "Yechiel Adar" <[EMAIL PROTECTED]> >> >To: Multiple recipients of list ORACLE-L >> ><[EMAIL PROTECTED]> >> >Sent: Mon, 10 Nov 2003 05:54:25 >> > >> >Wait for 10g. They say that you could just copy >the >> >datafiles and them plug >> >them in to he new database, even across >platforms. >> > >> >Yechiel Adar >> >Mehish >> >- Original Message - >> >To: "Multiple recipients of list ORACLE-L" >> ><[EMAIL PROTECTED]> >> >Sent: Monday, November 10, 2003 12:24 AM >> > >> > >> >> 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>o Teles >> >> >> >> >> -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
Re: Re: Migration
You can't just copy over the files with os commands and hope that Oracle will somehow recognize them. You have to use RMANs new convert tablespace command to do the byte order conversion. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 10, 2003 4:54 PM > It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. > > Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? > > SF > > >- --- Original Message --- - > >From: "Yechiel Adar" <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > >Sent: Mon, 10 Nov 2003 05:54:25 > > > >Wait for 10g. They say that you could just copy the > >datafiles and them plug > >them in to he new database, even across platforms. > > > >Yechiel Adar > >Mehish > >- Original Message - > >To: "Multiple recipients of list ORACLE-L" > ><[EMAIL PROTECTED]> > >Sent: Monday, November 10, 2003 12:24 AM > > > > > >> 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>o Teles > >> > >> > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Re: Migration
It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF >- --- Original Message --- - >From: "Yechiel Adar" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 10 Nov 2003 05:54:25 > >Wait for 10g. They say that you could just copy the >datafiles and them plug >them in to he new database, even across platforms. > >Yechiel Adar >Mehish >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Monday, November 10, 2003 12:24 AM > > >> 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>o Teles >> >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: RE: Migration utility from 7.3.4 to 9i ??
Hi Dick, According to the 9i Migration Utility Guide, the Mig Utility that comes with 9i will migrate 7.3.x database to 9i directly. Unfortunately we had no 7.3.4 database to migrate to 9.0.1. So I have not had a chance to test it myself. We migrated several 7.3.x database to 8.x using Mig Util without any problems. Of course, one can always use export/import for such things. - Kirti -Original Message- Sent: Thursday, February 07, 2002 8:22 AM To: Deshpande; Kirti; Multiple recipients of list ORACLE-L Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: "Deshpande; Kirti" <[EMAIL PROTECTED]> Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).