9i库遇到ORA-01595/ORA-01594

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:9i库遇到ORA-01595/ORA-01594

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

在alert日志中发现ORA-01595/ORA-01594错误

Sat May 12 21:54:17 2012
Errors in file /oracle/app/admin/prmdb/bdump/prmdb2_smon_483522.trc:
ORA-01595: error freeing extent (2) of rollback segment (19))
ORA-01594: attempt to wrap into rollback segment (19) extent (2) which is being freed

分析trace文件

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /oracle/app/product/9.2.0
System name:    AIX
Node name:      prmsvr2
Release:        3
Version:        5
Machine:        0008585FD600
Instance name: prmdb2
Redo thread mounted by this instance: 2
Oracle process number: 14
Unix process pid: 483522, image: oracle@prmsvr2 (SMON)

*** 2011-05-03 15:28:47.858
*** SESSION ID:(17.1) 2011-05-03 15:28:47.843
*** 2011-05-03 15:28:47.858
SMON: Parallel transaction recovery tried
*** 2011-07-11 17:13:52.028
SMON: Restarting fast_start parallel rollback
*** 2011-07-11 17:28:39.705
SMON: Parallel transaction recovery tried
*** 2012-05-12 21:54:17.246   --当前问题时间点
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (19))
ORA-01594: attempt to wrap into rollback segment (19) extent (2) which is being freed

--通过trace文件,我们没有获得关于该错误的其他有用信息

查询MOS相关信息[280151.1]
出现该错误原因

This is a known problem and there is an Internal Bug:2181139 for this Issue.

The error is signaled because smon is shrinking a rollback segment and this fails 
because we need an extent to store some rollback information. This is a failure message 
for the shrinking. Subsequently smon would succeed in doing that.
--当smon在shrink rollback segment因为需要一个extent存放rollback

解决建议

Ignore these error messages.
Normally adding more undo space should solve the problem, 
but if space is not correcting the problem, please file an SR for assistance.

This error message logging is fixed in 10g.
--忽略该错误或者升级到10g
此条目发表在 ORA-xxxxx 分类目录,贴了 标签。将固定链接加入收藏夹。

9i库遇到ORA-01595/ORA-01594》有 2 条评论

  1. 惜分飞 说:

    OERR: ORA 1594 “attempt to wrap into rollback segment (%s) extent (%s) which i [ID 18992.1]

    Error:  ORA 1594
    Text:   attempt to wrap into rollback segment (%s) extent (%s) which is being fr
            eed
    -------------------------------------------------------------------------------
    Cause:  Undo generated to free a rollback segment extent is attempting
            to write into the same extent due to small extents and/or too
            many extents to free
    Action: The rollback segment shrinking will be rollbacked by the system;
            increase the optimal size of the rollback segment.
     
    
    *** Important: The notes below are for experienced users - See Note:22080.1
    
    
    Explanation:
            1594 is reported when a rollback segment is being shrunk but there is 
            not enough space in the current undo extent to complete the job. 
            Shrinking uses whatever is available in the current extent in the 
            rollback segment. If no more space is left and the extent you 
            would move into is one that is being freed you will get 1594. 
            This error is harmless. When you retry, chances are you will not get 
            the same error again. 
     
            Usually this is caused by running a transaction after a huge 
            transaction commits. Because of the setting of OPTIMAL, a very large 
            number of extents need to be deallocated all at once.
    
            One way to avoid this problem is to have larger extent size. 
            Another way is to have a larger OPTIMAL setting, so that only a smaller
            number of extents will be removed at one time. 
    
            SET TRANSACTION USE ROLLBACK SEGMENT is also a good idea for large
            jobs so you know which rollback segment they will use.
     
            
    Note:   There are changes to the way SMON shrinks rollback segments
            in 7.2. It should try to shrink a small number of extents at
            a time.
    
  2. 惜分飞 说:

    With AUM Enabled ORA-01594 and ORA-01595 Found in the alert.log [ID 280151.1]

    Applies to:
    Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.8 - Release: 9.2 to 9.2
    Information in this document applies to any platform.
    
    Symptoms
    The following errors are logged to alert.log:
    
    ORA-01595: error freeing extent (2) of rollback segment (10))
    ORA-01594: attempt to wrap into rollback segment (10) extent (2) which is being freed
    
    Automatic Undo Management is enabled.
    
    Cause
    This is a known problem and there is an Internal Bug:2181139 for this Issue.
    
    The error is signaled because smon is shrinking a rollback segment and this 
    fails because we need an extent to store some rollback information. 
    This is a failure message for the shrinking. Subsequently smon would succeed in doing that.
    
    Solution
    Ignore these error messages.
    Normally adding more undo space should solve the problem, 
    but if space is not correcting the problem, please file an SR for assistance.
    
    This error message logging is fixed in 10g.