Sunday, July 3, 2011

ORA-01578: ORACLE data block corrupted on a Dictionary Table

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 Description: ORA-01578: ORACLE data block corrupted  


We got the corruption on “trigger$” table in system tablespace,

 dbv found one block got corrupted.
 database got crashed and unable to start.
trigger$ table got corrupted,we used _system_enabled_trigger=false
 We can use hidden parameter _system_enabled_trigger=False and restarted the database.

Alert log file:

Mon Apr 27 15:06:01 2009
Errors in file /bdump/sid_ora_19549.trc:
ORA-12012: error on auto execute of job 7382
ORA-01578: ORACLE data block corrupted (file # 3, block # 91063)
ORA-01110: data file 3: '/system03.dbf'
Mon Apr 27 15:07:02 2009
MMON: terminating instance due to error 472
Instance terminated by MMON, pid = 7586


Solution:

When a dictionary table is corrupted the only valid option is restoring and recovering from a backup besides there is no way to recreate the dictionary

Can’t use DBMS_REPAIR against dictionary tables
Information at dictionary level cannot be ignored. It could cause other issues. Using DBMS_REPAIR against dictionary tables causes logical dictionary corruption

    

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: