DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Aug 2012
    Posts
    1

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

    Hi,

    I can't able to connet to the database, while connecting i'm receiving the below error:
    ERROR: ORA-01034: ORACLE not available
    I shutdown the database and restarted it, while during this process i face new error :
    ORA-01578: ORACLE data block corrupted (file # 1, block # 2)

    Can any one help me to sort this out?

    SQL*Plus: Version 3.0.11.1.2 - Production on Thu Aug 23 15:04:50 2012

    Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

    Enter user-name: netmon
    Enter password:
    ERROR: ORA-01034: ORACLE not available
    ORA-07318: smsget: open error when opening sgadef.dbf file.
    SunOS Error: 2: No such file or directory

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You posted this question in the wrong forum, so I moved it to the correct forum.

    This is one reason why you want to use RMAN to backup your database. You can do block level recovery with RMAN. You should probably get an RMAN backup now before you try to recover any blocks, if you don't already have an RMAN backup.

    Here is a document on getting started with RMAN
    http://docs.oracle.com/cd/B28359_01/...0/rcmquick.htm

    Here is a document for doing block level recovery.
    http://docs.oracle.com/cd/B28359_01/...0/rcmblock.htm

    Block level corruption should not happen as a matter of course, however it is relatively easy to deal with, once you have a good backup and recovery strategy.

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