OraFAQ Forum: Server Administration » Oracle DB Server Migration Checklist

Home » RDBMS Server » Server Administration » Oracle DB Server Migration Checklist (Oracle 10gR2 - Linux)

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

Oracle DB Server Migration Checklist [message #550720]

Wed, 11 April 2012 21:22

Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines

Junior Member

Hello everyone!

We will be having a meeting with our client regarding their Database Server Migration (They are planning to buy a new server). Their current database is Oracle 10gR2, they will not upgrade to 11g, they just plan to migrate to a new more powerful machine.

I was planning to ask the following questions.
1. Specifications of the current server and the new one.
2. Operation system (I think they will use same OS, just an updated one)
3. Can the business afford full downtime on current servers?
4. Size of the DB, because it can take hours to move large files.

Is there anything more? And is there documentation regarding Server Migration (Change of machine only, not database upgrade or anything, I'm trying to search for it though)

Thanks! Smile

Report message to a moderator

Re: Oracle DB Server Migration Checklist [message #550721 is a reply to message #550720]

Wed, 11 April 2012 22:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I'd setup Data Guard (DG) or roll my own DG between the two systems,
so total down time would be less than a few minutes at cut over time.

Report message to a moderator

Re: Oracle DB Server Migration Checklist [message #550722 is a reply to message #550721]

Wed, 11 April 2012 22:29

Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines

Junior Member

Thanks! I don't think they will use Data Guard.. It is not on their option. Smile

Report message to a moderator

Re: Oracle DB Server Migration Checklist [message #550723 is a reply to message #550722]

Wed, 11 April 2012 22:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It is not on their option.
any other alternative only increases down time; which is OK by me.

Report message to a moderator

Re: Oracle DB Server Migration Checklist [message #550737 is a reply to message #550723]

Thu, 12 April 2012 01:21

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

An RMAN duplicate can be almost as fast a cut over as Data Guard, and doesn't need Enterprise Edition licences. You would still need to check with Oracle whether you would need to license both machines.

Report message to a moderator

Re: Oracle DB Server Migration Checklist [message #550744 is a reply to message #550737]

Thu, 12 April 2012 01:49

Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines

Junior Member

Are you talking about this?
Database Duplication with RMAN
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconc2.htm#i1006532

I see.. I think their options were FULL EXP/IMP, Expdp/Impdp, and RMAN.
The thing is that I want to test it before applying things in their production database server, but the problem is that they decided to use AIX 6.1 Operating System.. And I think this one will be needing an IBM machine (PowerPC processor?), we only have 32-bit and 64-bit here.. I think virtual machine will not work either.. Sad

Report message to a moderator

Previous Topic:	Error message in oracle scheduler
Next Topic:	Schema Comparing tool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:31:53 CDT 2024