RE: Database Migration to new Platform

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>, "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 20 Apr 2013 02:04:16 +0000

Based on what I know, GG is not cheap. It is based on CPU licensing and you 
have to license both the source and the target. If you do not have any future 
use of GG then it may not be a viable option for you.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sanjay Mishra
Sent: Friday, April 19, 2013 9:47 PM
To: Christopher.Taylor2@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Database Migration to new Platform

Chris
My only issue here is hetergenous support for standby is not available for 
Solaris Sparc and Zlinux. May be I am reading wrong docs as otherwise this is 
very better option. Also never tried Standby for Raw device based Prinmary 
Database.

Sanjay


________________________________
 From: "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>
To: smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx 
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sanjay Mishra
Sent: Friday, April 19, 2013 7:55 AM
To: oracle-l@xxxxxxxxxxxxx
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

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


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


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


Other related posts: