469,270 Members | 1,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

ORA-01092: ORACLE instance terminated. Disconnection forced

Hi

I am facing this error while working with a database, about 40-50 persons are using this DB.

I searched thru the sites to refer these error. They are saying t look into ALERT.LOG. I searched the entire server but couldn't find ALERT.LOG. Can any body help in finding this file???

Also, why this happens??? In the server, I have One database, 2 Users, 1 Listener, 1 Service Name.

Anybody Help..........

Regards
Reshmi
May 3 '07 #1
4 8079
Hi Reshma
you can find the alert file in oracle\admin\yourdatabasename\bdump

reason:i am not sure.. some problem with memory allocation i guess. :)
May 7 '07 #2
Hi

Thanks, i was seaching for Alert.LOG !!!


Thaks again
Reshmi

Hi Reshma
you can find the alert file in oracle\admin\yourdatabasename\bdump

reason:i am not sure.. some problem with memory allocation i guess. :)
May 8 '07 #3
Hi

In the ALERT LOG I found...


Sat May 05 11:15:42 2007
alter database open
Beginning crash recovery of 1 threads
Sat May 05 11:15:43 2007
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 30112 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Sat May 05 11:15:43 2007
Thread recovery: finish rolling forward thread 1
Thread recovery: 7 data blocks read, 4 data blocks written, 7 redo blocks read
Crash recovery completed successfully
Sat May 05 11:15:43 2007
Thread 1 advanced to log sequence 30113
Thread 1 opened at log sequence 30113
Current log# 2 seq# 30113 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG
Successful open of redo thread 1.
Sat May 05 11:15:44 2007
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat May 05 11:15:51 2007
Completed: alter database open
Sat May 05 11:20:53 2007
Thread 1 advanced to log sequence 30114
Current log# 3 seq# 30114 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO01.LOG
Sat May 05 11:23:08 2007
Thread 1 advanced to log sequence 30115
Current log# 1 seq# 30115 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Sat May 05 11:25:23 2007
Thread 1 advanced to log sequence 30116
Current log# 2 seq# 30116 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG

What may be the problem with my Database????
May 8 '07 #4
Hi

Is this the corruption of REDO log file. How can I rectify it

Reshmi
May 10 '07 #5

Post your reply

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

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
3 posts views Thread by Michael John | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.