Re: cross platform incremental backup on non exadata platform.
From: Mark Burgess <mark_at_burgess-consulting.com.au>
Date: Fri, 20 Mar 2015 08:27:52 +1100
Message-Id: <13E4EAF3-D952-433D-B332-7D1446A0CDE7_at_burgess-consulting.com.au>
Max,
>> On Tue, Mar 17, 2015 at 11:24 PM, fairlie rego <fairlie_r_at_yahoo.com> 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_at_gmail.com if you have any specific questions
>>
>>
>> Fairlie Rego
>> Senior Oracle Consultant
>> http://el-caro.blogspot.com/
>> M: +61 402 792 405
>>
>>
>>
>>
>> On Wednesday, 18 March 2015, 3:42, max scalf <oracle.blog3_at_gmail.com> wrote:
>>
>>
>> Thank you for the confirmation, i just wanted to make sure i was heading in right direction.
>>
>> Also the note says it is applicable for 10g+, so i guess i will find out how 10.2.0.5 will work.
>>
>> Thanks again.
>>
>> On Tue, Mar 17, 2015 at 10:18 AM, Stefan Koehler <contact_at_soocs.de> wrote:
>> Hi Max,
>> this note has changed and it is applicable for general Linux migrations now. I am just quoting from it.
>>
>> "The source system may be any platform provided the prerequisites referenced and listed below for both platform and database are met. The destination
>> system must be 64-bit Oracle Linux. The typical use case is expected to be migrating data from a big endian platform, such as IBM AIX, HP-UX, or
>> Solaris SPARC, to 64-bit Oracle Linux, such as Oracle Exadata Database Machine running Oracle Linux."
>>
>> As you can see the limitation is "destination system must be 64-bit Oracle Linux" nowadays. The previous phrase "The Cross Platform Incremental Backup
>> procedure described in this document is currently supported only when the destination system is Oracle Exadata Database Machine." was removed.
>>
>> … and yes the procedure works - it even worked before Oracle officially changed this MOS note. Martin Bach also did a webinar about this topic with a
>> corresponding demo (without Exadata): https://www.youtube.com/watch?v=4WOFjEDtLW8
>>
>> Best Regards
>> Stefan Koehler
>>
>> Freelance Oracle performance consultant and researcher
>> Homepage: http://www.soocs.de
>> Twitter: _at_OracleSK
>>
>> > max scalf <oracle.blog3_at_gmail.com> hat am 17. März 2015 um 16:01 geschrieben:
>> >
>> > Hello List,
>> >
>> > I was wondering if the below note is still applicable to exadata only or has anyone tried the below method on a non-exadata platform. We are trying
>> > to move a 15 TB database from AIX to Linux and thought this might be an interesting option to use....if anyone has done this on a non-exadata
>> > platform could you please give me some pointers?
>> >
>> > Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1)
>> >
>
Date: Fri, 20 Mar 2015 08:27:52 +1100
Message-Id: <13E4EAF3-D952-433D-B332-7D1446A0CDE7_at_burgess-consulting.com.au>
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_at_gmail.com> 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_at_yahoo.com> 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_at_gmail.com if you have any specific questions
>>
>>
>> Fairlie Rego
>> Senior Oracle Consultant
>> http://el-caro.blogspot.com/
>> M: +61 402 792 405
>>
>>
>>
>>
>> On Wednesday, 18 March 2015, 3:42, max scalf <oracle.blog3_at_gmail.com> wrote:
>>
>>
>> Thank you for the confirmation, i just wanted to make sure i was heading in right direction.
>>
>> Also the note says it is applicable for 10g+, so i guess i will find out how 10.2.0.5 will work.
>>
>> Thanks again.
>>
>> On Tue, Mar 17, 2015 at 10:18 AM, Stefan Koehler <contact_at_soocs.de> wrote:
>> Hi Max,
>> this note has changed and it is applicable for general Linux migrations now. I am just quoting from it.
>>
>> "The source system may be any platform provided the prerequisites referenced and listed below for both platform and database are met. The destination
>> system must be 64-bit Oracle Linux. The typical use case is expected to be migrating data from a big endian platform, such as IBM AIX, HP-UX, or
>> Solaris SPARC, to 64-bit Oracle Linux, such as Oracle Exadata Database Machine running Oracle Linux."
>>
>> As you can see the limitation is "destination system must be 64-bit Oracle Linux" nowadays. The previous phrase "The Cross Platform Incremental Backup
>> procedure described in this document is currently supported only when the destination system is Oracle Exadata Database Machine." was removed.
>>
>> … and yes the procedure works - it even worked before Oracle officially changed this MOS note. Martin Bach also did a webinar about this topic with a
>> corresponding demo (without Exadata): https://www.youtube.com/watch?v=4WOFjEDtLW8
>>
>> Best Regards
>> Stefan Koehler
>>
>> Freelance Oracle performance consultant and researcher
>> Homepage: http://www.soocs.de
>> Twitter: _at_OracleSK
>>
>> > max scalf <oracle.blog3_at_gmail.com> hat am 17. März 2015 um 16:01 geschrieben:
>> >
>> > Hello List,
>> >
>> > I was wondering if the below note is still applicable to exadata only or has anyone tried the below method on a non-exadata platform. We are trying
>> > to move a 15 TB database from AIX to Linux and thought this might be an interesting option to use....if anyone has done this on a non-exadata
>> > platform could you please give me some pointers?
>> >
>> > Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1)
>> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 19 2015 - 22:27:52 CET