RE: Database Migration to new Platform

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Mon, 22 Apr 2013 21:28:48 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E3AFA0_at_M1EXCHMB11.mmi.local>

You can convert endians and use transportable tablespace sets. This limits downtime to copy time. I have done this with a 11g R2 10TB database in a few hours. You generate the TTS set, copy over and use RMAN to convert the endians, then you plug it into the prepared target database.

Josh C
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir Sent: Friday, April 19, 2013 12:32 PM
To: veeeraman_at_gmail.com; gajav_at_yahoo.com Cc: oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ram Raman Sent: Friday, April 19, 2013 3:25 PM
To: gajav_at_yahoo.com
Cc: oracle-l_at_freelists.org
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_at_yahoo.com>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
>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 22 2013 - 23:28:48 CEST