Re: 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