Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!r41g2000prr.googlegroups.com!not-for-mail From: ddf Newsgroups: comp.databases.oracle.server Subject: Re: Db crashed with no backups :confused: Date: Mon, 2 Feb 2009 08:35:03 -0800 (PST) Organization: http://groups.google.com Lines: 101 Message-ID: <05641a8d-e025-49b5-acda-d9275dd5363e@r41g2000prr.googlegroups.com> References: <4e61dde1-bd35-4796-8dc9-a8cc728a20fe@p36g2000prp.googlegroups.com> <4985dcb9$0$2870$ba620e4c@news.skynet.be> <4985ee36$0$90265$14726298@news.sunsite.dk> NNTP-Posting-Host: 138.32.32.166 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1233592504 30651 127.0.0.1 (2 Feb 2009 16:35:04 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 2 Feb 2009 16:35:04 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: r41g2000prr.googlegroups.com; posting-host=138.32.32.166; posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; Embedded Web Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl Comments embedded. On Feb 1, 12:46=A0pm, "SEJ" wrote: > Well must top post > No, you choose to do so. And, of course, that IS your choice to make. > If you havent read the complete documentation like the tora you cant get > help from the DBA=B4s, If you made an errror you will know. This group be= long > to them and stupid questions like yours are not allowed. > Certainly they are; this thread exists simply because the question was allowed to be posted. > This group can somtimes be almost like religion, Really? And we thought it good, common sense to follow accepted practices. Silly us. > and yes they can Oracle to > their fingertips, What, exactly, does that mean? > so i do not know why they bother comment your question. Because it illustrates a valid point of what happens when there are no backups taken of a database. To consider a 'development' database 'non-production' is likely wrong, as the development team uses it to produce code/applications, thus to them it IS a production database and should be worthy of the same attention as the 'actual production database' the end-users access. Shakespeare made this point in an earlier response. > Sometimes you can get help from Oracle "wannebees" like my self, I have b= een > working with databases for 25 years only 10 with Oracle but if you do oth= er > things, you cant red everything. I have never read any and have always go= t > what i wanted by doing the right search. Does that mean you don't read the documents you do look up? > > 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) What name do they use? > > Properly they have not understood the gain of information the internet ha= ve > brougth to them, Why, then, would we promote internet searches for those who visit and present often-asked (and more often answered) questions if we don't understand the power of the medium? Your comment makes no sense. > but on the otherhand what is there to know beside Unix and > oracle. > Windows, VMS, Linux, OS/2, OS/400 as Oracle also runs on those operating systems. :) And, in the context of this newsgroup, what other questions are asked here? > regards SEJ > "Gerard H. Pille" skrev i en meddelelsenews:4985dcb9$0$2= 870$ba620e4c@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. = =A0It > > will roll back all non-commited transactions and that's it. =A0 What ha= ve > > you tried to- Hide quoted text - > > - Show quoted text - David Fitzjarrell