Oracle 19c异常恢复—ORA-01209/ORA-65088---惜分飞

由于raid卡bug故障,导致文件系统异常,从而使得数据库无法正常启动,客户找到我之前已经让多人分析,均未恢复成功,查看alert日志,发现他们恢复的时候尝试resetlogs库,然后报ORA-600 kcbzib_kcrsds_1错误

2024-09-15T17:07:32.553215+08:00 alter database open resetlogs 2024-09-15T17:07:32.569110+08:00 RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 274757454692 time .... (PID:8074): Clearing online redo logfile 1 /opt/oracle/oradata/XFF/onlinelog/o1_mf_1_j3k201g9_.log .... (PID:8074): Clearing online redo logfile 2 /opt/oracle/oradata/XFF/onlinelog/o1_mf_2_j3k201h3_.log .... (PID:8074): Clearing online redo logfile 3 /opt/oracle/oradata/XFF/onlinelog/o1_mf_3_j3k201hk_.log Clearing online log 1 of thread 1 sequence number 0 Clearing online log 2 of thread 1 sequence number 0 Clearing online log 3 of thread 1 sequence number 0 2024-09-15T17:07:34.939550+08:00 .... (PID:8074): Clearing online redo logfile 1 complete .... (PID:8074): Clearing online redo logfile 2 complete .... (PID:8074): Clearing online redo logfile 3 complete Online log /opt/oracle/oradata/XFF/onlinelog/o1_mf_1_j3k201g9_.log: Thread 1 Group 1 was previously cleared Online log /opt/oracle/fast_recovery_area/XFF/onlinelog/o1_mf_1_j3k201l4_.log: Thread 1 Group 1 was previously cleared Online log /opt/oracle/oradata/XFF/onlinelog/o1_mf_2_j3k201h3_.log: Thread 1 Group 2 was previously cleared Online log /opt/oracle/fast_recovery_area/XFF/onlinelog/o1_mf_2_j3k201kw_.log: Thread 1 Group 2 was previously cleared Online log /opt/oracle/oradata/XFF/onlinelog/o1_mf_3_j3k201hk_.log: Thread 1 Group 3 was previously cleared Online log /opt/oracle/fast_recovery_area/XFF/onlinelog/o1_mf_3_j3k201mt_.log: Thread 1 Group 3 was previously cleared 2024-09-15T17:07:34.966674+08:00 Setting recovery target incarnation to 2 2024-09-15T17:07:34.992357+08:00 Ping without log force is disabled:   instance mounted in exclusive mode. Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED 2024-09-15T17:07:34.994329+08:00 Crash Recovery excluding pdb 2 which was cleanly closed. 2024-09-15T17:07:34.994390+08:00 Crash Recovery excluding pdb 3 which was cleanly closed. 2024-09-15T17:07:34.994433+08:00 Crash Recovery excluding pdb 4 which was cleanly closed. 2024-09-15T17:07:34.994474+08:00 Crash Recovery excluding pdb 5 which was cleanly closed. Initializing SCN for created control file Database SCN compatibility initialized to 3 Endian type of dictionary set to little 2024-09-15T17:07:35.001752+08:00 Assigning activation ID 2966012017 (0xb0c9c071) Redo log for group 1, sequence 1 is not located on DAX storage 2024-09-15T17:07:35.015921+08:00 TT00 (PID:8113): Gap Manager starting 2024-09-15T17:07:35.034047+08:00 Thread 1 opened at log sequence 1   Current log# 1 seq# 1 mem# 0: /opt/oracle/oradata/XFF/onlinelog/o1_mf_1_j3k201g9_.log   Current log# 1 seq# 1 mem# 1: /opt/oracle/fast_recovery_area/XFF/onlinelog/o1_mf_1_j3k201l4_.log Successful open of redo thread 1 2024-09-15T17:07:35.034573+08:00 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set stopping change tracking 2024-09-15T17:07:35.063726+08:00 TT03 (PID:8119): Sleep 5 seconds and then try to clear SRLs in 2 time(s) 2024-09-15T17:07:35.129748+08:00 Undo initialization recovery: Parallel FPTR failed: start:2528681 end:2528684 diff:3 ms (0.0 seconds) Errors in file /opt/oracle/diag/rdbms/xff/XFF/trace/XFF_ora_8074.trc  (incident=146455) (PDBNAME=CDB$ROOT): ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /opt/oracle/d