Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Production DB Crash Recovery process - Some immediate advice ASAP pls

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

From: LiShan Cheng <exriscer_at_gmail.com>
Date: Sun, 12 Feb 2006 21:00:56 +0100
Message-ID: <6e9345580602121200q470e638dk45328ef13072c4@mail.gmail.com>


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
Received on Sun Feb 12 2006 - 14:00:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US