Re: cross platform migration

Looks like GOLDEN GATE is in the picture for our migration now, but one thing i am confused about is the supported version...our database(version 10.2.0.4) is on hp-ux paric 11.11....and we are going to go to linux(DB version still the same)...so my question is, can i still install golden gate on hp-ux 11.11, i am unable to find any golden gate version for that system or do i just have to open a ticket with oracle support and ask for a older version of Golden gate that support our 10.2.0.4 DB on HP 11.11......if i cannot use golden gate, what other options do i have?

On Wed, Feb 12, 2014 at 7:29 PM, Svetoslav Gyurov <softice_at_gmail.com> wrote:

> Hi Max,
>
> Sorry for not making clear. It's simply because you won't be able to mount
> the filesystem on the "other side" once you split the BCV. The CDC is a
> feature of the Veritas Volume Manager which provides you with a foundation
> for moving data between different systems within a heterogeneous
> environment. Just type *sfhas_solutions_601_lin* in google and download
> the first pdf which is *Veritas Storage Foundation(tm) and High Availability
> Solutions 6.0.1 Solutions Guide - Linux*
>
> Sve
>
>
>
> On Thu, Feb 13, 2014 at 1:13 AM, Jack van Zanen <jack_at_vanzanen.com> wrote:
>
>> Hi,
>>
>>
>> One other gotcha is that Oracle RMAN convert can not handle clusters with
>> endian conversions.
>> We are working with support at the moment to get a fix for it, but it has
>> been a while now...
>>
>> Jack
>>
>> Jack van Zanen
>>
>> -------------------------
>> This e-mail and any attachments may contain confidential material for the
>> sole use of the intended recipient. If you are not the intended recipient,
>> please be aware that any disclosure, copying, distribution or use of this
>> e-mail or any attachment is prohibited. If you have received this e-mail in
>> error, please contact the sender and delete all copies.
>> Thank you for your cooperation
>>
>>
>> On Thu, Feb 13, 2014 at 12:09 PM, max scalf <oracle.blog3_at_gmail.com>wrote:
>>
>>> Sve,
>>>
>>> Golden Gate is out of budget here and also SAP dose not support that
>>> part. We were told to make this happen within the current license
>>> agreement.
>>>
>>> Please excuse my knowledge here about BCV splits. But lets say i do not
>>> have BCV splits in place my process would be to
>>>
>>> 1. put tablespace in read only mode
>>> 2. export metadata(transportable tablespace=y)
>>> 3. copy the export files and also copy the data files from source to
>>> target
>>> 4. run RMAN convert command on target
>>> 5. import the medata
>>>
>>> so my question is why do i need that extra step of conversion the
>>> endiness at storage level(CDS)...is that a standard thing? Our storage
>>> admins are the one who takes care of the BCV splits and i am hoping if we
>>> are going to use the BCV splits then i dont need that CDS thing you talked
>>> about earlier, or if we do, is that a standard tool given by storage
>>> vendors(i believe our vendor is EMC) or do i need special licensing for it?
>>>
>>>
>>> On Wed, Feb 12, 2014 at 6:55 PM, Svetoslav Gyurov <softice_at_gmail.com>wrote:
>>>
>>>> Hi Max,
>>>>
>>>> Indeed, you need to convert the file system first which will save you
>>>> copying all the 30TB of data and then you need to run RMAN convert.
>>>>
>>>> Are you considering GoldenGate as an option or it would be out of
>>>> budget ?
>>>>
>>>> Sve
>>>>
>>>>
>>>> On Thu, Feb 13, 2014 at 12:44 AM, max scalf <oracle.blog3_at_gmail.com>wrote:
>>>>
>>>>> Thanks Sve, I was under the impression that i could just take the
>>>>> mount point from HP and mount it over to linux as i oracle was going to do
>>>>> the RMAN Conversion process for me. But you are saying i need to do it at
>>>>> the storage level(CDS) and then also do it at database level ?
>>>>>
>>>>>
>>>>> On Wed, Feb 12, 2014 at 5:06 PM, Svetoslav Gyurov <softice_at_gmail.com>wrote:
>>>>>
>>>>>> Hi Max,
>>>>>>
>>>>>> Yeah, BCVs has been my favorite when we need to clone or refresh the
>>>>>> DEV/UAT environments. However these platforms still have different
>>>>>> endianness and you need to convert the file system itself. This can be done
>>>>>> using the Cross-platform Data Sharing (CDS) featureof Symantec's Veritas
>>>>>> Storage Foundation software which will allow you to create portable data
>>>>>> containers (PDC) and mount the volumes on different platforms. I remember
>>>>>> seeing one or two years ago similar presentation (maybe OOW presentations)
>>>>>> about using this approach and greatly reducing the time for migration.
>>>>>>
>>>>>> Regards,
>>>>>> Sve
>>>>>>
>>>>>>
>>>>>> On Wed, Feb 12, 2014 at 10:42 PM, max scalf <oracle.blog3_at_gmail.com>wrote:
>>>>>>
>>>>>>> Sve/All,
>>>>>>>
>>>>>>> Thanks for you input. i guess RMAN incremental
>>>>>>> backup/restore/recover is out of the picture and so is data guard. We are
>>>>>>> going from 10.2.0.4 to 10.2.0.4 (due to some SAP kernel restrictions)
>>>>>>>
>>>>>>> For that 30TB database all that Data is usable(cannot be
>>>>>>> purge/archived) so we have to move that to a platform, but one thing i can
>>>>>>> think of is for the big database we do have BCV split/mirror in place, can
>>>>>>> i somehow use that?
>>>>>>>
>>>>>>> For example
>>>>>>> 1. on source DB put all tablespace in read only mode and start meta
>>>>>>> data export(transportable tablespace=y)
>>>>>>> 2. once in read only mode take a BCV split(in parallel) of all the
>>>>>>> datafile mount points and mount it on target
>>>>>>> 3. once the file system is mounted on target, start the RMAN
>>>>>>> conversion process (how could would this take, is this depended on DB size
>>>>>>> or what?)
>>>>>>> 4. once conversion is completed, start the import of the metadata
>>>>>>>
>>>>>>> if above can be used, only concern i have is we have probably about
>>>>>>> 2k - 3K datafiles(spread across 100's of mount points) or so and i might
>>>>>>> some how miss doing the convert process in RMAN for those data file or miss
>>>>>>> them while doing the import part(where i believe i have to give datafile =
>>>>>>> locations of all files)..any pointers here ?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Feb 12, 2014 at 3:38 PM, Svetoslav Gyurov <softice_at_gmail.com
>>>>>>> > wrote:
>>>>>>>
>>>>>>>> Hi Max,
>>>>>>>>
>>>>>>>> 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