reuse existing dbf file from another corrupted DB [message #278400] |
Sat, 03 November 2007 15:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
echai
Messages: 1 Registered: November 2007 Location: Hong Kong
|
Junior Member |
|
|
Dear all professionals,
I have an oracle DB installed in windows XP. But, few days ago, the windows XP was attacked by virus and cannot be startup back.
I have decided to buy a new harddisk and reinstall everything!
Now, I am installing a fresh windows XP and oracle DB in my "NEW" HardDisk. I would like to use back the old dbf files (which stores all the data) in the old harddisk which is storing the corrupted windows xp. Is it possible to do this?
Simply, my situation is...
my oracle DB is being stored in a windows that cannot startup now. But all the files in the Harddisk can be retrieve. Now, New Hard disk will be used and everything will be reinstall into new harddisk. Is it possible to copy the DB into new Harddisk and retrieve the old data
Simply, my question is,
can I have the original data in my new oracle db? Can I simply reuse back the old dbf files? Or, can I simply clone the old oracle DB into my new harddrive now??
Please kindly help! I have spent many days to fix it and I am very tired to keep fighting on this...
I don't wanna lost the data in the DB
Many Many Many Many Many Many Many Many Many Thanks!
|
|
|
Re: reuse existing dbf file from another corrupted DB [message #278404 is a reply to message #278400] |
Sat, 03 November 2007 15:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Can I simply reuse back the old dbf files? Or, can I simply clone the old oracle DB into my new harddrive now?
|
Yes.
The new database is useless. Drop it and its associated service.
Copy your files, all the database files (control file, redo logs, data, configuration files...) in the new hardisk, if possible at the same location (directories).
Then use oradim to create the service: oradim -new <sid> -startmode manual
Start the service if it is not already started.
Execute sqlplus "/ as sysdba" and try a startup.
If all files were copied in the same location, this should work.
If not, post (copy and paste) your SQL*Plus session here.
Regards
Michel
|
|
|
Re: reuse existing dbf file from another corrupted DB [message #278445 is a reply to message #278400] |
Sun, 04 November 2007 07:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Install new oracle through OUI and give the desired service name during installation.
When the database is created. Exit OUI.Shutdown the database.Stop the service.Overwrite every datafile,control file with the old files. Create a new password file and your database is ready.
|
|
|
Re: reuse existing dbf file from another corrupted DB [message #278451 is a reply to message #278445] |
Sun, 04 November 2007 07:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
No, it may create a service, if you ask to create a database, but it may not be the correct one it you don't have the same SID and all this is just useless when what you just have to do it is execute oradim.
Why do you want to create a database just to overwrite the files? Just create the service.
Regards
Michel
[Updated on: Sun, 04 November 2007 07:36] Report message to a moderator
|
|
|
Re: reuse existing dbf file from another corrupted DB [message #278452 is a reply to message #278400] |
Sun, 04 November 2007 07:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
In any case,the OP has to install oracle.Instead of dropping the new database created during installation,Wouldn't it work if he just overwrites the datafiles and control files.He gets the old database he was working on.
The SID is already created during installation and yes it should be the same as in the old control files.
Whats the need to run DBCA?
[Updated on: Sun, 04 November 2007 07:48] Report message to a moderator
|
|
|
|
|
|
Re: reuse existing dbf file from another corrupted DB [message #278456 is a reply to message #278455] |
Sun, 04 November 2007 08:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
With the XP, db creation is mandatory at installation time and you don't have the choice in SID.
With other edition, db creation is optional at installationb (and I never let Oracle create my database from default one) and you can choose your SID, and Oracle service name depends on SID.
Regards
Michel
|
|
|