How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN in 12c MT(Multitenant ) database (Doc ID 2214510.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

12c came w/ new feature of recovering table from RMAN backup 

Example: RMAN>recover table sanju.t1 OF PLUGGABLE DATABASE PDB1 until time "to_date('11/23/2016 14:58:30','mm/dd/yyyy hh24:mi:ss')" auxiliary destination '/u04/' remap table sanju.t1:t12 preview;

 

But if don't want to do anything on production then follow below steps to do PITR restore / recovery of MT database in 12c to extract information from the dropped / truncated table

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms