DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2001

    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
    Washington DC
    Have a look at today morning thread


  3. #3
    Join Date
    Aug 2000
    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

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.