Re: Emergency Situation with Rollback Restore

Hi,

You should try the following:

startup nomount
drop rollback tablespace
go to the os, delete rollback files
startup nomount again
create the new ones

I haven't experienced this myself but read quite some posts about this and it should work

Jeroen

matthew_at_mattshouse.com wrote:

> It was not backed up in Archive Log mode. What can I do?
>
> Matthew
>
> In article <uhr02.306$Dm.8882695_at_news.ipass.net>,
> "David Sisk" <davesisk_at_ipass.net> wrote:
> > Hi:
> >
> > Are you running in archivelog mode? If yes and you have the archive logs,
> > about all you should have to do is launch server manager and type "RECOVER
> > DATABASE". Check the documentation for all the details.
> >
> > --
> > David C. Sisk
> > http://www.ipass.net/~davesisk/ORACLEonNT.htm
> >
> > matthew_at_mattshouse.com wrote in message <71tafu$l9h$1_at_nnrp1.dejanews.com>...
> > >This is a very weird situation. I need to restore an Oracle database from
> > >tapes. It was not backed up properly. I picked the bits and pieces from the
> > >tape, and am now trying to create a working database. After struggling
> > >through tons of errors, I've got but one left. I can't seem to get around
> > >it. Apparently the Rollback datafile is bad. I get the error
> > >'f:\rollbacks\rbs1orc1.ora' needs media recovery' when I start the database
> > >from svrmgr30. This is all that I have. I don't have any exports or
> > >additional copies of this file. Is there a way to make Oracle skip this
> > file
> > >when it starts up? Can I rebuild or replace it?
> > >
> > >Earlier I stole a rollback file (also called rbs1orc1.ora) from a different
> > >database. Oracle then told me 'invalid database id' when I replaced the
> > bad
> > >file with the stolen one. I loaded both files into a hex editor, trying to
> > >find where Oracle keeps it's database id, but could not find it.
> > >
> > >I'll try anything!
> > >
> > >Matthew
> > >
> > >-----------== 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 Fri Nov 06 1998 - 12:56:14 CST