Recover dropped table with RMAN 12c - Oracle Database Script. RMAN>RECOVER TABLE SCOTT.SALGRADE UNTIL TIME “to_date(’08/09/2016 18:49:40′,’mm/dd/yyyy hh24:mi:ss’)” auxiliary destination ‘/u03/arch/TEST/BACKUP’ datapump destination ‘/u03/arch/TEST/BACKUP'; auxiliary destination – LOCATION WHERE ALL the related files FOR auxiliary INSTANCE will be placed datapump destination – LOCATION WHERE the export DUMP OF the TABLE will be placed NOTE - This feature IS available ONLY IN oracle 12c AND later.
RMAN>RECOVER TABLE SCOTT.SALGRADE UNTIL TIME “to_date(’08/09/2016 18:49:40′,’mm/dd/yyyy hh24:mi:ss’)” auxiliary destination ‘/u03/arch/TEST/BACKUP’ datapump destination ‘/u03/arch/TEST/BACKUP'; auxiliary destination – LOCATION WHERE ALL the related files FOR auxiliary INSTANCE will be placed datapump destination – LOCATION WHERE the export DUMP OF the TABLE will be placed NOTE - This feature IS available ONLY IN oracle 12c AND later.