Re: ORA-00355 £¬redo logfile error!

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