problem:Corrupt block

From: Chi-Sharn Wu <swu_at_jolt.att.com>
Date: 1996/10/09
Message-ID: <325BBDFE.3353_at_jolt.att.com>#1/1


I got the error "Corrupt block" in trace files as follows. I need to recover it using old backup file. Is this an oracle bug ? Thanks in advance.

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

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 Wed Oct 09 1996 - 00:00:00 CEST

Original text of this message