Re: startup problem URGENT pliiiiiiiiiiiiiiiiiiiiiiz

From: Fraser McCallum <fmcc_at_removetoemail_odbaguru.com>
Date: Wed, 24 Apr 2002 15:30:41 +1000
Message-ID: <ukrx8.47826$uR5.110219@newsfeeds.bigpond.com>

Arash,

It looks like you are trying to start the database with either an old or corrupted redo01.log. Have you perhaps done a database restore? To open the database you need to either find and place in the /home/oracle/oradata/shabuni/ the redo01.log file that belongs with the current version of your database or you can issue a reset logs command. If you choose to issue a reset logs command and your database had crashed then you may lose some data. At the svrmgr prompts do the following: startup mount;
alter database open resetlogs;

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Arash" <a.bijanzadeh_at_linuxiran.org> wrote in message news:10650ebd.0204232059.46fca5fb_at_posting.google.com...
> I can not connect to my oracle database because when i started it i
> got these messagea:
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production
>
> SVRMGR> Connected.
> SVRMGR> ORACLE instance started.
> Total System Global Area 93675680 bytes
> Fixed Size 73888 bytes
> Variable Size 76652544 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 172032 bytes
> Database mounted.
> ORA-00314: log 1 of thread 1, expected sequence# doesn't match
> ORA-00312: online log 1 thread 1:
> '/home/oracle/oradata/shabuni/redo01.log'
> SVRMGR>
> Server Manager complete.
>
> Database "shabuni" warm started.
>
>
> any idea please ?? I am going to loose all of my onformation :(
Received on Wed Apr 24 2002 - 00:30:41 CDT