Advisory Message For ORA-8103 Shown On Alert File in 12.2 (Doc ID 2452395.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Alert log shows Advisory for ORA-8103

2018-07-28T09:49:28.990178+08:00
ADVISORY: Please collect redo for investigation of ORA-8103. Use command: >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ALTER SYSTEM DUMP REDO scn min 1 scn max 267096730531 dba min 2 3698 dba max 2 3698;
Hex dump of (file 2, block 3698) in trace file E:\<path>\trace\<oracle_sid>_j000_9520.trc

Corrupt block relative dba: 0x00800e72 (file 2, block 3698)
Bad header found during buffer read (logical check)
Data in bad block:
type: 35 format: 2 rdba: 0x00800e72
last change scn: 0x0000.003e.3034ab9a seq: 0x1 flg: 0x04
spare3: 0x0
consistency value in tail: 0xab9a2301
check value in block header: 0xa88
computed block checks

Failing statement

ORA-08103: object no longer exists
----- Current SQL Statement for this session (sql_id=bgu9gd2bjj7d1) -----
SELECT TABLESPACE_NAME FROM SYS.WRI$_HEATMAP_TOP_TABLESPACES

Call Stack :-

kcbgtcr ktrget2 kdst_fetch kdsttgr