| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Corrupted data blocks in tablespace SYSTEM
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.
<SPAN
class=448193617-03122001>Is there a way to get around this problem without
re-creating the database?
<SPAN
class=448193617-03122001>
<SPAN
class=448193617-03122001>
When
executing my script to get corrupted data block information , I get the
following:
<SPAN
class=448193617-03122001>ORA-01578: ORACLE data block corrupted (file # 1, block
# 2660)ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
<SPAN
class=448193617-03122001>
<SPAN
class=448193617-03122001>
Trace
file information.
<SPAN
class=448193617-03122001>
Dump
file /u01/app/oracle/admin/TIE/udump/tie_ora_11859.trcOracle8 Release
8.0.5.0.0 - ProductionPL/SQL Release 8.0.5.0.0 - ProductionORACLE_HOME =
/u01/app/oracle/product/8.0.5System name: SunOSNode
name:
edi-01Release:
5.7Version:
Generic_106541-17Machine:
sun4uInstance name: TIERedo thread mounted by this instance: 1Oracle
process number: 12Unix 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
readData in bad block - type:0. format:0. rdba:0x00090255last change
scn:0x0000.3c07e0da seq:0x0 flg:0xb1consistancy value in tail
0xffffffffcheck value in block header: 0x10, check value not
calculatedspare1:0x0, spare2:0x0, spare2:0xd40Reread of rdba=180af98
file=6. blocknum=44952. found same corupted data***
<SPAN
class=448193617-03122001>Corrupt block relative dba: 0x0180af98 file=6.
blocknum=44952.Bad header found during buffer readData in bad block -
type:0. format:0. rdba:0x00090255last change scn:0x0000.3c07e0da seq:0x0
flg:0xb1consistancy value in tail 0xffffffffcheck value in block header:
0x10, check value not calculatedspare1:0x0, spare2:0x0,
spare2:0xd40Reread 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 readData in bad block -
type:0. format:0. rdba:0x00090255last change scn:0x0000.3c07e0da seq:0x0
flg:0xb1consistancy value in tail 0xffffffffcheck value in block header:
0x10, check value not calculatedspare1:0x0, spare2:0x0,
spare2:0xd40Reread 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 readData in bad block -
type:0. format:0. rdba:0x00090255last change scn:0x0000.3c07e0da seq:0x0
flg:0xb1consistancy value in tail 0xffffffffcheck value in block header:
0x10, check value not calculatedspare1:0x0, spare2:0x0,
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same
corupted data***
<SPAN
class=448193617-03122001>Corrupt block relative dba: 0x0180af98 file=6.
blocknum=44952.Bad header found during buffer readData in bad block -
type:0. format:0. rdba:0x00090255last change scn:0x0000.3c07e0da seq:0x0
flg:0xb1consistancy value in tail 0xffffffffcheck value in block header:
0x10, check value not calculatedspare1:0x0, spare2:0x0,
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same
corupted data
Kevin
Received on Mon Dec 03 2001 - 12:08:53 CST
 |
 |