RE: Error opening the database

Hi Rao,

My database is running in NOARCHIVELOG mode. Would it still be possible for me to issue the 'recover database until cancel' command ?? I understand that this command applies all the archived logs....but since I do not have any archived
logs, how will the database perform recovery ??

Thanks,

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

-----Original Message-----
Sent: 04 December 2001 15:30
To: Multiple recipients of list ORACLE-L

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).


___________________________________________________________________________
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).