Re: Db crashed with no backups :confused:
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 1 Feb 2009 16:28:36 +0000 (UTC)
Message-ID: <gm4ijj$4no$6_at_solani.org>
On Fri, 30 Jan 2009 03:09:12 -0800, dbagtcol wrote:
Date: Sun, 1 Feb 2009 16:28:36 +0000 (UTC)
Message-ID: <gm4ijj$4no$6_at_solani.org>
On Fri, 30 Jan 2009 03:09:12 -0800, dbagtcol wrote:
> 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.
Start updating your resume. Be sure to skip the part about running a production database without backup or standby.
-- http://mgogala.freehostia.comReceived on Sun Feb 01 2009 - 10:28:36 CST