Re: Control file inconsistency

Hello Alexei,

why do you assume that file 2 and 3 are ok?

File 1 is version 281067
File 2 is version 28105
File 3 is version 28105

28105 is much smaller than 281067 ???

If you assume that there is a missing 0 at the end of the
error message 28105'0' is smaller than 281067

Kind regards
Ronald

Alexei_Roudnev wrote:
> It is too complicated method.
> 
> In this case, it's obvious that files 2 and 3 are good and file1 is bad, 
> so it's easy to copy file-3 into file-1 and start the database.
> 
> ----- Original Message ----- From: "Ronald Breuer" <[email protected]>
> To: "Dennis Soper" <[email protected]>
> Cc: "Suse Oracle" <[email protected]>
> Sent: Thursday, January 31, 2008 11:54 PM
> Subject: Re: [suse-oracle] Control file inconsistency
> 
> 
> Hello Dennis,
> 
> I assume that your database use 3 control files.
> 
> /opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl
> /opt/oracle/db10gr1/oradata/eprd/control02fprd.ctl
> /opt/oracle/db10gr1/oradata/eprd/control03fprd.ctl
> 
> You can check this in your init.ora file parameter
> control_files=
> 
> May be it is like this:
> 
> control_files=("/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl",
> "/opt/oracle/db10gr1/oradata/eprd/control02fprd.ctl",
> "/opt/oracle/db10gr1/oradata/eprd/control03fprd.ctl")
> 
> The name of the init.ora file is normally init[SID].ora.
> 
> So your SID is 'fprd' like in the name of the controle files.
> 
> control02[SID].ctl
> 
> As described in Note:1014751.6 you should start your database with
> a SINGLE good copy of the control file
> 
> You should change your init.ora Parameter like this
> control_files=("/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl")
> 
> PLEASE make a backup of all database files BEFORE you start with your
> experiments.
> 
> Kind regards
> Ronald Breuer
> ---
> Entimo AG
> Stralauer Platz 33 - 34 | 10243 Berlin | Germany
> Tel: +49.30.52 00 24 111 | Fax: +49.30.52 00 24 101
> [email protected] | http://www.entimo.com/
> 
> Sitz der Gesellschaft: Berlin, Germany
> Handelsregister: HRB Berlin-Charlottenburg 85073
> 
> Vorstand: Jürgen Spieler (Vors.), Erika Tannenbaum, Marianne Neumann,
> Dimitrios Karadimas
> 
> Aufsichtratsvorsitzender: Klaus Kögler
> 
> 
> 
> On 31.01.2008 20:27 Dennis Soper wrote:
>> Hi all,
>>         We had a major power outage last night, and our database 
>> server, which
>> was hooked up to a UPS shutdown abnormally (go figure, all the other
>> servers hooked up to this UPS shutdown correctly).  Anyway, when I go to
>> restart the database, I get the following:ORA-00214: controlfile 
>> '/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl' version
>> 281067 inconsistent with file
>> '/opt/oracle/db10gr1/oradata/eprd/control03fprd.ctl' version 28105
>>         So, I found a document on metalink that tells me how to fix 
>> the problem.
>> It tells me to edit the init.ora file, which in this case is, I'm
>> assuming ORACLE_HOME/dbs/initfprd.ora (the name of the file for the
>> particular database), removing all but one control file from the
>> initfprd.ora configuration and doing a STARTUP RESTRICT until I get a
>> startup that doesn't squawk, then copy that control file back to the
>> broken ones, change the config files back to original, then starting up
>> the database.
>>         Anyway, I changed the ORACLE_HOME/dbs/initfprd.ora and the
>> ORACLE_HOME/dbs/init.ora files.  Now I get the following message:
>>         controlfile '/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl'
>> version 281067 inconsistent with file
>> '/opt/oracle/db10gr1/oradata/eprd/control02fprd.ctl' version 28105
>>         Notice the change in the control file name.
>>         So, I figure I've missed a configuration file somewhere.  
>> Would anyone
>> happen to know what it might be?  The database is 10gR1 running on SLES
>> 10.
>>         Cheers,
>>         Dennis Soper [email protected]
>> Systems Administrator                             phone:  541.346.2027
>> Facilities Services-- The University of Oregon    fax:    541.346.2299
>> 1276 University of Oregon                         cell:   541.335.1254 
>> Eugene, OR  97403
> 
> 
> 

-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting