Re: HELP! - dbstart fails - log 1 of thread 1 inconsistent

Mr. Nutter:

It would appear that you may be running a database with the parallel options enabled. The log file is
apparently listed in the init[SID].ora file of another Oracle instance. Or at least the database believes
so. The control file has the location of the log file in it as well. Check the init[SID].ora file for the location of the log files or check the crdb.sql script that created the database. If necessary, the control files can be
deleted and rebuilt using a media recovery technique, found in the Oracle Server Administrator's Guide.
You would normally have 3 log files, each with a different name. Also ensure that the log file is in a directory accessible to Oracle.

I hope this helps.
Reginald Bailey
rwbailey_at_usa.net

bob nutter <bob_at_sna.co.umist.ac.uk> wrote in article <3289FBC8.536_at_sna.co.umist.ac.uk>...
> Hi,
>
> I don't have a lot to do with Oracle, leaving the day-to-day admin &
> running with the users, but we're really stuck with this one (7.2.2.4.0
> under Sol 2.5):
>
> When dbstart runs, it fails with:
>
> SQL*DBA: Release 7.2.2.4.0 - Production on Wed Nov 13 15:24:26 1996
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> Oracle7 Server Release 7.2.2.4.0 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.2.2.3.0 - Production
>
> SQLDBA> Connected.
> SQLDBA> ORACLE instance started.
> Database mounted.
> ORA-00305: log 1 of thread 1 inconsistent; belongs to another database
> ORA-00312: online log 1 thread 1:
> '/jaguar_opt2/oracle/orahome/dbs/log1sid1.dbf'
> Attempting to dismount database........Database dismounted.
> Attempting to shutdown instance........ORACLE instance shut down.
> SQLDBA>
> SQL*DBA complete.
>
> Database "sid1" warm started.
>
> -I can't find any way to recover from this, as sqldba can't talk to
> anything. Trying to do anything fails with "ORA-01034 Oracle not
> available, ORA-07429 smsgsg: shmget() failed to get segment, SVR4 err 2:
> no such file or directory". This exact same problem happened a couple of
> months ago, and after much head-scratching and many reboots, it
> magically solved itself.
>
> I've checked the backup situation, and apart from system (ufsdump) level
> backups of the filesystem, we have nothing.
>
> Has anyone got any suggestions?
>
> cheers,
>
> bob
> --
>

--


> bob nutter,snr.computer officer| "Well, blessings to the chap who


> invented ice

> UMIST dept of computation      | cream, ginger-pop and the rest! I'd

> rather

> po box 88 manchester m60 1qd uk| invent things like that any day than

> tel:+44 161 200 3343 (fax:3324)| rockets and bombs."

> email:bob_at_umist.ac.uk          |       -Julian, "Five on Finniston Farm"

>