RE: Using CONVERT DATABASE for endian change?

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 9 Jul 2008 19:31:43 -0400
Message-ID: <667C10D184B2674A82068E06A78382B51FD4D3D8@AAPQMAILBX01V.proque.st>

Don,

I agree w/ Finn's assessment. I did a conversion from Sun Sparc Oracle 9.2.0 to Linux x86-64 Oracle 10.2.0. Because I did an endian conversion, I had to do tablespace at a time.

Very roughly, here's what I did:

1.)  Create new database on Linux as 10.2.0.
2.)  Clone prod database, upgrade it from 9.2 to 10.2.
3.)  Get SAN storage presented to Solaris server.
4.)  NFS mount that storage to Linux server.
5.)  Use RMAN to convert application tablespaces, i.e., everything except SYSTEM, TEMP, UNDO, SYSAUX, and XDB, and write the converted files to the storage area created in step #3.
6.)  Do export/import of tablespace metadata.
7.)  rename each tablespace in 10.2 (Linux) from <tablespace_name> to <tablespace_name>_old.
8.)  Create new tablespaces in 10.2, in permanent storage area (ASM, in my case).
9.)  Alter table move to move from _old tablespaces to new tablespaces, and rebuild all indexes.

10.) Drop _old tablespaces from the Linux 10.2 database. 11.) Delete all conversion files, free up SAN space allocated in step #3.

If you have any questions, comments, etc, let me know.

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.


-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Finn Jorgensen
Sent: Wednesday, July 09, 2008 5:52 PM
To: don_at_seiler.us
Cc: oracle-l
Subject: Re: Using CONVERT DATABASE for endian change?

Don,

I've done a fair bit of research and work on this. This was in
preparation of moving from HP-UX on Itanium to Solaris sparc 64 bit.

You have to query V$DB_TRANSPORTABLE_PLATFORM and see if the endian
format is the same (big or small) of the 2 databases, which you say
they're not. That means you cannot do transportable databases. There
is no way (that I've been able to find) you can update the
"transportable list" as you say. I think you're stuck with
transportable tablespaces and having to recreate objects/users/perms
etc.etc.

Good luck.

Finn

On Wed, Jul 9, 2008 at 5:13 PM, Don Seiler <don_at_seiler.us> wrote:


> Good afternoon,

>

> I'm staring down a database migration from SPARC "Solaris[tm] OE

> (64-bit)" to x86_64 "Solaris Operating System (AMD64)".  Those names

> in quotes are from the v$transportable_platform and/or v$database

> platform_name field.  I'll come back to that in a minute.

>

> I've done a small test of a migration using transportable tablespaces

> and datapump and then using rman to convert the datafiles on the

> target platform.  I couldn't do tablespace conversion on the source

> platform because  "Solaris Operating System (AMD64)" wasn't listed in

> v$transportable_platform on that box.  (If anyone knows anything about

> that, I'd love to hear it. both are 10.2.0.2)  However this still

> leaves me needing to manually perform a great deal of other things.

>

> I've been reading about the CONVERT DATABASE command, specifically

> CONVERT DATABASE ON TARGET PLATFORM.  However from my reading and

> initial dbms_tdb.check_db() tests, it doesn't seem to support endian

> conversion.  Yet in the sample scripts I see in the tahiti doc [0], it

> does basically the same RMAN "CONVERT DATAFILE" that I did in my other

> tests, so I'm wondering why an endian conversion wouldn't be

> supported.  Performing CONVERT DATABASE would take care of a lot of

> work that I had been doing manually to this point.

>

> If anyone has any experience with CONVERT DATABASE and/or updating the

> V$TRANSPORTABLE_PLATFORM list, I'd love to know.

>

> [0] http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn003.htm#sthref1413

>

> --

> Don Seiler

> http://seilerwerks.wordpress.com

> ultimate: http://www.mufc.us

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 09 2008 - 18:31:43 CDT