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 and later
Information in this document applies to any platform.


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


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