Home » RDBMS Server » Backup & Recovery » Oracle software desintall inadvertently
Oracle software desintall inadvertently [message #601920] Wed, 27 November 2013 06:06 Go to next message
azoracle
Messages: 8
Registered: November 2013
Junior Member
Hello!
We run on oracle10g in live in archivelog mode.
I desinstall infortuneltly oracle software and immedialetly i reinstall
and i create a tablespace pointing on the old datafile with reuse option on the server.
When i try to select from the tables, it tells me no view or table!!!!
How can i recover my data using the oracle old files: controlfile, redo and datafiles???

Please help me... Embarassed


Thanks u all and best regards.
Re: Oracle software desintall inadvertently [message #601922 is a reply to message #601920] Wed, 27 November 2013 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Oracle binaries and Oracle database are independent unless you put your database files inside Oracle home which is a bad idea.
If you didn't then you can reinstall Oracle and just start the database.
But if you now screwed your files reusing them in another database as it seems you did then you lost your database; I hope you have backup of these files or even database backups.

Regards
Michel
Re: Oracle software desintall inadvertently [message #601932 is a reply to message #601922] Wed, 27 November 2013 09:30 Go to previous messageGo to next message
azoracle
Messages: 8
Registered: November 2013
Junior Member
If i put in oracle home as before the crash, i do not have to recreate tablespaces and point to the existing datafiles.
what i did!!! the database would start normaly with the old data without creating myself the tablespaces??
Re: Oracle software desintall inadvertently [message #601942 is a reply to message #601932] Wed, 27 November 2013 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes.

Re: Oracle software desintall inadvertently [message #601981 is a reply to message #601942] Thu, 28 November 2013 01:59 Go to previous messageGo to next message
azoracle
Messages: 8
Registered: November 2013
Junior Member
So how Oracle recreate these tablespaces itself with all the data content? I thought i have to create it in my own!!! ouff
Re: Oracle software desintall inadvertently [message #601982 is a reply to message #601981] Thu, 28 November 2013 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Carefully read again my first post.
I said it is possible ONLY if you didn't put your database files inside the Oracle home.
If you didn't then there is nothing to create as everything is there.

Re: Oracle software desintall inadvertently [message #601986 is a reply to message #601982] Thu, 28 November 2013 02:42 Go to previous message
azoracle
Messages: 8
Registered: November 2013
Junior Member
ok Thank you!
Previous Topic: Partition table backup
Next Topic: Hot dmp backup + recovery
Goto Forum:
  


Current Time: Sun Sep 21 05:18:31 CDT 2014

Total time taken to generate the page: 0.07241 seconds