471,306 Members | 839 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

REDO Log file corrupted

Hi

My problem occurs in a network with 40-50 systems working from a server.
Current users will be kicked out with "ORA-01092: ORACLE instance terminated. Disconnection forced", and users trying to log on will get "ERROR: ORA-03114: not connected to ORACLE" I checked the alert file and understood that error is coming while accesing REDO Log files...

From Alert.LOG===>

Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 30263 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 30264 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLE\REDO01.LOG

Thread recovery: finish rolling forward thread 1
Thread recovery: 123 data blocks read, 118 data blocks written, 1839 redo blocks read
Crash recovery completed successfully
Tue May 08 11:18:00 2007
Thread 1 advanced to log sequence 30265
Thread 1 opened at log sequence 30265
Current log# 1 seq# 30265 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Successful open of redo thread 1.
Tue May 08 11:18:00 2007
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue May 08 11:18:07 2007
Completed: alter database open


HOW CAN I CORRECT THIS? Database starts when I restart the system and start again

Pls Help

Regards
Reshmi
May 11 '07 #1
0 3571

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

48 posts views Thread by Joseph | last post: by
1 post views Thread by WKC | last post: by
13 posts views Thread by Bob Darlington | last post: by
3 posts views Thread by Teis Draiby | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.