Re: Db crashed with no backups :confused:

If you havent read the complete documentation like the tora you cant get help from the DBA´s, If you made an errror you will know. This group belong to them and stupid questions like yours are not allowed.

This group can somtimes be almost like religion, and yes they can Oracle to their fingertips, so i do not know why they bother comment your question. Sometimes you can get help from Oracle "wannebees" like my self, I have been working with databases for 25 years only 10 with Oracle but if you do other things, you cant red everything. I have never read any and have always got what i wanted by doing the right search.

I have read the comments for some of the persons in this group for many years, and they don not ask questions in other groups. (not in their own name)

Properly they have not understood the gain of information the internet have brougth to them, but on the otherhand what is there to know beside Unix and oracle.

regards SEJ
"Gerard H. Pille" <ghp_at_skynet.be> skrev i en meddelelse news:4985dcb9$0$2870$ba620e4c_at_news.skynet.be...
> dbagtcol schreef:
>> Hi all
>> We've just had a scenario here; one of our dev db has just crashed due
>> to unavoidable power failure. We've had no backup for this since the
>> beginning. I could recover redo logfiles; I couldn't RECOVER datafiles
>> though. I am trying out CREATE CONTROLFILE REUSE DATABASE orcl
>> RESETLOGS NOARCHIVELOG option, provided I don't have backups for
>> control files, redo logfile, datafiles, spfiles or anything. I am on
>> RHEL 4, Oracle 10gR2.
>>
>> Please suggest.
>
> After a power failure, you only need to start the database normally. It
> will roll back all non-commited transactions and that's it. What have
> you tried to
Received on Sun Feb 01 2009 - 12:46:41 CST