Re: Control file inconsistency

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



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