I did the following
startup nomount;
rman restore controlfile from autobackup;
rman alter database mount;
rman restore database;
rman recover database;

When I try to open the database I get an error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/05/2007 10:07:11
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/TEMS/sys_TEMS01.dbf'
How do I fix this?

Oracle LazyDBA home page