Restore and Recover with latest controlfile backup but Database/Archivelog backup five days earlier

Problem: Here we have five days earlier Database/Archivelog backup without control controlfile but we have last night controlfile backup,now we need to restore and recover the Database.

Solution:

Step1: Shutdown Database.
 
Step2: connect to RMAN and startup in nomount mode.
 
RMAN>startup nomount;
Step3: Restore night controlfile backup

RMAN>restore controlfile from '/back/rman/STLBAS_3870_838523473_20140203_1.ctl';
Step4: Mount Database
 
RMAN>alter database mount;
Step5 : connect to sqlplus
 
Step6 :Recover Database with existing archivelog backup sequence number
 
RMAN>recover database until sequence 13099;

Note: If sequence 13099 not found then above command will ask for lower sequence number then
execute the following command

RMAN>recover database until sequence 13000;

Note: If sequence 13000 not found then above command will ask for lower sequence number then
execute the following command

RMAN>recover database until sequence 12000;

Step7 :If recover successfully then open database with resetlogs
 
RMAN>alter database open resetlogs;

Note: This solution is tested in my lab but before execute in production test it into your
test lab.