|
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|