Re: cross platform incremental backup on non exadata platform.
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: Martin Bach <development@xxxxxxxxxxxxxxxxx>
- Date: Fri, 20 Mar 2015 15:52:33 +0000
Hello,
I developed my own method based on MOS note and Martin post.
http://oracleprof.blogspot.ie/2014/08/crossplatform-transportable-tablespaces.html
Basically I was using a existing data file backup to start conversion
process and then end up with
TTS export/import.
If you want to clone production and then migrate clone DB into Linux -
Delphix has a solution which can help you save time and resources there.
http://blog.delphix.com/kyle/2014/delphix-unix-linux-oracle-conversion/
regards,
Marcin
On Fri, Mar 20, 2015 at 8:24 AM, Martin Bach <development@xxxxxxxxxxxxxxxxx>
wrote:
> Hi Max,
>
> +1 on the previous post. In fact the MOS document stated something about
> ERP systems with large dictionaries when I last looked at it. The metadata
> export of those can take a lot of time while your tablespaces to be
> migrated are read-only. That can work against your downtime window. If you
> want to pursue the x-platform TTS + incremental backup route then I'd
> suggest you clone production and test the export before spending too much
> time on other tasks.
>
> Hope this helps,
>
> Martin
>
> On 19/03/15 22:27, Mark Burgess wrote:
>
> Max,
>
> Yes have used this method several times for EBS. You need to allow a
> number of hours for the metadata export/import which depending on your
> infrastructure could be anywhere in the region of 8hrs + just for this data
> pump import.
>
> Regards,
>
> Mark
>
> On 20 Mar 2015, at 2:53 am, max scalf <oracle.blog3@xxxxxxxxx> wrote:
>
> Hello List,
>
> I was wondering if anyone has done this on oracle EBS or SAP system or
> something that creates 1000's of objects ?
>
> On Tue, Mar 17, 2015 at 11:24 PM, fairlie rego <fairlie_r@xxxxxxxxx>
> wrote:
>
>> We have used this method to migrate a 20 odd TB database from Sparc
>> Solaris to Exadata with a downtime of under 2 hours from 10.2.0.3 to
>> 11.2.0.3 in 2012.
>>
>> i.e Without this method we would not be able to meet the outage window
>> stipulated by the business
>>
>> However we hit quite a few issues (and we got fixes/workarounds for all
>> of them)
>>
>> Please drop me an email on fairlie.rego@xxxxxxxxx if you have any
>> specific questions
>>
>>
>>
>> *Fairlie Rego *Senior Oracle Consultant
>> http://el-caro.blogspot.com/
>> M: +61 402 792 405 <%2B61%20402%20792%20405>
>>
>>
>
>
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
Other related posts:
