I want to ask if I restore a control file from backup of say day2 and I recover till day1 using RMAN script, then what will be the state of my database? I mean day2 controlfile may be having SCN-Day2, and I am instructing RMAN to recover till past point in time that is SCN-Day1.

So , even if control file was SCN-DAY2, after recovery to date Day1, and open database with noresetlogs will make control file 's SCN as SCN-DAY1. I thought , while opening the database, oracle will find inconsistency that its controlfile was at SCN-DAY2 while datafiles were at SCN-DAY1.