首页 > 其他分享 >ORA-600 ksuloget2 恢复---惜分飞

ORA-600 ksuloget2 恢复---惜分飞

时间：2023-08-19 22:13:45浏览次数：41  
标签：00600 600 error 分飞 --- orcl code ksuloget2 ORA

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

标题：ORA-600 ksuloget2 恢复

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

客户在win 32位的操作系统上调至sga超过2G,数据库运行过程中报ORA-600 ksuloget2错误

Thread 1 cannot allocate new log, sequence 43586 Checkpoint not complete   Current log# 1 seq# 43585 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG Fri Aug 04 14:57:02 2023 Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_42996.trc  (incident=67481): ORA-00600: 内部错误代码, 参数: [ksuloget2], [0xFEBA6208], [0xFEBA3B08], [500], [0xFEBA622C], [], [], [], [], [] Thread 1 advanced to log sequence 43586 (LGWR switch)   Current log# 2 seq# 43586 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG

重启数据库,进行尝试恢复继续报ORA-600 ksuloget2

Thu Aug 17 17:38:27 2023 ALTER DATABASE RECOVER  database using backup controlfile  Media Recovery Start  started logmerger process Parallel Media Recovery started with 24 slaves ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup controlfile  ... Thu Aug 17 17:39:01 2023 ALTER DATABASE RECOVER LOGFILE 'D:\oracle\flash_recovery_area\orcl\ARCHIVELOG\2023_08_04\REDO03.LOG'  Media Recovery Log D:\oracle\flash_recovery_area\orcl\ARCHIVELOG\2023_08_04\REDO03.LOG Thu Aug 17 17:39:01 2023 Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc  (incident=110724): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00342: archived log does not have expected resetlogs SCN 685171428 ORA-00334: archived log: 'D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2023_08_04\REDO03.LOG' Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc: ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00342: archived log does not have expected resetlogs SCN 685171428 ORA-00334: archived log: 'D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2023_08_04\REDO03.LOG' Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_5604.trc  (incident=110709): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00342: archived log does not have expected resetlogs SCN 685171428 ORA-00334: archived log: 'D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2023_08_04\REDO03.LOG' Incident details in: d:\oracle\diag\rdbms\orcl\orcl\incident\incdir_110709\orcl_ora_5604_i110709.trc ORA-600 signalled during:ALTER DATABASE RECOVER LOGFILE 'D:\oracle\flash_recovery_area\orcl\2023_08_04\REDO03.LOG' ALTER DATABASE RECOVER CANCEL Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc  (incident=110725): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc  (incident=110726): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc: ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc  (incident=110727): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_pr00_5528.trc  (incident=110728): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_5604.trc  (incident=110710): ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [], [] ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBA6E38], [0xFEBA3B08], [500], [0xFEBA6E5C], [], [], [ Incident details in: d:\oracle\diag\rdbms\orcl\orcl\incident\incdir_110710\orcl_ora_5604_i110710.trc

由于是应用日志失败,屏蔽日志一致性,强制打开数据库,检查数据ok,业务可以直接使用,对于这类问题,官方建议:ORA-600: [Ksuloget2] Hit on Windows When SGA Greater Than 1G (Doc ID 836109.1)
20230819105750

标签：00600,600,error,分飞,---,orcl,code,ksuloget2,ORA
From： https://www.cnblogs.com/xifenfei/p/17643233.html

相关文章

  • OceanBase-系统回收日志参数验证enable_syslog_recycle和max_syslog_file_count
    作者：刘书盛热衷技术分享、编写技术文档原创作品oceanbase数据库原创内容未经授权不得随意使用、转载请联系小编并注明来源,谢谢！1、参数介绍enable_syslog_recycle     用于是否打开记录启动前的旧日志的开关   max_syslog_file_count  用于设置在回收......
  • mybatis-plus公共字段自动填充与ThreadLocal
    1、为什么使用mybatisplus自动填充在项目开发中，我们会发现有一些数据库表字段是每个表都有的，在之前针对这些字段我们的目前的处理方式就是增加或者修改的时候一个一个的去赋值，如果都按这样的方法进行操作的话，那我们就需要在每个业务方法中进行操作，这样会显得我们的代码过于冗余......
  • 红帽认证RedHat-RHCSA shell的基本应用用户和组管理网络配置和防火墙管理笔记汇总
    shell命令概述Shell作用：命令解释器介于操作系统内核与用户之间，负责解释命令行获得命令帮助内部命令help命令的“--help”选项使用man命令阅读手册页命令行编辑的几个辅助操作Tab键：自动补齐反斜杠“\”：强制换行快捷键Ctrl+U：清空至行首快捷键Ctrl+K：清空至行尾快捷键Ctr......
  • shell命令概述 Shell作用：命令解释器 介于操作系统内核与用户之间，负责解释命令行 获得
    shell命令概述Shell作用：命令解释器介于操作系统内核与用户之间，负责解释命令行获得命令帮助内部命令help命令的“--help”选项使用man命令阅读手册页命令行编辑的几个辅助操作Tab键：自动补齐反斜杠“\”：强制换行快捷键Ctrl+U：清空至行首快捷键Ctrl+K：清空至行尾快捷键Ctr......
  • Kotlin-大师班 第二章-随笔
    1.AppCompatActicity.onCreate()每次Activity创建时调用。Activity对应一个屏幕，如果你的应用程序中有多个屏幕，如登录屏幕、客人资料等，所有这些都是不同的Activity。 可以理解为Activity对等于屏幕。2. setContentView设置View的内容。R代表Resources3.sp：......
  • AQS源码解读之ReentrantLock-图解
    1.背景1.AQS简介AQS全称为AbstractQueuedSynchronizer(抽象队列同步器)。AQS是一个用来构建锁和其他同步组件的基础框架，使用AQS可以简单且高效地构造出应用广泛的同步器，例如ReentrantLock、Semaphore、ReentrantReadWriteLock和FutureTask等等。2.原理AQS核心思想是，如果被请求的......
  • ARTS打卡---第一周
    Algorithm力扣中等题：2816. 翻倍以链表形式表示的数字解题思路：双指针遍历，第一个节点大于10，则增加一个节点作为头节点。ReviewGoogle的分布式存储经典论文，Bigtable:ADistributedStorageSystemforStructuredData，论文下载地址：https://www.modb.pro/doc/7759阅读完一部分......
  • 2-14-Gateway网关-路由断言工厂[15-Gateway网关-路由的过滤器配置]
    所谓的断言工厂与过滤器都是通过yml配置生效以下都将从配置的角度说明如何配置具体哪一个怎么用可以直接访问spring官网查看spring:cloud:gateway:routes:-id:user-serviceuri:lb://userservicepredicates:-Path=/us......
  • 欧几里得算法（辗转相除法）-- 计算两个数的最大公约数
    博客地址：https://www.cnblogs.com/zylyehuo/#-*-coding:utf-8-*-#递归defgcd(a,b):ifb==0:returnaelse:returngcd(b,a%b)print(gcd(12,16))#非递归defgcd2(a,b):whileb>0:r=a%ba=b......
  • WebRTC（Web实时通信）的介绍和应用 - 实现点对点视频通话和屏幕共享
    点对点视频通话使用WebRTC可以在两个浏览器之间建立点对点的视频通话连接。以下是建立点对点视频通话连接的步骤：获取本地媒体流，并将其显示在页面中；将本地媒体流发送到远程浏览器；接收远程浏览器发送的媒体流，并将其显示在页面中。以下是一个简单的示例，演示了如何使用WebRTC实......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99