The following scripts will let you recover your database to the last SCN in the archived redo logs.

1, Connect to RMAN

rman catalog rman/rman@rman target sys/change@prod

2, Restore Control file

startup nomount;
restore controlfile;
alter database mount;

3. Find out the last SCN

SQL> SELECT archivelog_change#-1 FROM v$database;

ARCHIVELOG_CHANGE#-1
--------------------
2028371

1 row selected.

4. Restore and Recover using RMAN

run {
set until scn 2028371;
restore database;
recover database;
alter database open resetlogs;
}

5. Add temporary files.

sql "ALTER TABLESPACE TEMP ADD
TEMPFILE ''P:\Oracle\oradata\crm\temp01.dbf''
SIZE 2000M
AUTOEXTEND ON NEXT 64K";

6. Register the newly recovered database as a new incarnation.

list incarnation;
reset database to incarnation x;


7. Backup your database now!