oracle clsn00007,惜分飞 - 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 13429648788...

有朋友找到我们,系统断电之后,数据库无法正常启动,报ora-600 kcratr_scan_lastbwr错误

Thu Mar 25 20:33:45 2021

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: alter database mount exclusive

alter database open

Ping without log force is disabled

.

Thu Mar 25 20:33:47 2021

Beginning crash recovery of 1 threads

parallel recovery started with 32 processes

Thu Mar 25 20:33:47 2021

Started redo scan

Hex dump of (file 10, block 176517) in trace file C:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_4176.trc

Reading datafile 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\XFF.DBF' for corruption at rdba: 0x0282b185 (file 10, block 176517)

Reread (file 10, block 176517) found same corrupt data (logically corrupt)

Write verification failed for File 10 Block 176517 (rdba 0x282b185)

Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_4176.trc (incident=165355):

ORA-00600: ??????, ??: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []

Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\incident\incdir_165355\orcl_ora_4176_i165355.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Thu Mar 25 20:33:50 2021

Slave encountered ORA-10388 exception during crash recovery

Thu Mar 25 20:33:50 2021

Slave encountered ORA-10388 exception during crash recovery

Thu Mar 25 20:33:50 2021

Aborting crash recovery due to error 600

Thu Mar 25 20:33:59 2021

Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_4176.trc:

ORA-00600: ??????, ??: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []

Thu Mar 25 20:33:59 2021

Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_4176.trc:

ORA-00600: ??????, ??: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []

ORA-600 signalled during: alter database open...

故障原因,写丢失导致

Crash or instance recovery may fail because of a lost write even

though one of the mirrors has a good copy. Reading a file header

can corrupt a good mirror copy with a bad one.

Rediscovery Notes:

ORA-600 [kcratr_scan_lostwrt] or ORA-600 [kcratr_scan_lastbwr] are signaled

even though one of the mirrors has a good copy.

解决方案比较简单直接recover顺利open库