技术头条 - 一个快速在微博传播文章的方式     搜索本站
您现在的位置首页 --> Oracle --> undo异常总结和恢复思路

undo异常总结和恢复思路

浏览:3540次  出处信息

   UNDO异常报错千奇百怪,针对本人遇到的比较常见的undo异常报错进行汇总,仅供参考,数据库恢复过程是千奇百怪的,不能照搬硬套.

   ORA-00704/ORA-00376

   ORA-00704: bootstrap process failure

   ORA-00604: error occurred at recursive SQL level 2

   ORA-00376: file 3 cannot be read at this time

   ORA-01110: data file 3: ‘/u01/oracle/oradata/ora11g/undotbs01.dbf’

   Error 704 happened during db open, shutting down database

   USER (ospid: 17864): terminating the instance due to error 704

   Instance terminated by USER, pid = 17864

   ORA-1092 signalled during: alter database open…

   opiodr aborting process unknown ospid (17864) as a result of ORA-1092

   

   ORA-00600[4097]

   Fri Aug 31 23:14:10 2012

   Errors in file /u01/oradata/orcl/bdump/orcl_smon_15589.trc:

   ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

   Fri Aug 31 23:14:12 2012

   Non-fatal internal error happenned while SMON was doing logging scn->time mapping.

   SMON encountered 1 out of maximum 100 non-fatal internal errors.

   

   ORA-01595/ORA-00600[4194]

   Fri Aug 31 23:14:14 2012

   Errors in file /u01/oradata/orcl/bdump/orcl_smon_15589.trc:

   ORA-01595: error freeing extent (2) of rollback segment (4))

   ORA-00607: Internal error occurred while making a change to a data block

   ORA-00600: internal error code, arguments: [4194], [48], [34], [], [], [], [], []

   

   0RA-00600[4193]

   Tue Feb 14 09:35:34 2012

   Errors in file d:\oracle\product\10.2.0\admin\interlib\udump\interlib_ora_2824.trc:

   ORA-00603: ORACLE server session terminated by fatal error

   ORA-00600: internal error code, arguments: [4193], [2005], [2008], [], [], [], [], []

   

   ORA-00600[kcfrbd_3]

   Wed Dec 05 10:26:35 2012

   SMON: enabling tx recovery

   Wed Dec 05 10:26:35 2012

   Database Characterset is ZHS16GBK

   Wed Dec 05 10:26:35 2012

   Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_548.trc:

   ORA-00600: internal error code, arguments: [kcfrbd_3], [2], [2279045], [1], [2277120], [2277120], [], []

   SMON: terminating instance due to error 474

   

   ORA-00600[4137]

   Fri Jul  6 18:00:40 2012

   SMON: ignoring slave err,downgrading to serial rollback

   Fri Jul  6 18:00:41 2012

   Errors in file /usr/local/oracle/admin/techdb/bdump/techdb_smon_16636.trc:

   ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []

   ORACLE Instance techdb (pid = 8) - Error 600 encountered while recovering transaction (3, 17).

   

   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

   

   ORA-00704/ORA-01555

   Fri May  4 21:04:21 2012

   select ctime, mtime, stime from obj$ where obj# = :1

   Fri May  4 21:04:21 2012

   Errors in file /oracle/admin/standdb/udump/perfdb_ora_1286288.trc:

   ORA-00704: bootstrap process failure

   ORA-00704: bootstrap process failure

   ORA-00604: error occurred at recursive SQL level 1

   ORA-01555: snapshot too old: rollback segment number 40 with name “_SYSSMU40$” too small

   Error 704 happened during db open, shutting down database

   USER: terminating instance due to error 704

   Instance terminated by USER, pid = 1286288

   ORA-1092 signalled during: alter database open resetlogs…

   

   ORA-00607/ORA-00600[4194]

   Block recovery completed at rba 3994.5.16, scn 0.89979533

   Thu Jul 26 13:21:11 2012

   Errors in file /orasvr/admin/mispdata/udump/mispdata_ora_2865.trc:

   ORA-00604: error occurred at recursive SQL level 1

   ORA-00607: Internal error occurred while making a change to a data block

   ORA-00600: internal error code, arguments: [4194], [31], [2], [], [], [], [], []

   Error 604 happened during db open, shutting down database

   USER: terminating instance due to error 604

   Instance terminated by USER, pid = 2865

   ORA-1092 signalled during: ALTER DATABASE OPEN…

   

   ORA-00704/ORA-00600[4000]

   Thu Feb 28 19:29:13 2013

   Errors in file /u1/PROD/prodora/db/tech_st/10.2.0/admin/PROD_oracle/udump/prod_ora_20989.trc:

   ORA-00704: bootstrap process failure

   ORA-00704: bootstrap process failure

   ORA-00600: internal error code, arguments: [4000], [50], [], [], [], [], [], []

   Thu Feb 28 19:29:13 2013

   Error 704 happened during db open, shutting down database

   USER: terminating instance due to error 704

   Instance terminated by USER, pid = 20989

   ORA-1092 signalled during: ALTER DATABASE OPEN RESETLOGS…

   

   undo异常恢复处理思路

   除了极少数undo坏块,undo文件丢失外,大部分undo异常是因为redo未被正常进行前滚,从而导致undo回滚异常数据库无法open,解决此类问题,需要结合一般需要结合redo异常处理技巧在其中,一般undo异常处理思路

   1.切换undo_management= MANUAL尝试启动数据库,如果不成功进入2

   2.设置10513 等event尝试启动数据库,如果不成功进入3

   3.使用_offline_rollback_segments/_corrupted_rollback_segments屏蔽回滚段

   4.如果依然不能open数据库,考虑使用bbed工具提交事务,修改回滚段状态等操作

   5.如果依然还不能open数据库,考虑使用dul

   

   如果您按照上述步骤还不能解决,请联系我们,将为您提供专业数据库技术支持

   Phone:13429648788       Q Q:107644445      E-Mail:dba@xifenfei.com

   

   姊妹篇

   ORACLE REDO各种异常恢复

   ORACLE丢失各种文件导致数据库不能OPEN恢复

建议继续学习:

  1. undo异常事务回滚规则分析    (阅读:3577)
  2. Oracle In-memory Undo运作原理    (阅读:2608)
QQ技术交流群:445447336,欢迎加入!
扫一扫订阅我的微信号:IT技术博客大学习
© 2009 - 2024 by blogread.cn 微博:@IT技术博客大学习

京ICP备15002552号-1