| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Stopped Archiving!
Salu,
To stop logging during data loading look for means like nologging. Turning automatic archiveing off does not solve your problem.Inthatcase it will still be logged but you have to archive them manually. Still if you want to do it, you have to take your database to no archive log mode. But before you do it remember and look fortheimplications of doing it.
>From: "salu Ullah" <salu_ullah_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Stopped Archiving!
>Date: Fri, 28 Apr 2000 14:55:39 -0800
>
>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
>
>--
>Author: salu Ullah
> INET: salu_ullah_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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).
 |
 |