WG: AW: Re: convert big endian to medium endian

From: "ahmed.fikri@xxxxxxxxxxx" <ahmed.fikri@xxxxxxxxxxx>
To: oracle list <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 7 Feb 2020 19:11:41 +0100 (CET)

------------------------------------------------------------------------
Gesendet mit der Telekom Mail App
<https://kommunikationsdienste.t-online.de/redirects/email_app_android_sendmail_footer>

--- Original-Nachricht ---
Von: ahmed.fikri@xxxxxxxxxxx
Betreff: AW: Re: convert big endian to medium endian
Datum: 07.02.2020, 19:09 Uhr
An: gogala.mladen@xxxxxxxxx

hi mladen,

the important things is the source is aix (big endian) and target db is
linux with whatever coding but not a big endian. We have different encoding
from src and trgt. And I thinks all this available tools like RMAN etc.
just prevent a better understanding of Oracle db.

So I know what endian format is and their history (I claim)
And I know the Oracle architecture (I claim)

so from my understanding I want to know why can I not migrate a database
from aix to linux without using XTTS or RMAN.

By using XTTS I should export the metadata and this takes for some reason
that I don't know 3 days and 4 hours.
So for me the most important things must I for this task use datapump?

If the export of the metadata would take only 4 or 8 hours I will be very
happy and I would never do this research (and I will not learn new things)

Thanks and Regards
Ahmed

------------------------------------------------------------------------
Gesendet mit der Telekom Mail App
<https://kommunikationsdienste.t-online.de/redirects/email_app_android_sendmail_footer>

--- Original-Nachricht ---
Von: Mladen Gogala
Betreff: Re: convert big endian to medium endian
Datum: 07.02.2020, 18:53 Uhr
An: Clay.Jackson@xxxxxxxxx
Cc: oracle list

Medium endian?  Does that mean that the most significant bit is in the
middle of the word? I am always keen to fight the battle of the Little Big
Endian.

Mladen Gogala
Oracle Consultant
Tel:(347) 321-1217

On Fri, Feb 7, 2020, 11:56 AM Clay Jackson (cjackson) <
Clay.Jackson@xxxxxxxxx <mailto:Clay.Jackson@xxxxxxxxx> > wrote:

  AFAIK:

  The only way this would work would be with transportable tablespaces;
  either using the tablespaces, or RMAN (MOS 2013271.1).

  There’s no “silver bullet” for this…



  IMHO, your best choice is export/import with some sort of replication
  solution to help minimize downtime.



  Clay Jackson

  Database Solutions Sales Engineer

  clay.jackson@xxxxxxxxx <mailto:clay.jackson@xxxxxxxxx>

  office  949-754-1203  mobile 425-802-9603



  From: oracle-l-bounce@xxxxxxxxxxxxx
  <mailto:oracle-l-bounce@xxxxxxxxxxxxx> <oracle-l-bounce@xxxxxxxxxxxxx
  <mailto:oracle-l-bounce@xxxxxxxxxxxxx> > On Behalf Of
  ahmed.fikri@xxxxxxxxxxx <mailto:ahmed.fikri@xxxxxxxxxxx>
  Sent: Friday, February 7, 2020 6:02 AM
  To: oracle list <oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
  >
  Subject: convert big endian to medium endian



  CAUTION: This email originated from outside of the organization. Do not
  follow guidance, click links, or open attachments unless you recognize
  the sender and know the content is safe.



  Hi all,

  I want to test (I hope this weekend) following:
  1 from 12c Db on AIX (big endian) I will create a cold backup
  2 on Oracle linux (medium endian) I will create a new db using the cold
  backup from point 1
  3 somehow I should convert the files from point 1 in medium endian

  is this possible?

  I don't want to use XTTTS and exporting the metadata using data pump.

  Kind Regards
  Ahmed

  ----------------------------------------------------------------------

  Gesendet mit der Telekom Mail App

<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fkommunikationsdienste.t-online.de%2Fredirects%2Femail_app_android_sendmail_footer&data=02%7C01%7Cclay.jackson%40quest.com%7C64f783c590674021465708d7abd6f65f%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637166812055140872&sdata=bZxDwMzcr4BMw4sNtCgEmIJQZaxyW%2FmdgLwvGevKm%2Bc%3D&reserved=0>

WG: AW: Re: convert big endian to medium endian

Other related posts: