Re: Database Migration to new Platform
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: "gajav@xxxxxxxxx" <gajav@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Apr 2013 18:34:03 -0700 (PDT)
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@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx>
To: Steve Harville <steve.harville@xxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx>
To: Sanjay Mishra <smishra_97@xxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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
http://SteveHarville.com
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.
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
