Home » RDBMS Server » Server Administration » SOS : ORA-01578 error
SOS : ORA-01578 error [message #63686] Wed, 27 October 2004 23:37 Go to next message
bluebyte
Messages: 25
Registered: September 2003
Junior Member
Hi!

We are administering Oracle 8.0.4 on Windows NT 4.0 with the data stored on a Micron Netframe (dual cpu/5 disks). The disk controller is SCSI. We run on NOARCHIVELOG mode.

Since yesterday, when we run a particular form which has heavy deletes/inserts (usually above 3000) we are getting Ora-01578/ Ora-01110 errors.

* Yesterday, the errors came up when the program hit a particular datablock.

* But, today we discovered that the same error is cropping up in a different file.           We suspect that this is Oracle soft corruption...But we need help in containing and eliminating the problem.

* We are tried out windows check disk utility - no luckFollowing errors were found :

Oracle Forms -

* ORA - 01110 : data file 32 : D:sharacdbsits_cds_dat1.ora

* ORA - 01115 : error reading block from file 32

we ran scripts to zero in on corrupt objects..

- 1 table & 2 clusters are corrupt

Pls let me know some os utilities to repair this...

Our transactional activities have been held up...

Wots the long term/short term solution?

Pls reply asap...

TIA,

bluebyte

Report message to a moderator

Re: SOS : ORA-01578 error [message #63687 is a reply to message #63686] Thu, 28 October 2004 03:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
depends.
first run a simple query/update from sqlplus.
Is the error reproduced?
is there any ORA-0600 errors? if so post the complete error message.

CHeck the available disk space.

look into the alert_sid.log and post the latest relevant information.
IF any trace files is generated, post the same.

IF this IS a data block corruption, better open a TAR with oracle support.

Report message to a moderator

Re: SOS : ORA-01578 error [message #63692 is a reply to message #63687] Thu, 28 October 2004 06:21 Go to previous messageGo to next message
bluebyte
Messages: 25
Registered: September 2003
Junior Member
hi mahesh!
thanks for the reply...
there are no ora-0600 errors.
But, yes..we are getting ora-01110/ora-01115/ora-01578
errors...(reproduced).

pls find appended the info about corrupt blocks..

*******************************************************

DBVERIFY: Release 8.0.4.0.0 - Production on Thu Oct 28 11:4:41 2004

(c) Copyright 1997 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = d:sharacdbsits_tbl_1.ora
Page 95918 is marked corrupt
***
Corrupt block relative dba: 0x020176ae file=0. blocknum=95918.
Bad header found during dbv:
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff

Page 95919 is marked corrupt
***
Corrupt block relative dba: 0x020176af file=0. blocknum=95919.
Bad header found during dbv:
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff

Page 124256 is marked corrupt
***
Corrupt block relative dba: 0x0201e560 file=0. blocknum=124256.
Bad header found during dbv:
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff

Page 124257 is marked corrupt
***
Corrupt block relative dba: 0x0201e561 file=0. blocknum=124257.
Bad header found during dbv:
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff

Page 202214 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x020315e6 file=0. blocknum=202214.
Fractured block found during dbv:
Data in bad block - type:6. format:2. rdba:0x020315e6
last change scn:0x0000.05783d64 seq:0x5 flg:0x00
consistancy value in tail 0x3cdd0601
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

Page 238008 is marked corrupt
***
Corrupt block relative dba: 0x0203a1b8 file=0. blocknum=238008.
Bad header found during dbv:
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff

Page 238009 is marked corrupt
***
Corrupt block relative dba: 0x0203a1b9 file=0. blocknum=238009.
Bad header found during dbv:
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff
***************************************

Report message to a moderator

Re: SOS : ORA-01578 error [message #64487 is a reply to message #63692] Tue, 01 February 2005 23:19 Go to previous message
Cruzo Kay
Messages: 1
Registered: February 2005
Junior Member
Hi Bluebyte,
I am having the same error on RBS01.dbf datafile and I can not get into SQLPLUS at all. Database is 8.1.6 and also running noarchive log mode.

If have already been able to resolve your problem can you please let me in on how you fixed your problem?

Best regards

Report message to a moderator

Previous Topic: Resource Usage Calculation.
Next Topic: Multi-Page Tiff
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 04:27:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.