DATABASE BLOCK CORRUPTIONS CAN BE RECOVERED USING RMAN

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

starting media recovery
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>