Very Computer

Hello

We're using Oracle 8.05 on our NT 4.0 Server. Last week we've shut down NT
and did boot the server with a DOS floppy  to do a  harddisk image backup
with Ghost v.5.
Today we've restored the whole harddisk image. NT works fine, but now while
trying to "startup" the DB we get an error something like "RBS.....dbf file
error". Why?  Is this a date problem? The whole database was really in a
stable condition when we shut down the server last week. We don't yet
(unfortunately) know a lot about Oracle, but HOW can we manage to get that
database to work again? PLEASE HELP!!!
Thanks
Daniel

was oracle shutdown normaly prior to the boot???

Was the database installed as a service on the NT server?  If not you would have
had to shut it down manually before you rebooted.

Do you have a cold backup of the database?

If and only if its the rollback segments, you might get away with something like

startup mount
drop tablespace rbs

shut the database down again

Comment out the line in the init<instance name>.ora file about rollback_segments=

start it up again

Then recreate your rbs tablespace again and ALL of your associated roll back
segments (listed in the init.ora file).

You will have to uncomment the lines in the init.ora file again and bounce the
database.

NOTE!!!  This is rattled of the top of my head.  _PLEASE_  find a manual of some
sort to verify this!!

good luck!

--

Darren

Daniel,

Is your database contained on only one disk?  If you used ghost to backup
only the system drive and the oracle datafiles are on a different drive,
then returned your system to use after the backup, your control files (which
are probably stored on your system disk) are now out of date with the data.

If everything is on one disk, then you should be able to fully recover but
only to the previous date.  The control files can be rebuilt but, it has
been a very long time since I have done it and do not have the notes at this
location.  If you must get this back up fast, contact Oracle technical
support.  If you did not purchase support with your product, this could be
expensive.

Let me know if you get it going or not.  I can try to get the info faxed to
me.

Brian

Daniel,

Is your database contained on only one disk?  If you used ghost to backup
only the system drive and the oracle datafiles are on a different drive,
then returned your system to use after the backup, your control files (which
are probably stored on your system disk) are now out of date with the data.

If everything is on one disk, then you should be able to fully recover but
only to the previous date.  The control files can be rebuilt but, it has
been a very long time since I have done it and do not have the notes at this
location.  If you must get this back up fast, contact Oracle technical
support.  If you did not purchase support with your product, this could be
expensive.

Let me know if you get it going or not.  I can try to get the info faxed to
me.

Brian