Re: Database Migration to new Platform
Date: Fri, 19 Apr 2013 11:57:46 -0700 (PDT)
Message-ID: <1366397866.87944.YahooMailNeo_at_web180902.mail.ne1.yahoo.com>
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
From: Sanjay Mishra <smishra_97_at_yahoo.com> To: Steve Harville <steve.harville_at_gmail.com> Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Friday, April 19, 2013 6:47 AM
Subject: Re: Database Migration to new Platform
Steve
Thanks for the update and thought of this option and found that smallest database which is around 1 TB took around 5 hr for table/Indexes. Management is looking for less thant 5-6 hrs downtime if required.
Sanjay
From: Steve Harville <steve.harville_at_gmail.com> To: Sanjay Mishra <smishra_97_at_yahoo.com> Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Friday, April 19, 2013 9:03 AM
Subject: Re: Database Migration to new Platform
If you have a fast network you can import using a network link. Create the new database with preallocated tablespaces. Both databases will be up during the datapump import. Adjust the parallelism to maximize throughput.
More Info: http://steveharville.wordpress.com/2012/08/26/migrating-to-different-endianness/
Steve Harville
need suggestion to make the Move with least downtime. Can someone suggest the practical experience which anyone used for such scenario or what they think is technically feasible.
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 19 2013 - 20:57:46 CEST