Home » RDBMS Server » Server Administration » 10g vs 11g
10g vs 11g [message #523402] Sat, 17 September 2011 13:45 Go to next message
gkrishn
Messages: 487
Registered: December 2005
Location: Putty a dark screen
Senior Member
I have to move a database from 10.2.0.4(solaris 9) to a 11.2.0.2(Solaris 10) . 11g shell database is ready .

Its a 400GB database. what would be easier approach .Any suggestions.

Re: 10g to 11g [message #523405 is a reply to message #523402] Sat, 17 September 2011 14:21 Go to previous messageGo to next message
BlackSwan
Messages: 22690
Registered: January 2009
Senior Member
answer depends upon downtime/data availability requirements.
One approach would be to trash the "shell database" & do an RMAN backup from Solaris 9, restore onto Solaris 10 & invoke DBUA.
Re: 10g to 11g [message #523418 is a reply to message #523402] Sun, 18 September 2011 04:04 Go to previous messageGo to next message
John Watson
Messages: 4489
Registered: January 2010
Location: Global Village
Senior Member
Have you read the upgrade guide? (Correct answer: "yes")
http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/toc.htm
Your choice of method will be informed by several factors. For, example: you can use Data Pump, but unless you have Enterprise Edition licenses you can't use parallel processes, which will impact on downtime. Or you can use BS's method, which might be faster, but doesn't re-organize anything.
There are several other methods, each with advantages and disadvantages.
Re: 10g to 11g [message #523435 is a reply to message #523418] Sun, 18 September 2011 12:13 Go to previous messageGo to next message
Kevin Meade
Messages: 1936
Registered: December 1999
Location: Connecticut USA
Senior Member
So as you can see, there are many methods to choose from. You must:

1) know the methods to choose from
2) know the pluses and minuses of each method
3) match the various methods to your requirements (database size, downtime tolerance, prep time, 
familiarity with each method, downgrade strategy if things go bad, synchronization strategy till cutover, etc.)
4) practice makes perfect

I just moved a 150GB database from 9i to 11g EXADATA2 using insert /*+ append */ select *... It took about 4 hours to do the basic data move. But this is not for everyone. For example:

1) how do I know I moved everything
2) did I get all the data
3) how did I handle characterset conversion between databases (CSSCAN is part of it)
4) lots of other questions

This method worked for me, but requires me to do lots of prep work before hand. I'd say I prepared for a week before actually doing it. And the application area I am doing this for will need about a week or maybe two to check it all out before they are satisified.

I am not suggesting you do what I did. Only pointing out the need to match your move strategy to your needs which implies of course that you have some idea of your needs.

Kevin

[Updated on: Sun, 18 September 2011 12:31] by Moderator

Report message to a moderator

10g vs 11g [message #530800 is a reply to message #523402] Thu, 10 November 2011 12:44 Go to previous messageGo to next message
thinksoft14
Messages: 3
Registered: October 2009
Location: Lahore, Pakistan
Junior Member
Dear Friend
I am working on 10g 2nd release almost 3 years
there are lot of issues/bugs in 10g which are fixed in 11g.

some of them are given below
1. performance issue
2. Registration with Windows 7
3. Reports problem when you will open through internet etc.

I have experience on both releases, it is best to use 11.0.0.2.0 atleast or greater.

Thanks
Rai Qaiser Hussain

[Updated on: Thu, 10 November 2011 15:02] by Moderator

Report message to a moderator

Re: 10g vs 11g [message #530803 is a reply to message #530800] Thu, 10 November 2011 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Do NOT hijack a topic with your question
2/ Define "best"

Regards
Michel
Re: 10g vs 11g [message #530805 is a reply to message #530803] Thu, 10 November 2011 12:56 Go to previous messageGo to next message
thinksoft14
Messages: 3
Registered: October 2009
Location: Lahore, Pakistan
Junior Member
Sir,
I did't ask any quesion but try to answer the question first time on this forum.

any wrong written?
kindly guide me if i did so.

Regards,
Rai Qaiser Hussain
Re: 10g vs 11g [message #530815 is a reply to message #530805] Thu, 10 November 2011 14:58 Go to previous message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, it was an answer? I didn't understand it. Sorry. Sad

Regards
Michel
Previous Topic: Gather schema statistics
Next Topic: Upgrade from 10g to 11g
Goto Forum:
  


Current Time: Fri Aug 22 14:39:49 CDT 2014

Total time taken to generate the page: 0.07723 seconds