Database Administration (MOSC)

MOSC Banner

help me understand this about block corruption

edited Jan 21, 2013 6:47PM in Database Administration (MOSC) 4 commentsAnswered
i have these blocks appearing as corrupt in the database. 

SQL> select distinct file#,block# from v$database_block_corruption;

     FILE#     BLOCK#
---------- ----------
         4    3749450
         4    3749458
         4    3749466
         4    3751748
        11     352279
        11     356375
 

i ran backup validate on these files  but iam not sure how to interpret the data. its showing "blocks failing" as zero . does it mean no corrupted blocks?


RMAN> BACKUP VALIDATE CHECK LOGICAL DATAFILE 4,11;

Starting backup at 01/15/2013 14:48:25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2396 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1028 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1370 device type=DISK

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