标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,716)
- DB2 (22)
- MySQL (74)
- Oracle (1,576)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (160)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (575)
- Oracle安装升级 (94)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (81)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (28)
- SQL Server恢复 (9)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 不当使用_allow_resetlogs_corruption参数引起ORA-600 2662错误
- CSSD signal 11 in thread clssnmRcfgMgrThread故障处理
- 使用sid方式直接访问pdb(USE_SID_AS_SERVICE_LISTENER)
- ORA-00069: cannot acquire lock — table locks disabled for xxxx
- ORA-600 [4000] [a]相关bug
- sql server数据库“正在恢复”故障处理
- 如何判断数据文件是否处于begin backup状态
- CDM备份缺少归档打开数据库报ORA-600 kcbzib_kcrsds_1故障处理
- ORA-07445: exception encountered: core dump [expgod()+43] [IN_PAGE_ERROR]
- 2025年第一起ORA-600 16703故障恢复
- _gc_undo_affinity=FALSE触发ORA-01558
- public授权语句
- 中文环境显示AR8MSWIN1256(阿拉伯语字符集)
- 处理 Oracle 块损坏
- Oracle各种类型坏块说明和处理
- fio测试io,导致磁盘文件系统损坏故障恢复
- ORA-742 写丢失常见bug记录
- Oracle 19c 202501补丁(RUs+OJVM)-19.26
- 避免 19c 数据库性能问题需要考虑的事项 (Doc ID 3050476.1)
- Bug 21915719 Database hang or may fail to OPEN in 12c IBM AIX or HPUX Itanium – ORA-742, DEADLOCK or ORA-600 [kcrfrgv_nextlwn_scn] ORA-600 [krr_process_read_error_2]
标签归档:ORA-600 2662
数据库open报ORA-600 kcratr_scan_lastbwr故障处理
由于断电,导致数据库正常open报ORA-600 kcratr_scan_lastbwr错误
Wed Jan 17 18:23:26 2024 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 1028618590 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Wed Jan 17 18:23:30 2024 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 32 processes Started redo scan Hex dump of (file 3, block 144) in trace file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_66361.trc Reading datafile '/database/oracle/app/oracle/oradata/xff/datafile/o1_mf_undotbs1_hct7001s_.dbf' for corruption at rdba: 0x00c00090 (file 3, block 144) Reread (file 3, block 144) found same corrupt data (logically corrupt) Write verification failed for File 3 Block 144 (rdba 0xc00090) Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_66361.trc (incident=672241): ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [] Incident details in: /database/oracle/app/oracle/diag/rdbms/xff/xff/incident/incdir_672241/xff_ora_66361_i672241.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Aborting crash recovery due to error 600 Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_66361.trc: ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [] Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_66361.trc: ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [] ORA-600 signalled during: ALTER DATABASE OPEN...
尝试recover 数据库报ORA-600 3020错误
Wed Jan 17 18:28:38 2024 ALTER DATABASE RECOVER database Media Recovery Start started logmerger process Parallel Media Recovery started with 96 slaves Wed Jan 17 18:28:41 2024 Recovery of Online Redo Log: Thread 1 Group 2 Seq 410864 Reading mem 0 Mem# 0: /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_2_hct740hq_.log Wed Jan 17 18:28:42 2024 ORA-00600: internal error code, arguments: [3020], [3], [240], [12583152], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 240, file offset is 1966080 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 3: '/database/oracle/app/oracle/oradata/xff/datafile/o1_mf_undotbs1_hct7001s_.dbf' ORA-10560: block type 'KTU SMU HEADER BLOCK' Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Slave exiting with ORA-600 exception Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_pr19_68212.trc: ORA-00600: internal error code, arguments: [3020], [3], [240], [12583152], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 240, file offset is 1966080 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 3: '/database/oracle/app/oracle/oradata/xff/datafile/o1_mf_undotbs1_hct7001s_.dbf' ORA-10560: block type 'KTU SMU HEADER BLOCK' Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_68038.trc (incident=672243): ORA-00600: internal error code, arguments: [3020], [3], [240], [12583152], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 240, file offset is 1966080 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 3: '/database/oracle/app/oracle/oradata/xff/datafile/o1_mf_undotbs1_hct7001s_.dbf' ORA-10560: block type 'KTU SMU HEADER BLOCK' Wed Jan 17 18:28:43 2024 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Recovery Slave PR19 previously exited with exception 600 Wed Jan 17 18:28:43 2024 Sweep [inc][672865]: completed Media Recovery failed with error 448 Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_pr00_68115.trc: ORA-00283: recovery session canceled due to errors ORA-00448: normal completion of background process ORA-600 signalled during: ALTER DATABASE RECOVER database ...
加上隐含参数尝试强制拉库
alter database open resetlogs 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 6165467436 Clearing online redo logfile 1 /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_1_hct740fp_.log Clearing online log 1 of thread 1 sequence number 0 Clearing online redo logfile 1 complete Clearing online redo logfile 2 /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_2_hct740hq_.log Clearing online log 2 of thread 1 sequence number 0 Clearing online redo logfile 2 complete Clearing online redo logfile 3 /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_3_hct740k7_.log Clearing online log 3 of thread 1 sequence number 0 Clearing online redo logfile 3 complete Online log /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_1_hct740fp_.log: Thread 1 Group 1 was previously cleared Online log /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_2_hct740hq_.log: Thread 1 Group 2 was previously cleared Online log /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_3_hct740k7_.log: Thread 1 Group 3 was previously cleared Fri Jan 19 09:24:59 2024 Setting recovery target incarnation to 2 Initializing SCN for created control file Database SCN compatibility initialized to 3 Warning - High Database SCN: Current SCN value is 6165467439, threshold SCN value is 0 If you have not previously reported this warning on this database, please notify Oracle Support so that additional diagnosis can be performed. Fri Jan 19 09:24:59 2024 Assigning activation ID 1028784413 (0x3d52011d) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /database/oracle/app/oracle/oradata/xff/onlinelog/o1_mf_1_hct740fp_.log Successful open of redo thread 1 Fri Jan 19 09:24:59 2024 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Jan 19 09:24:59 2024 SMON: enabling cache recovery Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_84860.trc (incident=1344255): ORA-00600: internal error code, arguments: [2662], [1], [1870500147], [1], [1870515285], [12583040] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_84860.trc: ORA-00600: internal error code, arguments: [2662], [1], [1870500147], [1], [1870515285], [12583040] Errors in file /database/oracle/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_84860.trc: ORA-00600: internal error code, arguments: [2662], [1], [1870500147], [1], [1870515285], [12583040] Error 600 happened during db open, shutting down database USER (ospid: 84860): terminating the instance due to error 600 Instance terminated by USER, pid = 84860 ORA-1092 signalled during: alter database open resetlogs...
客户自行恢复到这一步,后面无法处理,接手之后进行恢复,其实后面比较简单了,就是修改下数据库scn,数据库就可以open起来,然后处理异常的undo和对象即可,可以参考以前类似文章:
ORA-600 2662快速恢复之Patch scn工具
硬件故障导致ORA-600 2662错误处理
ORA-00600 [2662]和ORA-00600 [4194]恢复
更多参考:惜分飞blog中ORA-600 2662文章
发表在 Oracle备份恢复
标签为 kcratr_scan_lastbwr, ORA-600 2662, ORA-600 3020, ORA-600 kcratr_scan_lastbwr
评论关闭
resetlogs强制拉库失败并使用备份system文件还原数据库故障处理
接手一个库,在open的过程中遭遇到ORA-600 2662错误
Sun May 26 10:15:54 2024 alter database open RESETLOGS 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 84303583 Clearing online redo logfile 1 /data/OracleData/xff/redo01.log Clearing online log 1 of thread 1 sequence number 8330 Clearing online redo logfile 1 complete Clearing online redo logfile 2 /data/OracleData/xff/redo02.log Clearing online log 2 of thread 1 sequence number 8327 Clearing online redo logfile 2 complete Clearing online redo logfile 3 /data/OracleData/xff/redo03.log Clearing online log 3 of thread 1 sequence number 8329 Clearing online redo logfile 3 complete Clearing online redo logfile 4 /data/OracleData/xff/redo04.log Clearing online log 4 of thread 1 sequence number 8328 Clearing online redo logfile 4 complete Resetting resetlogs activation ID 1431370398 (0x5550fa9e) Online log /data/OracleData/xff/redo01.log: Thread 1 Group 1 was previously cleared Online log /data/OracleData/xff/redo02.log: Thread 1 Group 2 was previously cleared Online log /data/OracleData/xff/redo03.log: Thread 1 Group 3 was previously cleared Online log /data/OracleData/xff/redo04.log: Thread 1 Group 4 was previously cleared Sun May 26 10:15:59 2024 Setting recovery target incarnation to 3 Sun May 26 10:15:59 2024 Read of datafile '/data/OracleData/xff/temp01.dbf' (fno 201) header failed with ORA-01200 Rereading datafile 201 header failed with ORA-01200 Errors in file /data/u01/app/oracle/diag/rdbms/xff/xff/trace/xff_dbw0_1563.trc: ORA-01186: file 201 failed verification tests ORA-01122: database file 201 failed verification check ORA-01110: data file 201: '/data/OracleData/xff/temp01.dbf' ORA-01200: actual file size of 3711 is smaller than correct size of 3712 blocks File 201 not verified due to error ORA-01122 Sun May 26 10:15:59 2024 Assigning activation ID 1509069065 (0x59f29109) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /data/OracleData/xff/redo01.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun May 26 10:15:59 2024 SMON: enabling cache recovery Errors in file /data/u01/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_1590.trc (incident=163897): ORA-00600: internal error code, arguments: [2662], [0], [84303590], [0], [84314659], [12583040] Incident details in:/data/u01/app/oracle/diag/rdbms/xff/xff/incident/incdir_163897/xff_ora_1590_i163897.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /data/u01/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_1590.trc: ORA-00600: internal error code, arguments: [2662], [0], [84303590], [0], [84314659], [12583040] Errors in file /data/u01/app/oracle/diag/rdbms/xff/xff/trace/xff_ora_1590.trc: ORA-00600: internal error code, arguments: [2662], [0], [84303590], [0], [84314659], [12583040] Error 600 happened during db open, shutting down database USER (ospid: 1590): terminating the instance due to error 600
然后客户使用备份的system01.dbf文件替换了被resetlogs之后文件,导致数据库后续操作无法继续
SQL> recover database; ORA-00283: recovery session canceled due to errors ORA-19909: datafile 1 belongs to an orphan incarnation ORA-01110: data file 1: '/data/OracleData/xff/system01.dbf'
这个问题比较简单,通过bbed或者Oracle Recovery Tools修改文件头相关信息,然后open数据库成功
重建控制文件丢失数据文件导致悲剧
Oracle Recovery Tools快速恢复ORA-19909
SQL> recover datafile 1; Media recovery complete. SQL> recover database; Media recovery complete. SQL> alter database open; Database altered.
但是由于system文件有大量坏块导致数据库无法正常登录和导出
[oracle@et-dbserver ~]$ exp "'/ as sysdba'" owner=USERNAME file=/tmp/2user.dmp log=/tmp/2user.log Export: Release 11.2.0.4.0 - Production on Sun May 26 13:00:50 2024 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. EXP-00056: ORACLE error 604 encountered ORA-00604: error occurred at recursive SQL level 1 ORA-01578: ORACLE data block corrupted (file # 1, block # 86500) ORA-01110: data file 1: '/data/OracleData/xff/system01.dbf' Username: / as sysdba EXP-00056: ORACLE error 604 encountered ORA-00604: error occurred at recursive SQL level 1 ORA-01578: ORACLE data block corrupted (file # 1, block # 86500) ORA-01110: data file 1: '/data/OracleData/xff/system01.dbf' Username: Password: EXP-00056: ORACLE error 604 encountered ORA-00604: error occurred at recursive SQL level 1 ORA-01578: ORACLE data block corrupted (file # 1, block # 86500) ORA-01110: data file 1: '/data/OracleData/xff/system01.dbf' ORA-01017: invalid username/password; logon denied EXP-00005: all allowable logon attempts failed EXP-00000: Export terminated unsuccessfully
通过dbv检查system数据文件
DBVERIFY: Release 11.2.0.4.0 - Production on Sun May 26 12:33:28 2024 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. DBVERIFY - Verification starting : FILE = /data/OracleData/xff/system01.dbf Page 1044 is influx - most likely media corrupt Corrupt block relative dba: 0x00400414 (file 1, block 1044) Fractured block found during dbv: Data in bad block: type: 0 format: 2 rdba: 0x00400414 last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05 spare1: 0x0 spare2: 0x0 spare3: 0x0 consistency value in tail: 0x1d7f550b check value in block header: 0xa354 computed block checksum: 0x6830 Page 1103 is marked corrupt Corrupt block relative dba: 0x0040044f (file 1, block 1103) Bad header found during dbv: Data in bad block: type: 0 format: 0 rdba: 0x00000000 last change scn: 0x508f.5f74492e seq: 0x53 flg: 0x0c spare1: 0xc spare2: 0xa6 spare3: 0xc757 consistency value in tail: 0x00000001 check value in block header: 0x8925 computed block checksum: 0x5d3b Page 1143 is marked corrupt Corrupt block relative dba: 0x00400477 (file 1, block 1143) Bad header found during dbv: Data in bad block: type: 0 format: 0 rdba: 0x00000001 last change scn: 0x65c4.52eb202e seq: 0x28 flg: 0x0e spare1: 0xe spare2: 0xe2 spare3: 0xfa46 consistency value in tail: 0x00000001 check value in block header: 0x6405 computed block checksum: 0x28b1 ……………… Page 124805 is influx - most likely media corrupt Corrupt block relative dba: 0x0041e785 (file 1, block 124805) Fractured block found during dbv: Data in bad block: type: 6 format: 2 rdba: 0x0041e785 last change scn: 0x0000.0434fc6c seq: 0x2 flg: 0x04 spare1: 0x0 spare2: 0x0 spare3: 0x0 consistency value in tail: 0x1991255b check value in block header: 0x6386 computed block checksum: 0x1384 DBVERIFY - Verification complete Total Pages Examined : 130560 Total Pages Processed (Data) : 95634 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 14949 Total Pages Failing (Index): 0 Total Pages Processed (Other): 1774 Total Pages Processed (Seg) : 1669 Total Pages Failing (Seg) : 0 Total Pages Empty : 16251 Total Pages Marked Corrupt : 283 Total Pages Influx : 149 Total Pages Encrypted : 0 Highest block SCN : 84314727 (0.84314727)
对于这样问题,通过Oracle Recovery Tools实战批量坏块修复,实现数据库可以完美导出数据
存储故障后oracle报—ORA-01122/ORA-01207故障处理
客户存储异常,通过硬件恢复解决存储故障之后,oracle数据库无法正常启动(存储cache丢失),尝试recover数据库报ORA-00283 ORA-01122 ORA-01110 ORA-01207错误
以前处理过比较类似的存储故障case:
又一起存储故障导致ORA-00333 ORA-00312恢复
存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理
SQL> recover database until cancel; ORA-00283: 恢复会话因错误而取消 ORA-01122: 数据库文件 536 验证失败 ORA-01110: 数据文件 536: '+DATA/orcl/dt_img_dat511.ora' ORA-01207: 文件比控制文件更新 - 旧的控制文件
Sun May 05 00:09:03 2024 ALTER DATABASE RECOVER database until cancel Media Recovery Start started logmerger process Sun May 05 00:09:10 2024 SUCCESS: diskgroup FRA was mounted Sun May 05 00:09:10 2024 NOTE: dependency between database orcl and diskgroup resource ora.FRA.dg is established Sun May 05 00:09:14 2024 WARNING! Recovering data file 1 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. Media Recovery failed with error 1122 Slave exiting with ORA-283 exception Errors in file d:\app\administrator\diag\rdbms\orcl\orcl1\trace\orcl1_pr00_8048.trc: ORA-00283: 恢复会话因错误而取消 ORA-01122: 数据库文件 536 验证失败 ORA-01110: 数据文件 536: '+DATA/orcl/dt_img_dat511.ora' ORA-01207: 文件比控制文件更新 - 旧的控制文件 Sun May 05 00:09:16 2024 Recovery Slave PR00 previously exited with exception 283 ORA-283 signalled during: ALTER DATABASE RECOVER database until cancel ...
using backup controlfile进行恢复
SQL> recover database using backup controlfile until cancel; ORA-00279: 更改 18646239951 (在 04/25/2024 17:14:50 生成) 对于线程 1 是必需的 ORA-00289: 建议: +FRA/orcl/archivelog/2024_04_25/thread_1_seq_1003886.199435.1167240505 ORA-00280: 更改 18646239951 (用于线程 1) 在序列 #1003886 中 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} auto ORA-00279: 更改 18646239951 (在 04/25/2024 17:11:40 生成) 对于线程 2 是必需的 ORA-00289: 建议: +FRA/orcl/archivelog/2024_04_25/thread_2_seq_677876.199531.1167239807 ORA-00280: 更改 18646239951 (用于线程 2) 在序列 #677876 中 ORA-00279: 更改 18646255791 (在 04/25/2024 17:16:46 生成) 对于线程 2 是必需的 ORA-00289: 建议: +FRA/orcl/archivelog/2024_04_25/thread_2_seq_677877.199472.1167240099 ORA-00280: 更改 18646255791 (用于线程 2) 在序列 #677877 中 ORA-00278: 此恢复不再需要日志文件 '+FRA/orcl/archivelog/2024_04_25/thread_2_seq_677876.199531.1167239807' ORA-00279: 更改 18646295647 (在 04/25/2024 17:21:38 生成) 对于线程 2 是必需的 ORA-00289: 建议: +FRA/orcl/archivelog/2024_04_25/thread_2_seq_677878.199379.1167240623 ORA-00280: 更改 18646295647 (用于线程 2) 在序列 #677878 中 ORA-00278: 此恢复不再需要日志文件 '+FRA/orcl/archivelog/2024_04_25/thread_2_seq_677877.199472.1167240099' ORA-00279: 更改 18646331784 (在 04/25/2024 17:28:25 生成) 对于线程 1 是必需的 ORA-00289: 建议: +FRA/orcl/archivelog/2024_04_25/thread_1_seq_1003887.199320.1167241507 ORA-00280: 更改 18646331784 (用于线程 1) 在序列 #1003887 中 ORA-00278: 此恢复不再需要日志文件 '+FRA/orcl/archivelog/2024_04_25/thread_1_seq_1003886.199435.1167240505' ORA-00308: 无法打开归档日志 '+FRA/orcl/archivelog/2024_04_25/thread_1_seq_1003887.199320.1167241507' ORA-17503: ksfdopn: 2 未能打开文件 +FRA/orcl/archivelog/2024_04_25/thread_1_seq_1003887.199320.1167241507 ORA-15012: ASM file '+FRA/orcl/archivelog/2024_04_25/thread_1_seq_1003887.199320.1167241507' does not exist ORA-10879: error signaled in parallel recovery slave ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误 ORA-01194: 文件 1 需要更多的恢复来保持一致性 ORA-01110: 数据文件 1: '+DATA/orcl/system01.dbf'
通过分析,确认由于cache丢失导致thread_1_seq_1003887这个日志丢失(而且redo已经被覆盖)

数据库无法通过正常recover的思路解决.通过屏蔽一致性,强制打开数据库,alert日志报ORA-600 2662错误
Sat May 04 17:23:00 2024 Redo thread 2 internally disabled at seq 1 (CKPT) ARC1: Archiving disabled thread 2 sequence 1 Archived Log entry 2 added for thread 2 sequence 1 ID 0x0 dest 1: ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Errors in file d:\app\administrator\diag\rdbms\orcl\orcl1\trace\orcl1_ora_3684.trc (incident=47066): ORA-00600: ??????, ??: [2662], [4], [1466533588], [4], [1466584862], [12583040], [], [], [], [], [], [] Errors in file d:\app\administrator\diag\rdbms\orcl\orcl1\trace\orcl1_ora_3684.trc: ORA-00600: ??????, ??: [2662], [4], [1466533588], [4], [1466584862], [12583040], [], [], [], [], [], [] Errors in file d:\app\administrator\diag\rdbms\orcl\orcl1\trace\orcl1_ora_3684.trc: ORA-00600: ??????, ??: [2662], [4], [1466533588], [4], [1466584862], [12583040], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 3684): terminating the instance due to error 600 Instance terminated by USER, pid = 3684 ORA-1092 signalled during: alter database open resetlogs...
通过修改数据库scn,open数据库报ORA-600 4137
Sun May 05 00:12:41 2024 replication_dependency_tracking turned off (no async multimaster replication found) LOGSTDBY: Validating controlfile with logical metadata LOGSTDBY: Validation complete Completed: alter database open resetlogs Sun May 05 00:12:56 2024 Trace dumping is performing id=[cdmp_20240505001256] Sun May 05 00:12:56 2024 ORACLE Instance orcl1 (pid = 22) - Error 600 encountered while recovering transaction (28, 21). Errors in file d:\app\administrator\diag\rdbms\orcl\orcl1\trace\orcl1_smon_5896.trc: ORA-00600: ??????, ??: [4137], [28.21.42965783], [0], [0], [], [], [], [], [], [], [], []
这个错误比较明显,由于28号回滚段异常导致,对异常回滚段进行处理,重建undo,数据库恢复主要工作完成