Db crashed with no backups :confused:

From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Fri, 30 Jan 2009 03:09:12 -0800 (PST)
Message-ID: <4e61dde1-bd35-4796-8dc9-a8cc728a20fe_at_p36g2000prp.googlegroups.com>

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. Received on Fri Jan 30 2009 - 05:09:12 CST

Original text of this message