ORA-600 kokiasg1故障分析---惜分飞

故障总结:客户正常关闭数据库,然后启动报ORA-600 kokiasg1错误,通过对启动分析确认是由于IDGEN1$序列丢失导致,修复该故障之后,数据库启动成功,但是后台大量报ORA-600 12803,ORA-600 15264等错误,业务用户无法登录.经过深入分析,发现数据库字典obj$中所有核心字典的序列全部被删除,但是在seq$中这些对象的obj#记录还存在.初步怀疑是有人恶意删除了obj$中字典核心序列对象导致.
数据库启动报ORA-600 kokiasg1错误

SQL> startup ; ORACLE 例程已经启动。 Total System Global Area 1.4531E+10 bytes Fixed Size                  2295256 bytes Variable Size            2181040680 bytes Database Buffers         1.2314E+10 bytes Redo Buffers               33193984 bytes 数据库装载完毕。 ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [], [], [], [], [], [] 进程 ID: 5628 会话 ID: 122 序列号: 3

对应的alert日志信息

Thu Jul 03 16:35:25 2025 Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Thu Jul 03 16:35:26 2025 Stopping background process CJQ0 Stopping background process QMNC Stopping background process MMNL Stopping background process MMON License high water mark = 272 All dispatchers and shared servers shutdown Thu Jul 03 16:35:54 2025 alter database close normal Thu Jul 03 16:35:54 2025 SMON: disabling tx recovery SMON: disabling cache recovery Thu Jul 03 16:35:54 2025 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 296590 Successful close of redo thread 1 Completed: alter database close normal alter database dismount Shutting down archive processes Archiving is disabled Completed: alter database dismount ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Thu Jul 03 16:36:02 2025 Stopping background process VKTM Thu Jul 03 16:36:07 2025 Instance shutdown complete Thu Jul 03 16:36:19 2025 Adjusting the default value of parameter parallel_max_servers from 640 to 270 due to the value of parameter processes (300) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 16 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =52 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Windows NT Version V6.2  CPU                 : 16 - type 8664, 8 Physical Cores Process Affinity    : 0x0x0000000000000000 Memory (Avail/Total): Ph:24712M/32767M, Ph+PgF:14089M/39123M System parameters with non-default values:   processes                = 300   sessions                 = 480   nls_language             = "SIMPLIFIED CHINESE"   nls_territory            = "CHINA"   sga_target               = 13920M   control_files            = "D:\APP\ADMINISTRATOR\ORADATA\orcl\CONTROL01.CTL"   control_files            =