Re: startup problem URGENT pliiiiiiiiiiiiiiiiiiiiiiz

What did you do to your online redo logs? Or to your control file(s)?

Strangely enough, these sort of problems don't just mysteriously appear when the gamma rays are coming in from the North-West and the fourth prime number you thought of happens to be exactly divisible by the wind speed on an alternate Thursday. You actually have to do something to make them happen!

Anyway... that's forensics. As your immediate problem.... I might suggest that you shut down, backup EVERYthing, then simply delete all your online redo logs. Get to mount stage and issue a 'recover until cancel', and then immediately issue a 'cancel'. Then issue an 'alter database open resetlogs'. If it doesn't work, don't fiddle. Delete the entire thing, and restore the backup you took to begin with. Then we can re-think.

Regards
HJR "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:26:28 CDT