Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora-00340 -Please Help

ora-00340 -Please Help

From: <anuragmin_at_my-deja.com>
Date: Wed, 27 Dec 2000 19:26:23 GMT
Message-ID: <92dfon$o2l$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US