Home » RDBMS Server » Server Administration » fresh installation with old oradata
fresh installation with old oradata [message #574067] Sun, 06 January 2013 11:54 Go to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
we had a db working fine.....suddenly we face some os issue ....
we just take a proper shutdown of db ......
and then try restart os ...
os never comes up.
we have db installed in separate drive tahn C:\(where os reside)
..
..
now the os is instaaled again...
oracle is gone?
i have left with app folder and all the database file in other drive
..
i do the fresh oracle installation/...
now what things from the old app folder should i replace in new app folder created to get all the data back??
i guess only oradata folder and dbs folder will be enogh?

[EDITED by LF: removed a duplicate message posted by the OP (the only difference was that he had removed a question mark in a sentence Michel pointed to in the first reply, so - I removed it too, here.]

[Updated on: Mon, 07 January 2013 00:12] by Moderator

Report message to a moderator

Re: fresh installation with old oradata [message #574068 is a reply to message #574067] Sun, 06 January 2013 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear what you have.
It seems the punctuation you used is not correct.
For instance:

Quote:
i have left with app folder and all the database file in other drive?


Is this really a question? Do you really ask us if you left something in some drive?

Please, repost with clearer explanations.
Do not hesitate to SHOW us: use ls/dir...
Post your OS and version.
Post your Oracle version and edition.
Copy and paste what you do and get...

Regards
Michel
Re: fresh installation with old oradata [message #574070 is a reply to message #574068] Sun, 06 January 2013 12:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: fresh installation with old oradata [message #574071 is a reply to message #574070] Sun, 06 January 2013 12:22 Go to previous messageGo to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
Hi sir

I just want to know that if our os get reinstalled while the db is properly shutdown.
and in the fresh installation of os we reinstall the oracle.
how to get our data back?(we have the old app folder )
should we replace the app folder with new installed app folder?
or only the oradata folder and dbs folder inside the app folder?
Re: fresh installation with old oradata [message #574072 is a reply to message #574071] Sun, 06 January 2013 12:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how to get our data back?
sqlplus
/ as sysdba
startup
Re: fresh installation with old oradata [message #574073 is a reply to message #574072] Sun, 06 January 2013 12:28 Go to previous messageGo to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
i want my old data back which is in the app folder which is the older one.
with fresh installation we have new database created
Re: fresh installation with old oradata [message #574074 is a reply to message #574073] Sun, 06 January 2013 12:31 Go to previous messageGo to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
sir do u have phone number ?
can we call you ..to explain our problems.
Re: fresh installation with old oradata [message #574075 is a reply to message #574074] Sun, 06 January 2013 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sun, 06 January 2013 19:05
...
Do not hesitate to SHOW us: use ls/dir...
Post your OS and version.
Post your Oracle version and edition.
Copy and paste what you do and get...

Regards
Michel

Re: fresh installation with old oradata [message #574898 is a reply to message #574075] Wed, 16 January 2013 11:08 Go to previous message
ramanadba
Messages: 1
Registered: January 2013
Location: USA
Junior Member
Hi,

While you respond to Michel's questions, did you try starting up without changing anything in app folder? Based on your details I would assume your app folder is not impacted by OS re-installation and hence all you need to create your Oracle service (Windows) and set-up the environment as required.

You also said "You have created a new database"? does this mean you never tried bringing up the old DB?

Thanks
Ramana
Previous Topic: Regarding ASM
Next Topic: Data Block Corruption even after repaired
Goto Forum:
  


Current Time: Thu Mar 28 19:20:51 CDT 2024