drop表中断不释放空间处理
来源:互联网 发布:淘宝网禁售电话卡 编辑:程序博客网 时间:2024/06/05 03:14
一次用plsql developver drop表异常中断,表空间空间不释放,告警日志报如下错误:
Errors in file /opt/oracle/db/diag/rdbms/db/db1/trace/db1_smon_16016.trc (incident=94423):
ORA-00600: internal error code, arguments: [ktecgeb-1], [32], [], [], [], [], [], [], [], [], [], []
Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 9 out of maximum 100 non-fatal internal errors.
找到临时段和文件头编号:
SQL> select SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,HEADER_FILE from dba_segments where SEGMENT_TYPE='TEMPORARY';
SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME HEADER_FILE
-------------------- -------------------- -------------------- --------------------
16.1144841 TEMPORARY TBS2 16.1144841
24.153097 TEMPORARY TBS2 24.153097
24.153609 TEMPORARY TBS2 24.153609
24.154121 TEMPORARY TBS2 24.154121
24.154633 TEMPORARY TBS2 24.154633
24.155145 TEMPORARY TBS2 24.155145
标记这些段为损坏:
SQL> exec dbms_space_admin.segment_corrupt('TBS2',16,1144841);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_corrupt('TBS2',24,153097);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_corrupt('TBS2',24,153609);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_corrupt('TBS2',24,154121);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_corrupt('TBS2',24,154633);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_corrupt('TBS2',24,155145);
PL/SQL procedure successfully completed
然后删除这些段:
SQL> exec dbms_space_admin.segment_drop_corrupt('TBS2',16,1144841);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_drop_corrupt('TBS2',24,153097);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_drop_corrupt('TBS2',24,153609);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_drop_corrupt('TBS2',24,154121);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_drop_corrupt('TBS2',24,154633);
PL/SQL procedure successfully completed
SQL> exec dbms_space_admin.segment_drop_corrupt('TBS2',24,155145);
PL/SQL procedure successfully completed
重建这些段所在表空间位图:
SQL> exec dbms_space_admin.tablespace_rebuild_bitmaps('TBS2');
PL/SQL procedure successfully completed
检查表空间,空间已经释放,告警日志也再没有报错。此故障处理完毕。
- drop表中断不释放空间处理
- Oracle截断表后空间不释放处理
- 处理rm 空间不释放的问题
- TEMP表空间不释放
- Truncate 不释放表空间
- truncate表后,不释放表空间
- oracle drop表空间
- truncate 空间不释放问题
- truncate 空间不释放问题
- mysql ibdata1释放空间处理
- 释放UNDO表空间
- Oracle表卡、表锁、空间不释放解决方法
- 工作记录:删除文件,空间不释放
- jffs2文件系统删除文件不释放空间
- linux删除空间不释放的解决方法
- centos删除文件空间不释放解决方法
- 删除日志文件 空间不释放
- 删除文件之后空间不释放
- eclipse3.3~3.5配置tomcat7.0
- 漂亮者生存
- 我的电脑学习历程.第九章.尾声(道之始)
- 爱情有时像在等公交车
- Java简单的continue语句代码
- drop表中断不释放空间处理
- c++ 多重继承中的动态绑定
- 正则表达式中的不包含一个词的写法
- POJ 3104 (总是有那么多牛人可以想到这些方法)
- CallJs
- Ubuntu 10.04安装google拼音输入法
- zencart如何修改网店信息边框?
- 获得窗口指针
- Ogre 游戏中初始化 CEGUI