Re: Stopped Archiving!

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Mon, 1 May 2000 09:49:13 -0400
Message-Id: <10484.104539@fatcity.com>

Look like you disabled automatic archiving of log files but left the database in archive log mode. To disable archiving you need to do the following (btw you don't need to touch the log_archive_start parameter).

svrmgrl

SVRMGR> shutdown immediate
SVRMGR> startup nomount
SVRMGR> alter database noarchivelog;
SVRMGR> alter database open;
SVRMGR>

When you're done, do the same except for "noarchivelog" becomes "archivelog. You should take a backup of the database as soon as turning it back on too.
--

Chuck Hamilton
Oracle DBA
Enterprise Technical Services

                                                                                                                    
                    "salu Ullah"                                                                                    
                    <salu_ullah_at_ho        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    tmail.com>            cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    Ext: NA               Subject:     Stopped Archiving!                                           
                    Sent by:                                                                                        
                    root_at_fatcity.c                                                                                  
                    om                                                                                              
                                                                                                                    
                                                                                                                    
                    04/28/00 06:55                                                                                  
                    PM                                                                                              
                    Please respond                                                                                  
                    to ORACLE-L

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 Mon May 01 2000 - 08:49:13 CDT