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

bob nutter wrote:

> 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.

  You can have several ways to deal with your problems. However, it is a must to backup all physical before doing any following actions:

1. (a) Startup the instance and mount it but do not open the database. (b) Drop the associated log file (c) Create a new log file
2. (a) Startup the instance and mount it but do not open the database. (b) open the database with resetlog option.
3. Carry out the same procedure as loss of an active online redo log group as a last resort.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841