Data Recovery advisory list, advise, repair failure with RMAN

RMAN Advisory in Oracle

In ORACLE 11g, New feature RMAN Data Recovery Advisory is introduced. It will help the DBA for analysis the situation of corruption and dafafile lost. It also provide the solution from existing backup. It is great feature of Oracle 11g which help in recovery process.

Following is the example of system file has corrupted blocked. So, we used the RMAN Advisory feature to repair that block which is corrupted using the list of commands.
 
List Failure
List failure command list the existing failures in oracle database.

In example, the system datafile is having corrupted blocks

RMAN> LIST FAILURE;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- ----------- --------- -------
151 HIGH OPEN 18-APR-17 Datafile 1: 'E:\oracle\oradata\system01.dbf' contains one or more corrupt blocks

ADVICE FAILURE
Advice failure command will provide the recovery solution which is best available. It analysed and display the solution.

List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- ------ ------------- -------
151 HIGH OPEN 18-APR-17 Datafile 1: 'E:\oracle\oradata\system01.dbf' contains one or more corrupt blocks
analyzing automatic repair options; this may take some time
using channel ORA_DISK_1
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Perform block media recovery of block 28654 in file 1
Strategy: The repair includes complete media recovery with no data loss
Repair script: C:\oracle\scripts\reco_84879475.hm

Recovery Advisory generates a script that can be used to repair the datafile or resolve the issue. The script does all the work.

REPAIR FAILURE PREVIEW

Repair failure preview command show us what command followed by oracle for recovery the corrupted blocks.

RMAN> REPAIR FAILURE PREVIEW;
Strategy: The repair includes complete media recovery with no data loss
Repair script: C:\oracle\scripts\reco_84879475.hm
contents of repair script:
# block media recovery
recover datafile 1 block 28654;

REPAIR FAILURE
Execute the actual repair by issuing… it will prompt for YES..

RMAN> REPAIR FAILURE;
Strategy: The repair includes complete media recovery with no data loss
Repair script: C:\oracle\scripts\reco_84879475.hm
contents of repair script:
# block media recovery
recover datafile 1 block 28654;

Do you really want to execute the above repair (enter YES or NO)? YES
executing repair script

Starting recover at 18-APR-17
using channel ORA_DISK_1
searching flashback logs for block images until SCN 35245
finished flashback log search, restored 1 blocks

starting media recovery
media recovery complete, elapsed time: 00:00:03

Finished recover at 18-APR-17
repair failure complete

Advertisements

One thought on “Data Recovery advisory list, advise, repair failure with RMAN

  1. Pingback: Identify the Corruption using RMAN advisor | Smart way of Technology

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.