Re: Db crashed with no backups :confused:
From: gazzag <gareth_at_jamms.org>
Date: Fri, 30 Jan 2009 03:49:48 -0800 (PST)
Message-ID: <9b752771-80a3-4fcb-b94a-36d598aadb71_at_y1g2000pra.googlegroups.com>
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.
Date: Fri, 30 Jan 2009 03:49:48 -0800 (PST)
Message-ID: <9b752771-80a3-4fcb-b94a-36d598aadb71_at_y1g2000pra.googlegroups.com>
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 Received on Fri Jan 30 2009 - 05:49:48 CST