Any news about 'kernel bug in aio'?
"Alexei_Roudnev" <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
Any news?
For now:
- kernel 286 or 287 has an aio bug so it panic time-to-time
- kernel 308 has another aio bug so rman and FAL don't work with it.
>
> 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