Re: cross platform migration

My comments are inline, I assume you are migrating 10.2.X to 11.2.X ?

On Wed, Feb 12, 2014 at 8:54 PM, max scalf <oracle.blog3_at_gmail.com> wrote:

> Hello List,
>
> I have a project that is going to get started soon and i wanted to get
> some Pointers with regards to it. Please excuse my knowledge, as i am from
> SQL Server background and a seasonal oracle DBA. Project is to move our
> DB(multiple DB size from 1TB - 30TB) from hp-ux pa risc to RHEL. We have
> quite a few restriction in options as our app is SAP :-( . Couple of SAP
> notes i read suggested that we can use use cross platform transportable
> tablespace, which is what i am planning to do as well. I wanted to find
> out couple of things from the list
>
>
> 1. First of all if anyone has done this(on a SAP system), if so any
> gotcha
> 2. To reduce the down time i was planing to do a restore ahead of the
> cut over(lets say 3 days in advance) and then keep applying archive log
> until the day of cut over. Is that even possible for this situation (as i
> have to do RMAN Convert of the datafiles and then keep applying logs)
>
> Nope, you cannot restore/recover on a mixed platforms.

>
> 1. i cannot do transportable DATABASE, as i am going from big
> endianess to little( i believe #2 is possible here, as i read this doc<http://www.pythian.com/blog/howto-oracle-cross-platform-migration-with-minimal-downtime/>
> )
>
> Correct, they should be having the same same endian and you are migrating
from Big to Little.

> 1. I read an option some place that mentioned i could have
> heterogeneous data guard setup for this migration, but when i read MOS doc
> ID 413484.1, i do not think hp ux to RHEL Data guard is supported or
> have i gotten that wrong.
>
> Indeed, it is not:

RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1)

> 1. any other recommendation in general due to the size of our DB. The
> one i am worried about is our 30TB DB which takes about 18 hours to do
> weekly Level 0 backup and customer wants to do the migration in less than
> 10 hours
>
> Does all the 30TB db having operational data ? Are there any read only or
archive tablespaces ?

> 1. is cross platform transportable tablespace a bad idea as SAP
> creates thousands and thousands of objects in the database and the metadata
> would be too much to export/import
>
> I can't think of a limitation of that one. You might export you metadata
in parallel and also exclude statistics to improve the time. You problem here would be the time it takes to copy 30TB over the new platform and then convert them.

GoldernGate of course is the holly grail. Quick look on MOS shows that HP-UX PARISC is supported platform for Oracle GoldenGate 11.2.1.0.6.

Regards,
Sve

> I would really appreciate some pointers.
>
> Thanks,
> Max
>

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