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 -
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open Received on Fri Jan 30 2009 - 06:32:48 CST
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 -
- I have backups for them.
- No.
- Seems like control files, logfiles and datafiles are corrupt, due to power failures.
- 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 bytesDatabase mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open Received on Fri Jan 30 2009 - 06:32:48 CST