在HP-UX 11i平台上测试人员报数据库无法正常启动,数据库版本为9.2.0.5,具体信息如下:
SQL> startup
Total System Global Area 639332944 bytes
Fixed Size 737872 bytes
Variable Size 419430400 bytes
Database Buffers 218103808 bytes
Redo Buffers 1060864 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
查看alert日志,具体错误信息如下:
Errors in file /home/xxxxt/udump/xxxx_ora_5839.trc:
ORA-30036:unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
Error 30036 happened during db open, shutting down database
USER: terminating instance due to error 30036
Instance terminated by USER, pid = 5839
ORA-1092 signalled during: ALTER DATABASE OPEN..
该错误解决需要对UNDO空间进行扩展,具体步骤如下:
1、修改undo管理,为手工管理模式,当设置手工管理的时候,通常需要设置回
滚段,如果未设置的话,通常是使用系统表空间的回滚段。
SQL> startup mount
SQL> alter system set undo_management=manual scope=spfile;
SQL>shutdown immediate
SQL> startup
2、在JP-UX操作系统添加回滚段数据文件
# lvcreate -L 8192M -n undotbs04 xxxvg
# cd /dev/xxxxxxvg/
# chown oracle9i:dba ./rundotbs04
# chmod 664 ./rundotbs04
# cd /home/xxxxxx/oradata/xxxxx/
# ln -s /dev/xxxxxvg/rundotbs04 undotbs04.dbf
3、添加undo表空间
SQL> alter tablespace UNDOTBS1 add datafile
'/home/xxxxxx/oradata/xxxxx/undotbs04.dbf' size 8190M;
4、恢复undo管理为自动模式,并重启数据库
SQL> alter system set undo_management=auto scope=spfile;
SQL> shutdown immediate
SQL> startup
.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/354732/viewspace-608945/,如需转载,请注明出处,否则将追究法律责任。