Recover a dropped/deleted table from RMAN Backup

From 10g Onwards you can recover the dropped table from recyclebin, suppose the table is not
available in recycle bin also flashback database in not enabled.

But you are having a recent RMAN backup containing that particular missing/deleted/dropped
table.

you can recover the table by

1. create a duplicate database from production database using until log sequence/time/scn

example:-
RMAN> RUN
2> {
3> SET UNTIL SEQUENCE 11 THREAD 1;
4> DUPLICATE TARGET DATABASE TO "clone" NOFILENAMECHECK;
5> }

2. export the users table from clone(duplicate) database.

[oracle@rac2 clone]$ exp rajesh/rajesh file=/u01/app/oracle/test_rcv.dmp tables=test rows=y

3. import the users table to the production database.
[oracle@rac1 ~]$ imp rajesh/rajesh file=/u01/app/oracle/test_rcv.dmp fromuser=rajesh
touser=rajesh tables=test