problem:Corrupt block dba

From: Chi-Sharn Wu <swu_at_jolt.att.com>
Date: 1996/10/08
Message-ID: <325ACEB9.7309_at_jolt.att.com>#1/1


Hi:
  I got "Corrupt block dba" message from oracle trace file like follows. I check the disk which seems OK. Is this a oracle bug ? Thanks for any inof.

Chi Wu
swu_at_probe.att.com

  • Trace Files =============================== Dump file /dbms/oracle/rdbms/log/tspp_ora_16707.trc Oracle7 Server Release 7.2.2.3.0 - Production Release With the distributed and replication options PL/SQL Release 2.2.2.3.0 - Production ORACLE_HOME = /dbms/oracle ORACLE_SID = tspp Oracle process number: 27 Unix process id: 16707 System name: SunOS Node name: ks92 Release: 5.4 Version: Generic_101945-37 Machine: sun4d

Mon Oct 7 19:48:32 1996
*** SESSION ID:(104.1630) 1996.10.07.19.48.32.000
***
Corrupt block dba: 0x08000002 file=2. blocknum=2. found during buffer read
on disk type:5. ver:1. dba: 0x0c000002 inc:0x00000001 seq:0x0000019d incseq:0x00
01019d

Dump file /dbms/oracle/rdbms/log/tspp_lgwr_879.trc Oracle7 Server Release 7.2.2.3.0 - Production Release With the distributed and replication options PL/SQL Release 2.2.2.3.0 - Production
ORACLE_HOME = /dbms/oracle
ORACLE_SID = tspp
Oracle process number: 5 Unix process id: 879 System name: SunOS

Node name:      ks92
Release:        5.4
Version:        Generic_101945-37
Machine:        sun4d

Mon Oct 7 20:25:54 1996
*** SESSION ID:(4.1) 1996.10.07.20.25.54.000

ORA-01171: datafile 2 going offline due to error advancing checkpoint
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: '/db_data1/oracle/tsppdata1.dbf'
ORA-01204: file number is 3 rather than 2 - wrong file
Received on Tue Oct 08 1996 - 00:00:00 CEST

Original text of this message