Home » RDBMS Server » Server Administration » 11g upgrade (Oracle 9i on HP)
11g upgrade [message #460145] Wed, 09 June 2010 21:17 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68729
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 09:33:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.