So here is another post I will keep just for my own reference.
Whenever I need to perform an incomplete recovery of the database, I usually use the
SET UNTIL TIME to specify the time for an incomplete recovery. Sadly, when
NLS_LANG is not set properly, the time format that needs to be used is not something I can remember.
So here is an example for using
SET UNTIL TIME with a sane time format:
set until time "to_date('22-APR-2015 13:30:00','DD-MON-YYYY HH24:MI:SS')";
alter database open resetlogs;
You can find more examples in the Oracle documentation.