RE: Production DB Crash Recovery process - Some immediate advice ASAP pls

Lishan,  

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.  

Jeremiah Wilton

ORA-600 Consulting

Recoveries - Seminars - Hiring

http://www.ora-600.net  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LiShan Cheng

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?

--
http://www.freelists.org/webpage/oracle-l