Re: Help !

"purva" <purvamitra_at_yahoo.com> wrote in message news:1ae62ae2.0112230805.1f62fc9b_at_posting.google.com...
> 1. I have oracle 8.1.7 on win2k
> 2. It's running in noarchive mode.
> 3. Crash
> 4. Restored all oracle files but do not have backups of application data
and
> index files.
> 5. startup
> 6. recover database
> 7. Demands recover with backup controlfile
> 8. recover database using backup controlfile
> 9. demands an arc00079.001 which I don't have ! cancelled
> 10.Now every file in the database is in recover status
>
> I can live with data loss, as there were no changes.
> How should i proceed ??

Looks like you're screwed - you might want to try the following (maybe it'll work - maybe not)

1. take backup of current situation
2. set _allow_resetlogs_corruption=TRUE in init.ora
3. recover database using backup controlfile until cancel
4. cancel
5. alter database open resetlogs ;
6. export DB
7. recreate DB and import