Re: Database Migration to new Platform

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 19 Apr 2013 18:37:18 -0700 (PDT)
Message-ID: <1366421838.4126.YahooMailNeo_at_web122106.mail.ne1.yahoo.com>



Chris
I think Hetergenous Standby does n't work for Solaris and Linux as per what I checked on the metalink. Moreover the Primary Database is raw device based. Do you think if this work as not able to find any supporting document

Sanjay



 From: "Christopher.Taylor2_at_parallon.net" <Christopher.Taylor2_at_parallon.net> To: smishra_97_at_yahoo.com; oracle-l_at_freelists.org Sent: Friday, April 19, 2013 3:33 PM
Subject: RE: Database Migration to new Platform  

It appears that both of these hosts are BIG ENDIAN so that's good.

I would probably etup a DUPLICATE database AS STANDBY on the secondary server, get it up and in standby mode, ship the archivelogs over and recover it to the latest greatest archivelog and then OPEN it over on the new host.  At that point you should be ready to do the UPGRADE using the upgrade instructions for 11g R2 on the new server.  (Or you could do the upgrade first and then do the above steps but I'd probably do it on the newer box)

Like this:

a.) Take RMAN backup on primary
b.) run DUPLICATE DATABASE as STANDBY (look up the syntax) on SECONDARY
c.) Once duplicate is done and is running as standby, ship archivelogs across to secondary and apply them
d.) once satisfied that archivelogs apply correctly then...
e.) generate final archivelogs on primary, shutdown primary
f.) ship archivelogs to secondary, apply them
g.) Either OPEN the database now or do the upgrade here and then open

Chris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Friday, April 19, 2013 7:55 AM
To: oracle-l_at_freelists.org
Subject: Database Migration to new Platform

Experts
I am looking for some suggestions based on your experience to move more than 7Tb database.

Current Environment : 11g R1 with Database file on Raw Devices and Operating system is Solaris Sparc New Environment : Linux on Ibm(Zlinux) with Oracle 11g R2

Company has decided to move the OS from Solaris to Linux and so 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.

TIA
Sanjay

--

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

http://www.freelists.org/webpage/oracle-l Received on Sat Apr 20 2013 - 03:37:18 CEST

Original text of this message