ORA-01578: ORACLE data block corrupted (file # 1, block # 26894)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

Errors in file /admin/bdump/sid_smon_14277.trc:
ORA-01578: ORACLE data block corrupted (file # 1, block # 26894)
ORA-01110: data file 1: '/u02/oradata/prd10/data/system01.dbf'
Sat Jan 24 20:50:12 2009

CAUSE JUSTIFICATION
===================
Corruption in system datafile
One of the Cluster C_TOID_VERSION# in SYS schema is got corrupt,

PROPOSED SOLUTION(S)
====================
Need to skip the corrupt and take a full database export

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
This object cant be recreated

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Unfortunately, it cannot be Dropped and Recreated because they are an number
underlying tables associated with it and they cannot be Dropped as it is not supported.

SQL> select table_name from dba_tables where cluster_name='C_TOID_VERSION#';

TABLE_NAME
------------------------------
TYPE$
COLLECTION$
ATTRIBUTE$
METHOD$
PARAMETER$
RESULT$

However, perform an Analyze on the cluster and each of the tables to verify the
corruption. But you said you did this and showed error right

object=C_TOID_VERSION# which is a segment cluster. This is a boot
strap object for Oracle, so it cannot be dropped or truncated to remove the
corruption.


You must be aware that your option may be limited here dur to the corruption in
the system datafile. You may have to either restore from a backup and roll forward,
or you are able, you may have to export the database, then rebuild it.

If restore and recovery is not possible due to no backups then
Try settting the Event 10231 and perform a complete full database export.
once the full database export is completed recreate the database using the
export dump.

Usage:

Event="10231 trace name context forever, level 10".

After setting this event in the init.ora restart the database.
then you can do a full database export . This event will allow to skip
corrupted blocks.

This should be removed from the instance parameters immediately after it has
been used.

Get Oracle Certifications for all Exams
Free Online Exams.com