https://docs.oracle.com/cd/F19136_01/bradv/rman-recovering-tables-partitions.html
rman target /
backup database plus archivelog;
list backup;
exit
sqlplus test/test@pdb11;
select count(*) from sh.sales;
select current_scn from v$database;
drop table sh.sales;
exit
rman target /
RECOVER TABLE SH.SALES OF PLUGGABLE DATABASE pdb11
UNTIL scn 11542112
AUXILIARY DESTINATION '/home/oracle'
DATAPUMP DESTINATION '/home/oracle'
DUMP FILE 'SALES.dmp'
;
exit
sqlplus test/test@pdb11;
select count(*) from sh.sales;
exit
