Control file inconsistency

Dennis Soper <[email protected]>
Newsgroups gmane.linux.suse.oracle.general
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.