Post reply

I/O Error from corrupted SAN directory

  • October 11, 2006 at 6:18 am

    #174382

    Hi,

    About 2 months ago I added a 2 SAN volumes to enable the expansion of 2 DB's and the method adopted was setting a new filename and location to the SAN.

    Unfortunately, the SAN volume corrupted and one of the volumes did not recover

    The error was "823 I/O error 2(error not found) detected during read at offset..."

    Is there anyway of recovering from this error or is it best to 'Restore' from last known backup?

  • October 12, 2006 at 10:59 am

    #665557

    Restore  from the last known good backup.

    Also was your database split between local disk and SAN disk ? If it was then you are almost guaranteed the same issue in the future. All file for an individual database need to be on either local disk or SAN disk, not a mixture thereof.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply