ORA-00600 [4194] 故障处理
1. 问题现象
启动数据库,数据进行实例恢复完成后,能成功open,但数据库在几分钟后自动宕掉,通过alert日志,可以看到宕库前报错是ORA-00600 arguments: [4194]。
alter database open
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan -----> 扫描redo,进行实例恢复
Completed redo scan
read 149 KB redo, 107 data blocks need recovery
Started redo application at
Thread 1: logseq 84918, block 3
Recovery of Online Redo Log: Thread 1 Group 3 Seq 84918 Reading mem 0
Mem# 0: /data/orauser01/app/oradata/orcl/redo03.log
Completed redo application of 0.12MB -----> 进行实例恢复完成
Completed crash recovery at
Thread 1: logseq 84918, block 302, scn 13343268733370
107 data blocks read