Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error opening the database
Thanks Claudio.....it has subsequently been detected that there is a
bad media on the disk.....the ufsdump utility confirmed that....it was the
disk
which was corrupted. We have logged a call with Sun and we might have to
swap the
whole disk and re-create the file systems.
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 12:45
To: Multiple recipients of list ORACLE-L
first make a backup of the broken database, then try to use the init parameter _allow_resetlogs_corruption= true open the database and make an export.
Let me know if you will win :-)
by Claudio.
> 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: claudio cutelli INET: c_cutelli_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 also send the HELP command for other information (like subscribing). -- 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 - 08:23:47 CST
![]() |
![]() |