数据库启动出现ORA-30036错误

        在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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/354732/viewspace-608945/