| 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!
I never really stop the archiver from automatically archiving to manual.
And I cannot think of any scanrio that I would like to do so.
Other guru listers? Any idea?
Winnie
"salu Ullah" <salu_ullah_at_hotmail.com> on 05/01/2000 10:15:15 AM
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: Re: Stopped Archiving!
Thanks for clearing my understanding of stopping archiving. In what case we stop the archiver automatically & do it manually? Just for my Knowledge.
Thanks
Salu
>From: Winnie_Liu_at_infonet.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Stopped Archiving!
>Date: Fri, 28 Apr 2000 15:36:11 -0800
>
>
>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)
>
>
>
>
>
>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).
>
>
>
>
>
>
>
>--
>Author:
> INET: Winnie_Liu_at_infonet.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).
-- 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-LReceived on Mon May 01 2000 - 11:54:55 CDT
 |
 |