Re: Question about ARCHIVELOG mode

On Fri, 1 Oct 2004 15:50:13 +0300, "agis" <stag_at_hq.acn.gr> wrote:

>
>"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 ...
>
>1) There are not online archive logs Archive logs are archived redo logs
>
>2) 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 !!!!
>
>
>
>
>
>

Your 2nd remark is untrue! Did you ever try it yourself? Probably not. When all online redologs need archiving whether in automatic archive mode or manual archive mode, the database stops.

--
Sybrand Bakker, Senior Oracle DBA