Re: Archive - Import problem

This is what I call a burst of changes. Your redolog files are either too small or you have too few of them (usually 4 logfile groups is sufficient).
to add a logfile group
alter database add logfile group n ('<filea>','<fileb>') size 5M (my minimum)

To change the size
alter database drop logfile group n
followed by a new creation.

Hth,

--
Sybrand Bakker, Oracle DBA
A. Jensen <auj_at_storebrand.no> wrote in message news:fnhc4.9122$sH.47245_at_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 - 02:02:35 CST