My Oracle Support Banner

Additonal Repair command in 12.2 (Doc ID 2377755.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.  

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure: 

Database Name: V12201
Pluggable Database Name: PDB1
Directory Name: /u01/app/oracle/ and all it's sub-directories


Data Recover Advisory is an Oracle database tool that automatically diagnose data failure, determine and present appropriate repair options and execute repair at user's request.

In RMAN command line Interface the Data recovery Advisory Commands are LIST FAILURE,ADVISE FAILURE,REPAIR FAILURE and CHANGE FAILURE.

In this Document we will cover Additional options Available in REPAIR command in 12.2

This document discusses how to  use the repair command  with different options datafile , pluggable database and untilscn option  which are  options introduced since 12.2.

This command does the Restore + Recovery + Online of the datafiles.


Please note unlike Advise Failure, this command will do an actual repair (Restore + Recovery of datafile/pdb/database) based on the syntax used.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 This document consist of the new options added to running the repair command repair datafile option  in 12cr2 
 A. Repair Datafile
 B. Repair pluggable database :

 C.Repair untilscn clause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.