Re: Oracle Recovery Urgent

You need to restore this database from a backup. You do not need to create a new instance. Keep the same SID, db name, etc. Creating the new instance is what made it tell you the dbid's were different. Now that you have copied over the system.dbf of the new instance, you won't be able to use it anymore without rebuilding it also.

If you are in archivelog mode, you should:

- restore the files to their desired location
- mount the database and rename the datafiles
- recover the database

If you are not in archivelog mode, you should restore a cold backup of the database, mount the database and rename the files, open the database.

This is pretty short and sweet. I suggest you refer to the backup and recovery documentation that is with your software, or if you are in really dire straits, call Support.

Beth

In article <7ftk3u$tv5$1_at_nnrp1.dejanews.com>,   huntbright_at_my-dejanews.com wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Apr 25 1999 - 21:33:20 CDT