Database Administration (MOSC)

MOSC Banner

Fix corrupted block

edited May 29, 2017 7:45PM in Database Administration (MOSC) 19 commentsAnswered ✓

I have a database 11.2.0.4.

User gets a corrupted block error on a specified datafile.

I issued:

VALIDATE DATAFILE '/oradata1/dbname/filename01.dbf';

channel ORA_DISK_1: validation complete, elapsed time: 00:00:03

List of Datafiles

=================

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

5    OK     1              10781        89600           312773762

  File Name: /oradata1/dbname/filename01.dbf

  Block Type Blocks Failing Blocks Processed

  ---------- -------------- ----------------

  Data       0              77996

  Index      0              0

  Other      0              823

Also

select * from V$DATABASE_BLOCK_CORRUPTION ;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO

---------- ---------- ---------- ------------------ ---------

         5       2810          1                  0 FRACTURED

The db is backed up through RMAN. What is the best way to proceed to recover.

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