Re: cross platform migration

Sad part is we do own licensing for another replication tool called DBVisit and have used that for migration for other system(non-sap system), but as these are SAP system the only way SAP supports its cross-platform migration(oracle-way) is by either doing cross platform transportable tablespace or using oracle's Golden gate. No other products are supported

_at_oscar,

Thanks for looking at that, i always tend to forget to check at edelivery.oracle.com. Looks like i will open a ticket with oracle and hopefully they can get me the software...otherwise moving 30TB of data using cross platform transportable tablespace will take long time...

On Sun, Feb 16, 2014 at 9:48 PM, Jinwen Zou <zjworacle_at_gmail.com> wrote:

> If you went down to logical apply path, some zero/real-time data
> integration/replication rivals of Goldengate might worth to have a look.
> Type "Oracle Goldengate vs " and plus another character [a-z] in Google
> search, Google will tip you the major rivals starting with that
> character.
>
> Shareplex from Quest (bought by DELL) who owns TOAD for Oracle as well, is
> one of the products used in one of my former company, it was used to
> replicate databases across data centers in high OLTP workload in same
> platform and same oracle version. However, I don't think cross
> platform/version will be problem.
>
>
> On Mon, Feb 17, 2014 at 1:21 PM, max scalf <oracle.blog3_at_gmail.com> wrote:
>
>> hello all,
>>
>> 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