Re: Db crashed with no backups :confused:

From: gazzag <>
Date: Fri, 30 Jan 2009 03:49:48 -0800 (PST)
Message-ID: <>

On 30 Jan, 11:09, 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.

Stop what you're doing now! Shut down the instance, if it's open, and take a cold (file system) backup. When you've done that, we can go from there.

HTH -g Received on Fri Jan 30 2009 - 05:49:48 CST

Original text of this message