一.概述:
使用IMPDP工具导入大表(166G)数据时,报undo表空间不能扩展,导入工作失败.手工停止了impdp后,undo表空间存在无法自动释放的故障.本文主要描述如何通过重建undo表空间来手工释放undo表空间.
数据库环境的描述:
OS: AIX 6.1+HACMP 5.3
DB: ORACLE 10.2.0.5 RAC
二.问题的描述
impdp 导入数据时,报ora-30036错误
$impdp user/passwd directory=imp_dir dumpfile=big_table_%U.dmp parallel=10 logfile=imp_big_table.log
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'[@more@]
检查数据库的归档日志文件,也发现了这个报警
more /oracle/admin/*/bdump/alert_{SID}.log|grep undo
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
强行终止了impdp的操作,impdp的进程在操作中已不见
# ps -ef|grep impdp
root 8650752 8061396 0 15:02:08 pts/1 0:0