RE: Error opening the database

Samir,

>From your mail, I assume the following :
1. You shutdown the database either through immediate or normal. 2. Now you are trying to open the database. At this point, you are getting this error.

If the above is true, then, try the following.

1. Close the instance by issuing the command at svrmgrl --- Shutdown immeidate (even though your database is not open, your instance would have been created which you need to shut it down).
2. After successful close, come to the O.S. prompt, and then, delete all the redo logs. <--- Imp. step.
3. Now, issue the following sequence of commands.
4. startup mount;
5. alter database recover until cancel;
6. Alter database open resetlogs;

The above last command would open the database and also would create the redo logs.

Rao

-----Original Message-----
Sent: Tuesday, December 04, 2001 4:45 AM To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: Maheswara.Rao_at_Sungardp3.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).