Ramon,
Two items to consider.
1. look up error on Metalink. Problem appears to be with your
networking. The resolution is to detailed to list here.
2. Your logs might be to small for the load that you were doing at the
time. Look at the times listed. You completed archiving log#3 seq#736
and started log#1 seq# 738 and began archiving log#2 seq# 737 all in the
2-3 second time frame. The load completed and then the system was quiet
for 6 hours plus before it switched to log#3 seq# 739
read the resolution on Metalink.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 03/13/02 11:03AM >>>
Hi List,
Checking the alert log file I found this error
ARC2: Completed archiving log# 3 seq# 736
Mon Mar 11 07:46:18 2002
Thread 1 advanced to log sequence 738
Mon Mar 11 07:46:18 2002
ARC1: Beginning to archive log# 2 seq# 737
Mon Mar 11 07:46:18 2002
Current log# 1 seq# 738 mem# 0: D:\ORACLE\REDO01.LOG
Current log# 1 seq# 738 mem# 1: D:\ORACLE\REDO01A.LOG
Mon Mar 11 07:46:19 2002
Errors in file D:\Oracle\admin\IBOR\trace\udump\ORA02316.TRC:
Mon Mar 11 07:46:20 2002
ARC1: Completed archiving log# 2 seq# 737
Mon Mar 11 07:46:48 2002
Errors in file D:\Oracle\admin\IBOR\trace\udump\ORA01440.TRC:
Mon Mar 11 14:19:22 2002
Thread 1 advanced to log sequence 739
Current log# 3 seq# 739 mem# 0: D:\ORACLE\ORADATA\IBOR\REDO03.LOG
Mon Mar 11 14:19:22 2002
----------------------------------------------------------------------------
---------
In the user trace file found this
Redo thread mounted by this instance: 1
Oracle process number: 21
Windows thread id: 1440, image: ORACLE.EXE
*** 2002-03-11 07:46:48.427
*** SESSION ID:(57.1472) 2002-03-11 07:46:48.302
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2002-03-11 07:46:48.443
ksedmp: internal or fatal error
Current SQL statement for this session:
INSERT INTO
RECEPCION(GRUPO,COMPANIA,VENDEDOR,AGENCIA,RECEPCION,FECHA,FACTURADA)
VALUES
(:1,:2,:3,:4,:5,:6,:7) RETURNING
ROWID,GRUPO,COMPANIA,VENDEDOR,AGENCIA,RECEPCION,FECHA,FACTURADA INTO
:8,:9,:10,:11,:12,:13,:14,:15
----- Call Stack Trace -----
calling call entry
argument values in hex
location type point
(? means dubious value)
-------------------- -------- --------------------
-
---------------------------
_ksedmp+a8 CALLrel _ksedst+0
0BE47C
_opitsk+f50 CALLrel _ksedmp+0
2
_opiino+50c CALLrel _opitsk+0
0
_opiodr+506 CALLreg 00000000
3C 4
B0BFBF8
_opidrv+384 CALLrel _opiodr+0
3C 4
B0BFBF8
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+49f CALLrel _opimai+0
2
B0BFE74
77E87587 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=b0be47c.
Dump of memory from 0xB0BE43C to 0xB0BE57C
----------------------------------
Thinking of adding other redo log group.
What do you think ?
Ramon
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
