ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Corrupted Rollback Segments

Corrupted Rollback Segments

原创 Linux操作系统 作者:yanggq 时间:2019-05-03 17:15:05 0 删除 编辑
User ShutDown DB Instance and caused the rollback segment crashed, ...

At 26,Dec. 2005, Got a call from a friend that , his db's rbs tablespace increased over 6GB cause some block corruption of a rbs, and he shutdown the db server, then restart, but found that the r02 cannot mark available with the smon, Then I suggest him do like following:

1. Add the parameter "_corrupt_rollback_segments"=(R02);

2. Shutdown and restart the db.

3. Drop the rollback segment and the rbs tablespace;

4. create tablespace and rollback segment

5. exp all data from db.

6. delete the db and re-create them and imp.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26706/viewspace-64578/,如需转载,请注明出处,否则将追究法律责任。

上一篇: exp big file over os
请登录后发表评论 登录
全部评论

注册时间:2002-10-29

  • 博文量
    54
  • 访问量
    40942