数据库open报ORA-600 kcratr_scan_lastbwr故障处理---惜分飞

联系：手机/微信(+86 17813235971) QQ(107644445)

标题：数据库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文章

• ORA-600 kcrf_resilver_log_1故障处理
• ORA-00742 ORA-00312 恢复
• Patch SCN工具快速解决ORA-600 2662问题
• ORA-01595/ORA-600 4194处理
• ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], []
• ORA-00322 ORA-00312恢复
• ORA-600 3020/ORA-600 2662故障
• ORA-600 kcbzib_kcrsds_1报错
• 硬件故障数据库异常恢复
• 正常open库报ORA-600 2662,ORA-600 4097错误
• 又一例ORA-600 kcratr_nab_less_than_odr
• ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因