Re: Stopped Archiving!

I'm in even later, but heck, I don't even change the init.ora

all I do is "alter database noarchivelog"

Works for me

Rachel

>From: "I.S. Manager" <ismgr_at_pctc.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: Mon, 01 May 2000 11:25:52 -0800
>
>I'm jumping in here late, so I may be misunderstanding the question, and it
>may have been answered already. And I'm working from my enfeebled memory,
>so I may bet it wrong anyway. So, with foot ready to place quickly in
>mouth....
>
>I had something like this happen to me. I wanted to turn off archiving on a
>backup system (whats the point anyway?), so I changed the init.ora file.
>When I went to restore the export into the backup system, it stopped after
>using up all arhive logs.
>
>Turned out the problem is that you not only have to turn off archiving in
>the init.ora file, you also have to "alter database noarchivelog".
>
>At 10:08 AM 5/1/00 -0800, Winnie_Liu_at_infonet.com wrote:
> >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).
> >
> >________________________________________________________________________
> >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).
> >
> >
>---
>Dennis Taylor
>---
>The opinions expressed herein are mine. Get your own opinions!
>---
>--
>Author: I.S. Manager
> INET: ismgr_at_pctc.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 - 14:03:14 CDT