ora-01578 errororacle data block corrupted
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-01578 errororacle data block corrupted

  1. #1
    Join Date
    Apr 2009
    Posts
    48

    ora-01578 errororacle data block corrupted

    Hi all,


    our production oracle 9i database is on windows 2000 server.since 3 days daily morning its is automaically being shutdown, when i check the alert log file it show the following below errors, when i execute startup command at sql prompt as sysdbs its up without any error.can anyone has idea about that.quick response will be higly appreciated.thanks a lot in advance.


    .Mon Aug 31 17:11:30 2009
    Errors in file c:\oracle\admin\bmms\bdump\bmms_smon_2416.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 3726)
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BMMS\SYSTEM01.DBF'

    Mon Aug 31 17:16:38 2009
    Errors in file c:\oracle\admin\bmms\bdump\bmms_smon_2416.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 3726)
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BMMS\SYSTEM01.DBF'

    Mon Aug 31 17:21:46 2009
    Errors in file c:\oracle\admin\bmms\bdump\bmms_smon_2416.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 3726)
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BMMS\SYSTEM01.DBF'

  2. #2
    Join Date
    Aug 2009
    Posts
    21
    Do you have valid backup with rman ?If yes,then follow

    I)
    a) Shutdown your database
    b) start rman

    rman target /


    Use blockrecovery to recover the corrupted block(s)

    c)BACKUP VALIDATE CHECK LOGICAL database;

    d)BLOCKRECOVER CORRUPTION LIST;

    e)startup database

    Should be good to go......

    if not

    use dbms_repair to mark them as corrupt this is the only option if you dont have any backups.

  3. #3
    Join Date
    Apr 2009
    Posts
    48
    Hi rayyah,


    thank you for quick response .but could you please tell me how to repair the corrupt block using dbms_repaid.waiting for your response.thanks in advance;

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by younusdba View Post
    Hi rayyah,


    thank you for quick response .but could you please tell me how to repair the corrupt block using dbms_repaid.waiting for your response.thanks in advance;
    you cannot repair then, you mark them as corupted so they don't get used.

    You need to get your backups out

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width