Re: Emergency Situation with Rollback Restore

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
Received on Thu Nov 05 1998 - 18:20:42 CST