Re: Db crashed with no backups :confused:

From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Fri, 30 Jan 2009 04:32:48 -0800 (PST)
Message-ID: <430293f0-64ef-413d-a43c-43853ad7b969_at_v39g2000pro.googlegroups.com>



On Jan 30, 5:17 pm, gazzag <gar..._at_jamms.org> wrote:
> 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
>
> 1. Have you taken backups of the control file and SPFILE too?
> 2. Is your database in archivelog mode?
> 3. Why are you trying to recreate the control file?
> 4. What happens when you issue a STARTUP?
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
  1. I have backups for them.
  2. No.
  3. Seems like control files, logfiles and datafiles are corrupt, due to power failures.
  4. It gives: ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size                  1268508 bytes
Variable Size             402654436 bytes
Database Buffers         1728053248 bytes
Redo Buffers               15507456 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open Received on Fri Jan 30 2009 - 06:32:48 CST

Original text of this message