Recover table from RMAN Backup

Before recovering table, first validate database backup availability

RMAN> RESTORE DATABASE PREVIEW SUMMARY UNTIL TIME "to_date('05/21/21 18:34:00','mm/dd/yy hh24:mi:ss')";

………

If it says that you have all the backup available then you can proceed with the table recovery

RMAN> run {

recover table "VPSRIVA_RO"."VP_TEST1" UNTIL TIME "to_date('05/21/21 18:34:00','mm/dd/yy hh24:mi:ss')"

auxiliary destination '+DATA_INF';

}

……..

 

Validate the recovered table