Corrupted Rollback Segments

上一篇 / 下一篇  2006-01-14 00:00:00 / 个人分类:Oracle管理文章

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.


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-08-30  
     12
3456789
10111213141516
17181920212223
24252627282930
31      

数据统计

  • 访问量: 1394
  • 日志数: 276
  • 图片数: 1
  • 建立时间: 2007-12-16
  • 更新时间: 2008-08-26

RSS订阅

Open Toolbar