Re: Stopped Archiving!

Mm. Yeah, I tried changing the init.ora first. When that didn't work, I cursed and hopped around, and then did the alter. Guess I didn't need the first step.

But it got me some exercise! :-)

At 12:10 PM 5/1/00 -0800, Rachel Carmichael wrote:
>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
>>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: Rachel Carmichael
> INET: carmichr_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
Received on Mon May 01 2000 - 14:58:52 CDT