Archive - Import problem

From: A. Jensen <auj_at_storebrand.no>
Date: Tue, 4 Jan 2000 08:32:18 +0100
Message-ID: <fnhc4.9122$sH.47245@news1.online.no>

Hi there,
I hope someone can explain this one as I'm new to Oracle archiving. Running 8.0.5.0.2 on NT 4 server SP5.
What happened is the following error during an import:

IMP-00017: following statement failed with ORACLE error 3113: "GRANT SELECT ON "UKESRAPPORT" TO "L67""

IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully
IMP-00021: operating system error - error code (dec 2, hex 0x2)

I investigated the alert log and found the following happening at the same time as the import failing:
..."all looking normal"...

Sat Jan 01 17:59:45 2000
Thread 1 cannot allocate new log, sequence 453 All online logs needed archiving
  Current log# 2 seq# 452 mem# 0: C:\ORACLE\DATA\LOG2DB1.ORA Sat Jan 01 18:00:04 2000
Thread 1 advanced to log sequence 453
  Current log# 3 seq# 453 mem# 0: C:\ORACLE\DATA\LOG3DB1.ORA Sat Jan 01 18:02:13 2000
Thread 1 cannot allocate new log, sequence 454 All online logs needed archiving
  Current log# 3 seq# 453 mem# 0: C:\ORACLE\DATA\LOG3DB1.ORA Thread 1 advanced to log sequence 454
  Current log# 1 seq# 454 mem# 0: C:\ORACLE\DATA\LOG1DB1.ORA Sat Jan 01 18:03:59 2000
Thread 1 cannot allocate new log, sequence 455 All online logs needed archiving
  Current log# 1 seq# 454 mem# 0: C:\ORACLE\DATA\LOG1DB1.ORA Sat Jan 01 18:04:13 2000
Thread 1 advanced to log sequence 455
  Current log# 2 seq# 455 mem# 0: C:\ORACLE\DATA\LOG2DB1.ORA Sat Jan 01 18:05:58 2000
Thread 1 cannot allocate new log, sequence 456 All online logs needed archiving
  Current log# 2 seq# 455 mem# 0: C:\ORACLE\DATA\LOG2DB1.ORA Sat Jan 01 18:06:14 2000
Thread 1 advanced to log sequence 456
  Current log# 3 seq# 456 mem# 0: C:\ORACLE\DATA\LOG3DB1.ORA
..."all looking normal"...

To me it seems that all of a sudden all three redo-logs needed archiving at the same time?
BTW; the import was executed from I client... I would appreciate some help on what could be the problem here...

TIA
AJ Received on Tue Jan 04 2000 - 01:32:18 CST