Home » RDBMS Server » Server Administration » ERROR: ORA-00604,ORA-01578,ORA-01110
ERROR: ORA-00604,ORA-01578,ORA-01110 [message #54363] Wed, 13 November 2002 10:10 Go to next message
Lisa
Messages: 31
Registered: September 2000
Member
Help please,
i found this error
"ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 4416)
ORA-01110: data file 1: 'D:ORANTDATABASESYS1ORCL.ORA' ".,
can anyone what's going on..
Re: ERROR: ORA-00604,ORA-01578,ORA-01110 [message #54365 is a reply to message #54363] Wed, 13 November 2002 11:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there is block level corruption.
if this is production system, open a TAR with OSS and proceed.
DONT Attempt to do anything, UNLESS YOU HAVE valid Backup.

to determine which object is corrupted, issue
SELECT SEGMENT_NAME, 
       SEGMENT_TYPE, 
       OWNER
FROM   SYS.DBA_EXTENTS
       WHERE FILE_ID = < f >  AND   --f=your file# , b=block#        
       < b > BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;  

Re: ERROR: ORA-00604,ORA-01578,ORA-01110 [message #54370 is a reply to message #54363] Wed, 13 November 2002 12:07 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Your SYSTEM tablespace (which hold the data dictionary) has a block corruption. You can try to find our which database objects has this corrupted block, and if you have Oracle 9i to do media block recovery. If it's an index you can drop and rebuid the index.

The most important question is why that happened - disk failure, application bug, or... Need to further investigate this.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Re: ERROR: ORA-00604,ORA-01578,ORA-01110 [message #55153 is a reply to message #54363] Wed, 08 January 2003 01:29 Go to previous messageGo to next message
Deepak
Messages: 111
Registered: December 1999
Senior Member
Thanks ...suman and barbara..
Re: ERROR: ORA-00604,ORA-01578,ORA-01110 [message #55300 is a reply to message #54363] Thu, 16 January 2003 08:18 Go to previous message
sanjay kumar
Messages: 7
Registered: February 2002
Junior Member
Hi,
This message is generally comes when you tried to drop a user which using TEMPORARY TABLESPACE as existed Permanent Tablespace of Databasee.g. SYSTEM.
So first drop the all objects of this User manually, then drop the user with:
DROP USER user_name CASCADE;

Then problem will resolved.

Thanks!
Sanjay
India.
Previous Topic: Procedure status is Invalid.
Next Topic: Data Migration from SQLServer to Oracle 8i
Goto Forum:
  


Current Time: Fri Sep 20 00:38:19 CDT 2024