資料庫啟動出現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/，如需轉載，請註明出處，否則將追究法律責任。