Re: Db crashed with no backups :confused:
From: gazzag <gareth_at_jamms.org>
Date: Fri, 30 Jan 2009 04:17:01 -0800 (PST)
Message-ID: <128e0d78-ade1-48f3-8bde-1effe0abfcd3_at_k36g2000pri.googlegroups.com>
On 30 Jan, 12:10, dbagtcol <cx4gt..._at_gmail.com> wrote:
> 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
Date: Fri, 30 Jan 2009 04:17:01 -0800 (PST)
Message-ID: <128e0d78-ade1-48f3-8bde-1effe0abfcd3_at_k36g2000pri.googlegroups.com>
On 30 Jan, 12:10, dbagtcol <cx4gt..._at_gmail.com> wrote:
> 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
- Have you taken backups of the control file and SPFILE too?
- Is your database in archivelog mode?
- Why are you trying to recreate the control file?
- What happens when you issue a STARTUP?
HTH -g Received on Fri Jan 30 2009 - 06:17:01 CST