DATAFILE OF ROLLBACK SEGMENT TABLESPACE GOT CORRUPTED
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DATAFILE OF ROLLBACK SEGMENT TABLESPACE GOT CORRUPTED

  1. #1
    Join Date
    Jan 2001
    Posts
    24

    Red face

    We have an Oracle Instance in which all the rollback segments are part of a tablespace that has one datafile.
    Unfortunately, the datafile is corrupted. we dropped the datafile using 'alter database datafile 'sdsd' offline drop; ' which got corrupted. deleted the datafile restarted the database. when we try create the new tablespace, it gives an error ora-376 cannot read at this time.

    when we try to drop the rollback segment tablespace using the command drop tablespace rollback_data including contents. it gives an error message. it contains active rollback segments. the status of the rollback segments are needs recovery.

    we want to drop the tablespace recreate the tablespace and rollbacksegments. how do we go about doing this ?
    R.John Dhinakaran

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Have a look at today morning thread

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5491[/url]

  3. #3
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    You can use the init.ora parameter :
    _corrupted_rollback_segments=(seg1,seg2,... )

    Put the rollback segments with status "NEEDS RECOVERY" in this parameter. Remove them from the rollback_segments parameter.

    Procedure :

    Shutdown the db
    add the parameter to the init.ora
    start the db
    Immediate, drop the rollback segments
    shutdown the db
    remove the parameter from the init.ora
    startup the db

    Hope this helps
    Gert

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