Re: Restoring A Harddisk Image!

From: Darren Smith <dsmith_at_nospamming.au.oracle.com>
Date: 1999/10/22
Message-ID: <38100AA6.86A9F491_at_nospamming.au.oracle.com>#1/1


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!

Peter Okhiria wrote:

> was oracle shutdown normaly prior to the boot???
>
> Daniel Vollmer wrote:
>
> > 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

--


Darren
Received on Fri Oct 22 1999 - 00:00:00 CEST

Original text of this message