Oracle 12c New Feature: How to recover table using rman.

 How to recover a table in Oracle 12c Pluggable Database Using RMAN.

09:32:19 SQL> 

09:33:19 SQL> 

09:36:19 SQL> Create table hr.emp as select * from hr.employees;

rman target /

RMAN> backup as compressed backupset incremental level 0 database format '/backup/incr_bkp%U';

09:50:22 SQL> drop table hr.emp purge;

rman target/

RMAN> recover table hr.emp of pluggable database pdb  until time "to_date('10/07/2021 09:40:00','dd/mm/yyyy hh24:mi:ss')" auxiliary destination '/backup' datapump destination '/backup';

RMAN> recover table hr.emp of pluggable database pdb  until time "to_date('10/07/2021 20:15:00','dd/mm/yyyy hh24:mi:ss')" auxiliary destination '/backup';

09:59:19 SQL> select count(*) from hr.emp