Re: Using CONVERT DATABASE for endian change?
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: don@xxxxxxxxx
- Date: Wed, 9 Jul 2008 17:52:28 -0400
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
