Re: Database Crash...advice needed...

Anil, I checked out and it was commented out in init.ora.

Also what happened was that once with just fsck -p on the damaged hdisk9 we were able to bring up the database(init.ora lines were commented out) but then it was shutdown again without recovering the RBS and bringing it online. This was done because we decided not to use other DBFs lying on the hdisk9 as it could have failed again. Was this the mistake ? After restoring the contents of the hdisk9 from our offline backup onto another disk, we tried to bring up the database with rollback_segments commented out. Did not work...

The PITR which I referred to in my earlier mail has also not succeeded and now it looks like a days work lost completely.

Now I'm interested in knowing the mistake we made and it'll help if you all can throw in some ideas.

TIA, Anil Sikri wrote:

> Hi Prashasta,
> Looking at the error, it appears that the rollback_segments
> entry in the init.ora wasn't commented out.
> The rollback segment tablespace was taken offline whereas the
> rollback_segment entry still remains in the parameter file.
> Can you check your init.ora again ?
>
> Regards,
> Anil Sikri
>
> -------------- Original Message -----------------------------
>
> >From: prashasta gujrati <gujrati_at_tubes.tatasteel.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Database Crash...advice needed...
> >Date: Wed, 30 Aug 2000 12:03:46 -0800
> >
> >
> >Hi DBAs,
> >
> >This is the scenario : Oracle 7.3.3 on AIX 4.3.2
> >
> >Time Event
> >
> >0300 Offline backup of the database done successfully.
> >1523 Hard disk failure on one of the disks(hdisk9) mounted
> > on /database. This FS had 1 system DBF, 2 RBS files,
> > 3 application DBFs.
> >
> > These files were taken offline automatically as
> >reported
> > in alert.log .
> >
> >1530 Error reported of applications not working and DB having
> > crashed.
> >
> >1535 Database was shutdown with abort and tried doing a
> > normal startup which failed. Database could only be
> > mounted. It has been brought down since then.
> >
> >1600 Another FS was created on a different disk (hdisk10)
> > and was mounted on the same mount point (/database).
> >
> >1630 We restored the DBFs from the offline backup which
> > were residing on that mount point (/database).
> >
> >1640 Database startup mount. After that we issued a recover
> > database which prompted for the archive files which
> > were avilable on another disk and were applied. The Redo
> >
> > is also intact.
> >
> > What we see here is that it takes us to a point between
> >1523
> > and 1535.
> >
> > Now when we try to open the database it says that one of
> >
> > the RBS files cannot be read. We tried commenting out
> >the
> > rollback_segments from init.ora and then did startup
> >mount.
> > Thereafter, we made the RBS files offline to see if the
> > database will reopen. It fails with an error message :
> > ORA-00704: bootstrap process failure
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-00955: name is already used by an existing object
> >
> >After all this now we have planned to restore all the files from offline
> >
> >backup and use the current controlfile + redo + archives to do a PITR
> >upto 1515 (few minutes before the disk failure) and then open the DB
> >with resetlogs option and then take an offline backup immediately.
> >
> >If you all can tell me the error we made in this process, it'll help.
> >Also your advice if the second approach we are taking will work
> >or not ?
> >
> >TIA,
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> Author: Anil Sikri
> INET: anil_sikri_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Aug 30 2000 - 20:35:09 CDT