Oracle undo表空间爆满的解决(二)
LINE
_SYSSMU18$
UNDOTBS1
18
OFFLINE
_SYSSMU19$
UNDOTBS1
19
OFFLINE
_SYSSMU20$
UNDOTBS1
20
OFFLINE
_SYSSMU21$
UNDOTBS1
21
OFFLINE
_SYSSMU22$
UNDOTBS1
22
OFFLINE
_SYSSMU23$
UNDOTBS1
23
OFFLINE
_SYSSMU24$
UNDOTBS1
24
OFFLINE
_SYSSMU25$
UNDOTBS1
25
OFFLINE
_SYSSMU26$
UNDOTBS1
26
OFFLINE
_SYSSMU27$
UNDOTBS1
27
OFFLINE
_SYSSMU28$
UNDOTBS1
28
OFFLINE
_SYSSMU29$
UNDOTBS1
29
OFFLINE
_SYSSMU30$
UNDOTBS1
30
OFFLINE
_SYSSMU31$
UNDOTBS1
31
OFFLINE
_SYSSMU32$
UNDOTBS1
32
OFFLINE
_SYSSMU33$
UNDOTBS1
33
OFFLINE
_SYSSMU34$
UNDOTBS1
34
OFFLINE
_SYSSMU35$
UNDOTBS1
35
OFFLINE
上面对应的UNDOTBS1还原表空间所对应的回滚段均为OFFLINE
10.到$ORACLE_HOME/dbs/init$ORACLE_SID.ora如下内容是否发生变更：
#cat $ORACLE_HOME/dbs/initddptest.ora
……
*.undo_management=’AUTO’
*.undo_retention=10800
*.undo_tablespace=’UNDOTBS2’
……
如果没有发生变更请执行如下语句：
SQL> create pfile from spfile;
File created.
11. 删除原有的UNDO表空间；
drop tablespace undotbs1 including contents and datafiles;
12. os级别释放undo数据文件；
到root下执行
lsof |grep /u02/pnrdb/undotbs01.dbf
lsof |grep /u02/pnrdb/undotbs01.dbf |awk '{printf"kill -9 "$2"\n"}'