cancel
Showing results for 
Search instead for 
Did you mean: 

Recover from SYSTEM01.DBF

Datki Iosif
Occasional Visitor

Recover from SYSTEM01.DBF

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
6 REPLIES
T G Manikandan
Honored Contributor

Re: Recover from SYSTEM01.DBF

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
Honored Contributor

Re: Recover from SYSTEM01.DBF

What message are you getting while starting Oracle server?

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
harry d brown jr
Honored Contributor

Re: Recover from SYSTEM01.DBF

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
Live Free or Die
Datki Iosif
Occasional Visitor

Re: Recover from SYSTEM01.DBF

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
Honored Contributor

Re: Recover from SYSTEM01.DBF

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
Occasional Visitor

Re: Recover from SYSTEM01.DBF

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.