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\ORADA TA\ORACLE\REDO0 2.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 30264 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 1.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\ORADA TA\ORACLE\REDO0 3.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
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\ORADA TA\ORACLE\REDO0 2.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 30264 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 1.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\ORADA TA\ORACLE\REDO0 3.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