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

Ah right, I didnt read the new added datafile sorry for the confusion

thx

LSC On 2/12/06, Jeremiah Wilton <jeremiah_at_ora-600.net> wrote:
>
> 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