| 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!
At our site, I have an emergency volume (12 gig) that is kept empty. A =
cron job runs every 15 minutes and if the volume that contains the =
archive log is more then 90% full, the cron job moves all the archive logs =
to the emergency disk. We haven't needed it too often, but when we did, it =
saved our bacon.
>>> <Winnie_Liu_at_infonet.com> 05/01/00 05:15PM >>>
Deepak,
That DBA really need a kick if all he can do during the filled archive location is to turn archiver off!!
I always had a volume in our system which I can copy to if the database =
all
in a sudden become "extremely-utter-active" and filled up the archive log.
I don't like to turn archiver off and archive it manually to another location because it will definitely kill my work load!
:P
Winnie
"Thapliyal, Deepak" <DThapliyal_at_ea.com> on 05/01/2000 12:05:58 PM
Please respond to ORACLE-L_at_fatcity.com=20
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)
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-----
Sent: Monday, May 01, 2000 11:09 AM
To: Multiple recipients of list ORACLE-L
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=20
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=20
>Reply-To: ORACLE-L_at_fatcity.com=20
>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=20
>
>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=
=20
>
>--
>Author: salu Ullah
> INET: salu_ullah_at_hotmail.com=20
>
>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=20
>
>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=20 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=20 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: Thapliyal, Deepak INET: DThapliyal_at_ea.com=20 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). --=20 Author:=20 INET: Winnie_Liu_at_infonet.com=20 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 inReceived on Tue May 02 2000 - 07:48:44 CDT
 |
 |