| 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!
you would want to do that if you are out of space or something.. and you
want to manually archive to alternate location .. its also assumed that the
dba has done a "good job" at realizing this disk full situation at the every
last moment .. gee !!that is unless you can change the archival location on
the fly with the dB running, in which case my argument would buckle down to
its very knees ..ouch !!
deepak
-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com]
Sent: Monday, May 01, 2000 11:09 AM
To: Multiple recipients of list ORACLE-L
Subject: 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)
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-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-LReceived on Mon May 01 2000 - 12:59:45 CDT
 |
 |