obviously the control file you restored from backup will have different SCN number (old) than the data files (recent). That's the reason you are prompted for recovery.
you need to re-create the control file and open with RESETLOGS or
you need to restore the whole database from the same backup and recover.
Thanks,




Reply With Quote