DATABASE BLOCK CORRUPTIONS CAN BE RECOVERED USING RMAN
cause:- Fractured block found during validation
rman
target /
Recovery Manager: Release
11.2.0.1.0 – Production on Thu Dec 24 11:11:08 2012
Copyright (c) 1982, 2009,
Oracle and/or its affiliates. All rights reserved.
connected to target database:
ARJUN (DBID=3469830310)
RMAN> RECOVER CORRUPTION
LIST;
RMAN> recover corruption
list;
Starting recover at 24-DEC-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=73 device type=DISK
finished standby search, restored 2 blocks
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=73 device type=DISK
finished standby search, restored 2 blocks
starting media recovery
media recovery complete, elapsed time: 00:00:01
media recovery complete, elapsed time: 00:00:01
Finished recover at 24-DEC-12
RMAN>
SQL > SQL> select *
from v$database_block_corruption;
no rows selected
SQL> SQL>
