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