Recover from SYSTEM01.DBF

[Datki Iosif]

Hello, I have a bip problem :( . I had installed Oracle on my computer, but someone re-installed the OS. I still have the old director 'oracle' and I've re-installed Oracle 8. I need to restore/recover data from old '\oradata\' folder. Any suggestions will be appreciated.
Thanx

[T G Manikandan]

Below are the requirements for restore,

1.The database should have been shutdown cleanly before re-installation

2.You have the same version of oracle installed.

check to see whether the controlfiles are present.

Just edit init.ora and show the patch to that instance controlfile.

Just do a
svrmgr>startup nomount
svrmgr>alter database mount
svrmgr>alter database open

revert on errors

[Sanjay Kumar Suri]

What message are you getting while starting Oracle server?

sks

[harry d brown jr]

What OS?

When you say folder, as in \oradata\ are you talking windows?

If windows, look for Norton recovery tools.

live free or die
harry

[Datki Iosif]

yeap, the OS is windows. One more question: I have an old backup (empty database) that I can restore, but I need to recover the data. Simply copying the systemo1.dbf and all files from old folder does not help me at all (I get an error when I try to open database)......

[T G Manikandan]

you cannot do that,

if that was windows and the database was shutdown cleanly before the re-installation,then just

create the same SID using

C:\oradim -new -sid -p .ora path> -intpwd

Then,open that init.ora and provide the path of the controlfiles.

Then do a startup.

if the database was not shutdown properly and you an trying to use those files,it wont work.

Then you should use the complete backup of all the files.you cannot restore from the present file structure.

[Datki Iosif]

thanx to everyone who posted for this thread. I've succeded. First of all, I've imported old backup (empty datbaase), then shutdown database, replacing oradata folder with old one, and then starting database.