Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ora-00340 -Please Help
Hi,
I am running oracle 8.0.5 on windows NT. A cold backup is scheduled
every night and the database is brought back up after that.
Every morning when i come to work I see that the database is not up (
services not started). I reboot the server and the database opens.
As I am a newbee i am unable to figure out why this is happenning.I opened the alert files and found that ora-00340 error has occurred. what does this mean and how do i fix this problem.
Below is the sample error message which i am getting.
Any help will be greatly appreciated. Thanks in advance.
Anurag
Database mounted in Exclusive Mode.
Completed: alter database "r2" mount exclusive
Wed Dec 27 07:37:51 2000
alter database "r2" open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 4 Seq 1399 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\R2\R2_REDO_4.LOG
Crash recovery completed successfully
Picked broadcast on commit scheme to generate SCNs
Wed Dec 27 07:37:52 2000
Thread 1 advanced to log sequence 1400
Thread 1 opened at log sequence 1400
Current log# 5 seq# 1400 mem# 0: D:\ORADATA\R2\R2_REDO_5.LOG
Successful open of redo thread 1.
Wed Dec 27 07:37:52 2000
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Dec 27 07:37:53 2000
Completed: alter database "r2" open
Wed Dec 27 08:25:16 2000
LGWR: terminating instance due to error 340
Wed Dec 27 08:25:17 2000
Errors in file D:\ORAADMIN\R2\UDUMP\ORA00162.TRC:
ORA-00340: IO error processing online log of thread
Wed Dec 27 08:25:22 2000
Sent via Deja.com
http://www.deja.com/
Received on Wed Dec 27 2000 - 13:26:23 CST