Sunday 30 December 2012

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>

No comments:

Post a Comment