OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 11g upgrade (Oracle 9i on HP)

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

11g upgrade [message #460145]

Wed, 09 June 2010 21:17

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have 9i database running on HP-UX and want to install 11g in a different oracle home and migrade the data from 9i to 11g. Can I use RMAN backup and restore? What are the things that i need to takecare of to migrate to 11g?
Thanks

Report message to a moderator

Re: 11g upgrade [message #460146 is a reply to message #460145]

Wed, 09 June 2010 21:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Can I use RMAN backup and restore?
Have you ever actually used RMAN to backup & restore any DB?

Report message to a moderator

Re: 11g upgrade [message #460159 is a reply to message #460146]

Wed, 09 June 2010 23:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Can I use RMAN backup and restore?

Is this a methof listed in Upgrade guide?

Quote:

What are the things that i need to takecare of to migrate to 11g?

Read the Upgrade guide

Regards
Michel

Report message to a moderator

Re: 11g upgrade [message #460647 is a reply to message #460145]

Sun, 13 June 2010 17:59

caprikar
Messages: 226
Registered: March 2007

Senior Member

My qestion is what is the best way of doing it?
1. install 9i on the new server and restore and recover using RMAN backup or
2. upgrade the existing database to 11g and install new 11g on the new server and use RMAN restore?
Thanks

Report message to a moderator

Re: 11g upgrade [message #460673 is a reply to message #460647]

Mon, 14 June 2010 01:37

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Best way depends on your environment, otherwise there would be no other way.
Read the guide and determine by yourself which one is best (against which measure?) for you.

Regards
Michel

Report message to a moderator

Previous Topic:	create as select
Next Topic:	Check DB listener and Read Only from DB query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 10:38:53 CST 2024