problem:Corrupt block dba
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 fileReceived on Tue Oct 08 1996 - 00:00:00 CEST