Error opening the database

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Tue, 04 Dec 2001 02:14:16 -0800
Message-ID: <F001.003D45F0.20011204014518@fatcity.com>

Hi folks,

On trying to open one of our development databases today morning, I get the following
error :  

 SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00333: redo log read error block 129347 count 1719

The database is 8.1.7 on Solaris and is running in NOARCHIVELOG mode.

Is this a case of redolog corruption ?? In that case, how do I recover the database even if I restore
the previous backup since there r no archive logs (NOARCHIVELOG mode) ??

Any help would be greatly appreciated.

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : samir.sarkar_at_nottingham.sema.slb.com

            samir.sarkar_at_sema.co.uk
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018

---

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: SARKAR, Samir
  INET: Samir.SARKAR_at_nottingham.sema.slb.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 also send the HELP command for other information (like subscribing). Received on Tue Dec 04 2001 - 04:14:16 CST