Re: ORA-00355 £¬redo logfile error!

From: cn.popeye <cn-poper_at_126.com>
Date: Wed, 28 Nov 2007 10:33:55 +0800
Message-ID: <fiip1q$3a2$1@news.cn99.com>

create a new log group, group id 4,

SQL> select member from v$logfile;

MEMBER

---

/data/oralog/dbce/redo03.log
/data/oralog/dbce/redo02.log
/data/oralog/dbce/redo01.log
/data/oralog/dbce/redo04.log

dump current log,
SQL> alter system dump logfile '/data/oralog/dbce/redo03.log' time min 28636283;
alter system dump logfile '/data/oralog/dbce/redo03.log' time min 28636283 *
ERROR at line 1:
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2988 change 28109902 time 11/26/2007 13:15:52
ORA-00334: archived log: '/data/oralog/dbce/redo03.log'

HOW?? "DA Morgan" <damorgan_at_psoug.org>
??????:1196165210.831470_at_bubbleator.drizzle.com...

> cn99 wrote:

>> hi all:
>> rebooted machine, then start oracle serivces, alter the ORA-00355!!!!
>>
>> SQL> startup;
>> ORACLE instance started.
>>
>> Total System Global Area 269554120 bytes
>> Fixed Size 451016 bytes
>> Variable Size 201326592 bytes
>> Database Buffers 67108864 bytes
>> Redo Buffers 667648 bytes
>> Database mounted.
>> ORA-00355: change numbers out of order
>> ORA-00353: log corruption near block 2988 change 28109902 time 11/26/2007
>> 13:15:52
>> ORA-00312: online log 3 thread 1: '/data/oralog/dbce/redo03.log'
>>
>> redo03.log is current log file.
>>
>> how do?
>> thanks all!

>
> http://www.psoug.org/reference/log_files.html
>
> Create a new log file group
> Dump the corrupt one.
> -- 
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org 

Received on Tue Nov 27 2007 - 20:33:55 CST