How
to recover database after a crash?(b27)
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!
Ans:
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