Home » RDBMS Server » Backup & Recovery » System Crash and Oracle Recovery
System Crash and Oracle Recovery [message #20566] Wed, 05 June 2002 03:27 Go to next message
Messages: 3
Registered: December 2001
Junior Member
We've got a server's system disk crashed and NT has been reinstalled, so has Oracle 8.1.5 which was installed on the system disk but with the datafiles
distributed on all other physical disks.
That means all the data is still there, the problem is how to make the new installed Oracle to recognize them.
I've tried to startup a new instance using the same initial parameter file and control files, at first the instance was running but no data of previous system can be seen.
I have all the Control files,DBF Files, Redo Files.
But how do I get the data back ???

Re: System Crash and Oracle Recovery [message #20613 is a reply to message #20566] Fri, 07 June 2002 03:59 Go to previous message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
I have tried this is personal oracle.
Copy the exisiting control files, redo log files,dbf files in the same specified location, where there earlier. Overwrite the existing one (newly created with the old one).

You will not even require to create the user.
But keep one thing in mind that files,SID every other thing should be like previous database.

Previous Topic: Re: data backup with oracle8i and vb6.0
Next Topic: Re: Scripts for cold backup's not working
Goto Forum:

Current Time: Thu Sep 21 17:04:12 CDT 2023