Re: Database Migration to new Platform
- From: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Apr 2013 16:18:54 -0700 (PDT)
Hi All,
Just in case you are not aware of the following:
The RMAN CONVERT command converts data files and tablespaces between platforms,
even different endians. This allows TTS to move data between supported
platforms.
http://www.oracle-base.com/articles/10g/rman-enhancements-10g.php#cross_platform_tablespace_conversion
Only a full database conversion is not possible between endians. That doesn't
stop a piece-by-piece move though.
Thanks to Tim Hall for pointing it out.
Cheers,
Gaja Krishna Vaidyanatha,
CEO & Founder, DBPerfMan LLC
http://www.dbperfman.com
http://www.dbcloudman.com
Phone - +1 (650) 743-6060
LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha
Co-author: Oracle Insights:Tales of the Oak Table -
http://www.apress.com/9781590593875
Primary Author: Oracle Performance Tuning 101 - http://www.amzn.com/0072131454
Enabling Cloud Deployment & Management for Oracle & Big Data
________________________________
From: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>
To: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>; "veeeraman@xxxxxxxxx"
<veeeraman@xxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, April 19, 2013 1:39 PM
Subject: Re: Database Migration to new Platform
Hi Ram,
As Amir has already pointed out, endian difference is not an issue for
Transportable Tablespaces. We have done TTS migrations from HP-UX to Linux on
x86/x86-64 with no issues. Again, according to the Wiki page -
(http://en.wikipedia.org/wiki/Endianness), Linux on x86/x86-64 is little endian
versus HP-UX which is big endian.
Cheers,
Gaja
Gaja Krishna Vaidyanatha,
CEO & Founder, DBPerfMan LLC
http://www.dbperfman.com
http://www.dbcloudman.com
Phone - +1 (650) 743-6060
LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha
Co-author: Oracle Insights:Tales of the Oak Table -
http://www.apress.com/9781590593875
Primary Author: Oracle Performance Tuning 101 - http://www.amzn.com/0072131454
Enabling Cloud Deployment & Management for Oracle & Big Data
________________________________
From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
To: "veeeraman@xxxxxxxxx" <veeeraman@xxxxxxxxx>; "gajav@xxxxxxxxx"
<gajav@xxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, April 19, 2013 12:32 PM
Subject: RE: Database Migration to new Platform
The endian difference is not compatible for Transportable Databases; it is
compatible for TTS.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ram Raman
Sent: Friday, April 19, 2013 3:25 PM
To: gajav@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Database Migration to new Platform
Gaja
For TTS, doesnt the endianness of the platforms come into account? Linux is
Little endian and Solaris is big endian. I thought they would not be
compatible for TTS.
Ram
On Fri, Apr 19, 2013 at 1:57 PM, Gaja Krishna Vaidyanatha
<gajav@xxxxxxxxx>wrote:
> Hi Sanjay,
> May I suggest transportable tablespaces for this. This way you are limited
> purely by network bandwidth/throughput for file transfers and nothing else.
> And yes it is supported across OS platforms.
>
> Cheers,
>
> Gaja
>
>
> Gaja Krishna Vaidyanatha,
> CEO & Founder, DBPerfMan LLC
> http://www.dbperfman.com
> http://www.dbcloudman.com
>
> Phone - +1 (650) 743-6060
> LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha
>
> Co-author: Oracle Insights:Tales of the Oak Table -
> http://www.apress.com/9781590593875
> Primary Author: Oracle Performance Tuning 101 -
> http://www.amzn.com/0072131454
> Enabling Cloud Deployment & Management for Oracle & Big Data
>
>
>
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
