topic Re: Recover from SYSTEM01.DBF in Operating System - Microsoft

Recover from SYSTEM01.DBF

Datki Iosif — Mon, 03 May 2004 06:30:05 GMT

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

Re: Recover from SYSTEM01.DBF

T G Manikandan — Mon, 03 May 2004 06:51:17 GMT

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

Re: Recover from SYSTEM01.DBF

Sanjay Kumar Suri — Mon, 03 May 2004 06:52:59 GMT

What message are you getting while starting Oracle server?

sks

Re: Recover from SYSTEM01.DBF

harry d brown jr — Mon, 03 May 2004 06:53:04 GMT

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

Re: Recover from SYSTEM01.DBF

Datki Iosif — Mon, 03 May 2004 07:01:02 GMT

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)......

Re: Recover from SYSTEM01.DBF

T G Manikandan — Mon, 03 May 2004 07:07:18 GMT

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.

Re: Recover from SYSTEM01.DBF

Datki Iosif — Mon, 03 May 2004 09:18:37 GMT

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.