Re: Database Migration to new Platform
Date: Fri, 19 Apr 2013 18:34:03 -0700 (PDT)
Message-ID: <1366421643.47805.YahooMailNeo_at_web122106.mail.ne1.yahoo.com>
Gaja
The Source Database is Raw Devices and so it can be copied using SAN copy and then has to be rman convert or TTS and currently it is going beyond the allocated downtime. Can you please provide more details keeping that existing environment is Raw devices
TIA
Sanjay
From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Friday, April 19, 2013 2:57 PM
Subject: Re: Database Migration to new Platform
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-l -- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 20 2013 - 03:34:03 CEST