Vivek had added a datafile since the last recovery.
When Vivek restored the database, he left the CURRENT version of the new datafile in place, instead of deleting it. That meant that the current checkpoint SCN of that one file was WAY ahead of all the other files.
When he went to open the database, it checked to make sure all the files were recovered forward to the highest SCN of all datafiles. It found that the NEW datafile had the highest SCN, and began checking all the other datafiles to make sure they were also recovered up to that SCN. The first datafile it checked was file #1, the SYSTEM datafile #1. Upon finding at least one file in the database that was not recovered forward to the highest SCN of all datafiles, it failed with ORA-01194, and specified the datafile that it had found.
That is why to solve this problem, Vivek had to look at v$recover_file, and examine the recovery SCNs of each datafile to find out which one was way out ahead of the others.
Recoveries – Seminars – Hiring
well he said he had this error
Using CANCEL based recovery upon attempting to open the Databse
following Error is occurring:-
ORA-01194: file 1 needs more recovery to be consistent
Isn't file 1 system.dbf?