I have
just started a project and have encountered a database problem. The previous DBA
did not create any backup scripts or backup and recovery plans.
Is there a way to get around this problem without
re-creating the database?
When
executing my script to get corrupted data block information , I get the
following:
ORA-01578: ORACLE data block corrupted (file # 1, block
# 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
Trace
file information.
Dump
file /u01/app/oracle/admin/TIE/udump/tie_ora_11859.trc
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.0.5
System name: SunOS
Node name: edi-01
Release: 5.7
Version: Generic_106541-17
Machine: sun4u
Instance name: TIE
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 11859, image: oracleTIE
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.0.5
System name: SunOS
Node name: edi-01
Release: 5.7
Version: Generic_106541-17
Machine: sun4u
Instance name: TIE
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 11859, image: oracleTIE
***
SESSION ID:(13.50289) 2001.11.30.15.00.00.000
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6.
blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6.
blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x0000.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0xffffffff
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
Kevin
