OraFAQ Forum: Server Administration » Migrating and upgrade DB to new server

Home » RDBMS Server » Server Administration » Migrating and upgrade DB to new server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migrating and upgrade DB to new server [message #385139]

Fri, 06 February 2009 09:50

mjohnson311
Messages: 2
Registered: February 2009

Junior Member

We are going to be migrating and upgrading one of our Oracle DBs.
Current server is W2k, 32bit, Oracle 9.2.0.x
New server will be W2k3, 64bit, Oracle 10g.

Any suggestions? PDFs?... Almost everything I've read talks about one of these 'issues' (32->64bit or new hardware or...) but not all at once.

Thanks.
Mike

Report message to a moderator

Re: Migrating and upgrade DB to new server [message #385140 is a reply to message #385139]

Fri, 06 February 2009 09:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>We are going to be migrating and upgrading one of our Oracle DBs.
While you are at it I suggest upgrading the underlying application so you change 4 things at once to hit a home run.

Changing hardware
Changing OS
Changing Oracle version

When something does not work the same as before, how/where will you look for the difference & cause?

How much application down time do you have for this switchover?
How big is the original database?
What mechanism do you plan on using to get from where you are onto the new environment?

Report message to a moderator

Re: Migrating and upgrade DB to new server [message #385434 is a reply to message #385140]

Mon, 09 February 2009 10:44

mjohnson311
Messages: 2
Registered: February 2009

Junior Member

DB size is about 200GB. The DB/redo/archive logs are located on SAN luns. We can utilize our SAN snapshot technology to easily move the data to the new system. (thats the easy part)
Would it make more sense to install 9i x64 on the new system and upgrade to 10g at a later date? In that case what would I have to do to oracle (32bit->64bit)?

Report message to a moderator

Re: Migrating and upgrade DB to new server [message #385437 is a reply to message #385139]

Mon, 09 February 2009 11:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

How much application down time do you have for this switchover?
What mechanism do you plan on using to get from where you are onto the new environment?

There is a NOTE on Metalink which describes steps to "convert" an instance between 32-bit & 64-bit.

In my opinion, you'd be asking for problems trying to go directly from V9 32-bit to V10 64-bit; via the UPGRADE path.
If I were doing the UPGRADE, I'd install both 32-bit & 64-bit V10; upgrade V9 32-bit to V10 32-bit & then switch to 64-bit.

You could export from V9 32-bit & import into V10 64-bit directly.

Report message to a moderator

Re: Migrating and upgrade DB to new server [message #385622 is a reply to message #385437]

Tue, 10 February 2009 05:15

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I'd be very tempted to do the whole thing via an Export.

Report message to a moderator

Previous Topic:	Trouble with DCA
Next Topic:	Ora- 12535: operation timed out error.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:47:22 CST 2024