Re: Stopped Archiving!

From: <Winnie_Liu_at_infonet.com>
Date: Fri, 28 Apr 2000 15:17:30 -0700
Message-Id: <10481.104487@fatcity.com>

Salu,

I think you have a serious mis-understanding about stopping the archiving. You are only stopping the ARCHIVER when you try to do it!!! It means that you will need to manually archive the online redo log yourself. It does not CHANGE YOUR DATABASE TO NOARCHIVE LOG DURING THAT TIME!!! If you want to change it to noarchive log, you should do a mount of the database and then issue alert database noarchivelog!

But once you change it to noarchive log. You may mess up with all your previous backup and you can no longer roll forward with the archive log that you used to have.

Why don't you just look into the nologging option, unrecoverable option in load?

Winnie

"salu Ullah" <salu_ullah_at_hotmail.com> on 04/28/2000 03:55:38 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Stopped Archiving!

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

Received on Fri Apr 28 2000 - 17:17:30 CDT