Stopped Archiving!

From: salu Ullah <salu_ullah_at_hotmail.com>
Date: Fri, 28 Apr 2000 21:51:54 GMT
Message-Id: <10481.104485@fatcity.com>

Hi,

I have a table in which i have to load 15 mill rows. So before start loading the data i disable the archiving in order to avoid all the space taken by the archive files. But when i run the loader i got the folloing error & when i truned archiving back on, i was able to load the data.

why??

Any input will be appreciated.

Thread 1 advanced to log sequence 46629
  Current log# 1 seq# 46629 mem# 0: /u01/oradata/testdb/log1a.log Fri Apr 28 15:54:00 2000
ARCH: Archival stopped
Fri Apr 28 15:54:36 2000
Thread 1 advanced to log sequence 46630
  Current log# 2 seq# 46630 mem# 0: /u02/oradata/testdb/log2a.log Thread 1 advanced to log sequence 46631
  Current log# 3 seq# 46631 mem# 0: /u03/oradata/testdb/log3a.log Fri Apr 28 15:54:46 2000
ORACLE Instance devora - Can not allocate log, archival required ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 46632 All online logs needed archiving
  Current log# 3 seq# 46631 mem# 0: /u03/oradata/testdb/log3a.log Fri Apr 28 16:04:23 2000
ARCH: Archival started
Fri Apr 28 16:04:24 2000
Thread 1 advanced to log sequence 46632
  Current log# 1 seq# 46632 mem# 0: /u01/oradata/testdb/log1a.log

Thanks in advance

Salu

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Fri Apr 28 2000 - 16:51:54 CDT