love wife love life —Roger的Oracle/MySQL数据恢复博客

Phone:18180207355 提供专业Oracle/MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

手工清除回滚段的几种方法

本站文章除注明转载外,均为本站原创: 转载自love wife love life —Roger的Oracle/MySQL数据恢复博客

本文链接地址: 手工清除回滚段的几种方法

在某些情况下,我们需要手动去清除一些有问题的回滚段,如果该回滚段中
包含活动事务,那么使用正常的方式将无法drop,所以此时你drop undo tablespace 也将失败。
可能就会遇到如下的错误:

下面介绍几种方法:

####### 方法1 用隐含参数

用如下隐含参数:

_offline_rollback_segments=(_SYSSMU9$)
_corrupted_rollback_segments=(_SYSSMU9$)


这里可能有人会问上面的_undo_debug_mode参数为啥不管用?其实不是没效果,
是针对这种情况下,没用而已,对于自动undo管理模式,可以使用该参数来手工
删除某个回滚段,前提是该回滚段无活动事务。


######## 方法2 通过更改数据字典表来删除回滚段和undo tablespace


简单的总结下,其实我们只要通过如下步骤就能轻易的删除:
1. 将回滚段更改为临时段
2. 重启实例
3. 从seg$中删除记录
4. 从undo$中删除记录

需要注意一下的是,如果不使用hcheck.full 那么直接drop tablespace可能遇到如下错误:


########## 方法3 使用bbed 修改元数据


下面我们通过bbed来修改元数据,也就是直接修改回滚段的状态,将其修改为offline。

77 Responses to “手工清除回滚段的几种方法”

  1. Dave Says:

    不错,转帖过来。

  2. Rongshiyuan Says:
  3. 手工清除回滚段的几种方法 - Oracle - 开发者第994646个问答 Says:

    […] 原文链接:http://www.killdb.com/?p=196 […]

  4. xccheese Says:

    bbed修改是比较简单 只要把状态改成2就行了

  5. roger Says:

    SQL> startup mount
    ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
    ORACLE instance started.

    Total System Global Area 1573527552 bytes
    Fixed Size 1344420 bytes
    Variable Size 721423452 bytes
    Database Buffers 838860800 bytes
    Redo Buffers 11898880 bytes
    Database mounted.
    SQL> alter database datafile 6 offline drop;

    Database altered.

    SQL> alter database open;

    Database altered.

    SQL> DROP tablespace undotbs including contents AND datafiles;
    DROP tablespace undotbs including contents AND datafiles
    *
    ERROR at line 1:
    ORA-01548: active rollback segment ‘_SYSSMU13_14654527$’ found, terminate dropping tablespace

    前面必须加个offline drop的步骤。有点问题

  6. cost of sildenafil citrate Says:

    cost of sildenafil citrate

    cost of sildenafil citrate

  7. viagra during a massage Says:

    viagra during a massage

    viagra during a massage

  8. coupons for viagra Says:

    coupons for viagra

    coupons for viagra

  9. cialis 20mg Says:

    cialis 20mg

    cialis 20mg

  10. generic viagra reviews Says:

    generic viagra reviews

    generic viagra reviews

  11. cialis generic name Says:

    cialis generic name

    cialis generic name

  12. can women take viagra Says:

    can women take viagra

    can women take viagra

  13. cialis on line Says:

    cialis on line

    cialis on line

  14. cheap cialis Says:

    cheap cialis

    cheap cialis

  15. buy tadalafil Says:

    buy tadalafil

    buy tadalafil

  16. 100 mg viagra Says:

    100 mg viagra

    100 mg viagra

  17. levitra vs cialis Says:

    levitra vs cialis

    levitra vs cialis

  18. sildenafil stories Says:

    sildenafil stories

    sildenafil stories

  19. sildenafil 20mg Says:

    sildenafil 20mg

    sildenafil 20mg

  20. cheap levitra Says:

    cheap levitra

    cheap levitra

  21. sophia viagra sister Says:

    sophia viagra sister

    sophia viagra sister

  22. vardenafil hcl 20mg Says:

    vardenafil hcl 20mg

    vardenafil hcl 20mg

  23. blue chew viagra Says:

    blue chew viagra

    blue chew viagra

  24. viagra india Says:

    viagra india

    viagra india

  25. real viagra Says:

    real viagra

    real viagra

  26. tadalafil 5 mg Says:

    tadalafil 5 mg

    tadalafil 5 mg

  27. viagra for women online Says:

    viagra for women online

    viagra for women online

  28. sophia viagra red dress Says:

    sophia viagra red dress

    sophia viagra red dress

  29. little kid viagra Says:

    little kid viagra

    little kid viagra

  30. female viagra pink pill Says:

    female viagra pink pill

    female viagra pink pill

  31. viagra pricing 100mg walmart Says:

    viagra pricing 100mg walmart

    viagra pricing 100mg walmart

  32. persistent erection with viagra Says:

    persistent erection with viagra

    persistent erection with viagra

  33. penis size using viagra Says:

    penis size using viagra

    penis size using viagra

  34. sildenafil phenetic Says:

    sildenafil phenetic

    sildenafil phenetic

  35. difference between viagra and cialis Says:

    difference between viagra and cialis

    difference between viagra and cialis

  36. wife viagra Says:

    wife viagra

    wife viagra

  37. discount cialis for sale Says:

    discount cialis for sale

    discount cialis for sale

  38. viagra order tablet low cost Says:

    viagra order tablet low cost

    viagra order tablet low cost

  39. cheap viagra express delivery Says:

    cheap viagra express delivery

    cheap viagra express delivery

  40. cialis strength australia Says:

    cialis strength australia

    cialis strength australia

  41. how to buy generic cialis online Says:

    how to buy generic cialis online

    how to buy generic cialis online

  42. buy viagra cost after insurance Says:

    buy viagra cost after insurance

    buy viagra cost after insurance

  43. bladder infection amoxicillin Says:

    bladder infection amoxicillin

    bladder infection amoxicillin

  44. amoxicillin and birth control pills Says:

    amoxicillin and birth control pills

    amoxicillin and birth control pills

  45. celebrex celecoxib Says:

    celebrex celecoxib

    celebrex celecoxib

  46. celebrex 200mg price Says:

    celebrex 200mg price

    celebrex 200mg price

  47. cephalexin eye infection Says:

    cephalexin eye infection

    cephalexin eye infection

  48. pediatric cephalexin dose Says:

    pediatric cephalexin dose

    pediatric cephalexin dose

  49. alternatives to cymbalta Says:

    alternatives to cymbalta

    alternatives to cymbalta

  50. cymbalta sise effects Says:

    cymbalta sise effects

    cymbalta sise effects

  51. cialis generic tadalafil Says:

    cialis generic tadalafil

    cialis generic tadalafil

  52. sildenafil cream Says:

    sildenafil cream

    sildenafil cream

  53. tadalafil gel Says:

    tadalafil gel

    tadalafil gel

  54. sildenafil tadalafil Says:

    sildenafil tadalafil

    sildenafil tadalafil

  55. tadalafil generico Says:

    tadalafil generico

    tadalafil generico

  56. pfizer viagra 100mg Says:

    pfizer viagra 100mg

    pfizer viagra 100mg

  57. tadalafil tablets ip Says:

    tadalafil tablets ip

    tadalafil tablets ip

  58. viagra drug Says:

    viagra drug

    viagra drug

  59. diet soda on keto Says:

    diet soda on keto

    love wife love life —Roger的Oracle/MySQL数据恢复博客 » Blog Archive » 手工清除回滚段的几种方法

  60. 100 free christian dating online sites Says:

    free single parent dating sites

  61. keto meatloaf Says:

    2 week keto diet results

  62. vegetarian keto meal plan Says:

    fruit on a keto diet

  63. states not allowing hydroxychloroquine Says:

    monitoring hydroxychloroquine treatment

    formula hippocampus voice

  64. gaydatingzz.com Says:

    gaydatingzz.com

    love wife love life —Roger的Oracle/MySQL数据恢复博客 » Blog Archive » 手工清除回滚段的几种方法

  65. gay speed dating chicago Says:
  66. gay dating tv show Says:
  67. hampton roads gay dating Says:
  68. gay christians dating Says:
  69. gay dating canada Says:
  70. gay dwarf dating site Says:
  71. gay dating for seniors Says:
  72. cialis online prescription Says:

    […] purchase cialis online […]

  73. cialis sex pill Says:

    […] cialis pharmacy […]

  74. buy cialis dapoxetine Says:

    […] cheap real viagra online […]

  75. cialis discount Says:

    […] best place order viagra online […]

  76. buy viagra melbourne Says:

    […] viagra buy mastercard […]

  77. can you buy viagra chemist Says:

    […] safe place order cialis […]

Leave a Reply

You must be logged in to post a comment.