Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: Oracle 9i Corrupt Undo tablespace

    Hi,

    My undo tablespace is couurpted. I'm getting the following error

    ORA-01110: data file 304: '/oracle/data/undo.data14'
    ORA-01114: IO error writing block to file 304 (block # 1)

    How can I rectify this problem.


    Thnax in advance

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Can you create a new undo tablespace and drop the old one? Also check your OS log files to see if there is a problem with your disks.

    Alan

  3. #3
    Join Date
    Mar 2005
    Posts
    52
    I'm not able to open the database. only can bring it in mount stage

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Try mounting it and then doing recovery using alter database recover. If this fails you may need to resort to tape backups.

    Alan

Posting Permissions

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