Re: Db crashed with no backups :confused:

From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Fri, 30 Jan 2009 04:10:01 -0800 (PST)
Message-ID: <8df6381b-5331-437b-ad5a-1474a2d9d25c_at_p36g2000prp.googlegroups.com>

On Jan 30, 4:49 pm, gazzag <gar..._at_jamms.org> wrote:
> On 30 Jan, 11:09, dbagtcol <cx4gt..._at_gmail.com> 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

I'd appreciate if you could elaborate. I've already taken cold back up for all datafiles.
Thanks Received on Fri Jan 30 2009 - 06:10:01 CST