Re: Db crashed with no backups :confused:

From: Palooka <nobody_at_nowhere.com>
Date: Sat, 31 Jan 2009 03:29:49 +0000
Message-ID: <NAPgl.9$pR5.1_at_newsfe24.ams2>



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.

If it's important, try backing it up in your next job. Or suggest to your (ex) employers that they consider hiring a semi competent DBA.

Palooka Received on Fri Jan 30 2009 - 21:29:49 CST

Original text of this message