Additonal Repair command in 12.2
(Doc ID 2377755.1)
Last updated on NOVEMBER 29, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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.
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|