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

Hi,

Anil Sikri is right in saying you have not commented out proper rollback_segments
entry in the init.ora. You might have commented other rollback segments.

Naba J Neog

• Original Message ----- From: Anil Sikri <anil_sikri_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, August 31, 2000 2:45 AM Subject: Re: Database Crash...advice needed...

> 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 - 21:28:08 CDT