Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle data block corrupted"; "object no longer exists" errors

    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    In the alert log on our server for this morning, we see a lot of errors:

    ORA-01578: ORACLE data block corrupted.

    In the pc_server log files for today, we also see this error. It is also reported in the www-server log file for today.

    In looking back at logs from yesterday, it appears to have started around 21:21 yesterday.

    We've never seen this on our system; our DBA has seen it only once (on one data block) in all of her years of experience.

    Resolution:
    From site: We have found the cause of the problem. In an attempt to fully investigate our events and look into hardware, SysAdmin utilized a tool recommended by Sun (vdbench) to measure IO. This was first tested on our pre-prod server and when that testing looked promising (for providing IO information) it was used on our production server.

    We currently have both Aleph and Oracle down and are reviewing our backup/restore options. The backup from last night (at midnight) probably isn’t an option since this activity started around 9:21 PM.

    We will probably use the backup from Sunday night and then apply the roll back logs as far as we can.


    • Article last edited: 10/8/2013