Re: Database Migration to new Platform
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 19 Apr 2013 06:47:30 -0700 (PDT)
Message-ID: <1366379250.39852.YahooMailNeo_at_web122104.mail.ne1.yahoo.com>
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.
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
Date: Fri, 19 Apr 2013 06:47:30 -0700 (PDT)
Message-ID: <1366379250.39852.YahooMailNeo_at_web122104.mail.ne1.yahoo.com>
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-lReceived on Fri Apr 19 2013 - 15:47:30 CEST