Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Recovery Urgent

Oracle Recovery Urgent

From: <huntbright_at_my-dejanews.com>
Date: Sat, 24 Apr 1999 23:29:04 GMT
Message-ID: <7ftk3u$tv5$1@nnrp1.dejanews.com>


We've got a server's system disk crashed and NT has been reinstalled, so has Oracle 8.0.4 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 and after a while the instance will not be available, if I restart it I'd get error said the Roll Back Segment No.21 does not exist. I thought the user and role are kept in System tablespace so I tried to replace the new created system data file with the previous one but there's error said the database id is different. I want to know what will be the correct solution to recover this system? Please reply really soon if you in deed want to help. Thousands of thanks!

Hunt

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Apr 24 1999 - 18:29:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US