Re: Db crashed with no backups :confused:
From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Fri, 30 Jan 2009 04:42:28 -0800 (PST)
Message-ID: <4acae97b-731f-4b57-91e7-9b381e5001e4_at_s9g2000prg.googlegroups.com>
On Jan 30, 5:32 pm, dbagtcol <cx4gt..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Date: Fri, 30 Jan 2009 04:42:28 -0800 (PST)
Message-ID: <4acae97b-731f-4b57-91e7-9b381e5001e4_at_s9g2000prg.googlegroups.com>
On Jan 30, 5:32 pm, dbagtcol <cx4gt..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
And when I try to open it with resetlogs option,
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/d2he/system01.dbf'
Received on Fri Jan 30 2009 - 06:42:28 CST