Re: Question about ARCHIVELOG mode

From: agis <stag_at_hq.acn.gr>
Date: Fri, 1 Oct 2004 15:50:13 +0300
Message-ID: <cjjjq5$88f$1@ulysses.noc.ntua.gr>

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:o1kql01sauvc19d71e1nl1cg5bo4c6qm6p_at_4ax.com...
> On 1 Oct 2004 01:29:20 -0700, pyzhykea_at_belhard.com (Eugene Pyzhyk)
> wrote:
>
>>Hello all!
>>
>>Can you help me ?
>>
>>Does anybody know, may I start Oracle Server in ARCHIVELOG mode and
>>perform redo logs archiving in manual mode (only when I want to
>>archive it). Or automatic redo logs archiving must be enabled for
>>correct Oracle Server functioning ?
>>
>>Thank you!
>>
>>Eugene Pyzhyk
>
> If you are manually archiveing, what do you think Oracle is going to
> do when all of the on-line archive logs are full and you aren't
> Johnny-on-the-spot to issue your manual archive command? In short,
> why would you even consider manual archiving?

This is not a posibility ...

There are not online archive logs Archive logs are archived redo logs
Redo log is a cycling mechanism in simple words. In manual archive mode it will operate the same way as in noarchivelog mode !!! until a command archives the logs !!!!

I agree with u that archivelog mode MUST always be automatic in order to recover the database !!!! Received on Fri Oct 01 2004 - 07:50:13 CDT