Database Administration (MOSC)

MOSC Banner

Corrupt blocks in the data file of READ ONLY table space

edited Jan 23, 2014 3:37AM in Database Administration (MOSC) 6 commentsAnswered
Hi,

We have a 10.2.0.4 database and while running dbverify on one of the datafiles we found corrupt blocks
The table space was READ WRITE before we made it READ ONLY a while ago


DBVERIFY: Release 10.2.0.4.0 - Production on Wed Jan 22 20:03:08 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


DBVERIFY - Verification starting : FILE = E:\ORACLE\ORADATA\IMG2005Q3_18.DBF
Page 293283 is marked corrupt
Corrupt block relative dba: 0x9b8479a3 (file 622, block 293283)
Bad check value found during dbv:
Data in bad block:
 type: 40 format: 2 rdba: 0x9b8479a3
 last change scn: 0x0004.10a989ee seq: 0x2 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center