Home » RDBMS Server » Backup & Recovery » New Install, What Version? (Windows 7 Enterprise, 32-bit)
New Install, What Version? [message #591823] Wed, 31 July 2013 11:59 Go to next message
abnk
Messages: 30
Registered: January 2012
Location: US
Member
Hi, all:


My old PC is no longer operational. The Oracle Database I had in it was 11g. I was able to recover these files:

CONTROL.DBF
SYSAUX.DBF
SYSTEM.DBF
TEMP.DBF
UNDOTBS1.DBF
USERS.DBF

My new PC operates on Windows 7 Enterprise, 32-bit.

My questions are:

1) Can I recover the above files in a new 12c installation using ORADIM?
2) Would you recommend 12c over 11gR2? I use this database for small test work; mainly testing procedures against small tables. I don't need a memory hog. I'd prefer to recover the data if possible, but if 12c is much more efficient than 11gR2, I don't mind recreating everything. On the other hand, if 11gR2 requires less resources, I'll stick with that.

Thank you.
Re: New Install, What Version? [message #591824 is a reply to message #591823] Wed, 31 July 2013 12:03 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
>1) Can I recover the above files in a new 12c installation using ORADIM?
no!
if those are the only files, you can not recover the DB. PERIOD!

[Updated on: Wed, 31 July 2013 12:04]

Report message to a moderator

Re: New Install, What Version? [message #591828 is a reply to message #591824] Wed, 31 July 2013 12:57 Go to previous messageGo to next message
abnk
Messages: 30
Registered: January 2012
Location: US
Member
Thank you. That simplifies my choice. Smile

While no longer a recovery matter at this point, would you recommend 12c or 11gR2 based on my stated needs above?
Re: New Install, What Version? [message #591834 is a reply to message #591828] Wed, 31 July 2013 13:04 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
sooner or later you'll need to use 12c, so why not start now?
Re: New Install, What Version? [message #591838 is a reply to message #591834] Wed, 31 July 2013 13:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
so why not start now?


Maybe to wait for the new bugs to be fixed.

Regards
Michel
Re: New Install, What Version? [message #591842 is a reply to message #591838] Wed, 31 July 2013 13:29 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
>Maybe to wait for the new bugs to be fixed.

if you don't use new features, then you should not hit new bugs.
Re: New Install, What Version? [message #591845 is a reply to message #591842] Wed, 31 July 2013 13:31 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You're optimistic. Smile

Regards
Michel
Re: New Install, What Version? [message #591851 is a reply to message #591845] Wed, 31 July 2013 13:58 Go to previous messageGo to next message
abnk
Messages: 30
Registered: January 2012
Location: US
Member
I'm running Windows 32-bit. I only see Windows 64-bit version of 12c. That further simplifies my choice. Smile

Thank you.
Re: New Install, What Version? [message #591853 is a reply to message #591851] Wed, 31 July 2013 15:18 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
abnk
I use this database for small test work; mainly testing procedures against small tables

If that's the case, your first choice might be Oracle Database Express Edition 11g Release 2.
Re: New Install, What Version? [message #593122 is a reply to message #591853] Wed, 14 August 2013 06:38 Go to previous messageGo to next message
gazzag
Messages: 299
Registered: November 2010
Location: Bristol, UK
Senior Member
Personally I wouldn't use the first release of any product. Stick with 11gR2 until 12cR2 comes along!
Re: New Install, What Version? [message #594192 is a reply to message #591823] Sun, 25 August 2013 21:28 Go to previous messageGo to next message
oracle_awen
Messages: 5
Registered: July 2012
Location: china
Junior Member

There isn't 12C for 32-bit so far.
But there are many cool new features in 12C.
RMAN enables you to transport data across platforms by using full and incremental backup sets In 12C.
Re: New Install, What Version? [message #594422 is a reply to message #594192] Wed, 28 August 2013 05:09 Go to previous messageGo to next message
gazzag
Messages: 299
Registered: November 2010
Location: Bristol, UK
Senior Member
I don't know, but I'd be surprised if Oracle brought out a 32-bit version of 12c. How many people are still using 32-bit Windows for hosting Oracle databases?
Re: New Install, What Version? [message #594425 is a reply to message #594422] Wed, 28 August 2013 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None that still has a support.

Regards
Michel
Re: New Install, What Version? [message #595061 is a reply to message #594422] Thu, 05 September 2013 15:45 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2207
Registered: May 2013
Location: World Wide on the Web
Senior Member
gazzag wrote on Wed, 28 August 2013 15:39
How many people are still using 32-bit Windows for hosting Oracle databases?


If you are talking about 11g R2, then I, and all my colleagues at home in their personal laptops still use 32-bit Windows.
Re: New Install, What Version? [message #595071 is a reply to message #595061] Fri, 06 September 2013 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think the question is about production databases not play ones.

Regards
Michel
Re: New Install, What Version? [message #595102 is a reply to message #595061] Fri, 06 September 2013 13:12 Go to previous messageGo to next message
EdStevens
Messages: 261
Registered: September 2013
Senior Member
Lalit Kumar B wrote on Thu, 05 September 2013 15:45
gazzag wrote on Wed, 28 August 2013 15:39
How many people are still using 32-bit Windows for hosting Oracle databases?


If you are talking about 11g R2, then I, and all my colleagues at home in their personal laptops still use 32-bit Windows.



Why?

Is it even possible to purchase 32-bit hardware any more?

So of the hardware is 64-bit, why run a 32-bit OS?
Re: New Install, What Version? [message #595104 is a reply to message #595102] Fri, 06 September 2013 13:30 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible but I don't think anyone will put his production on these ones.

Regards
Michel
Re: New Install, What Version? [message #595116 is a reply to message #595061] Fri, 06 September 2013 15:13 Go to previous message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
Lalit Kumar B wrote on Thu, 05 September 2013 21:45
gazzag wrote on Wed, 28 August 2013 15:39
How many people are still using 32-bit Windows for hosting Oracle databases?


If you are talking about 11g R2, then I, and all my colleagues at home in their personal laptops still use 32-bit Windows.
Many people are in this situation: they have laptops with 64bit CPUs (every Intel or AMD chip has been 64bit since, what, 2006 perhaps?) but they have 32bit Windows because that was what the OEMs distributed until very recently. The answer is to install Linux instead. Or if you must have Windows and don't want to pay for a 64bit Windows licence, enable the VTx and run 64bit Linux in a VirtualBox. That is what I've been doing on my old Vista laptop since I was given it six years ago.
Previous Topic: Uses of duplicate...for standby command
Next Topic: ORA-01578: ORACLE data block corrupted
Goto Forum:
  


Current Time: Mon Sep 01 21:44:00 CDT 2014

Total time taken to generate the page: 0.24619 seconds