Re: Question about ARCHIVELOG mode

Reply embedded ....

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
That was a typo on my part. Of course I meant 'online redo' ... not 'online archive'. What?!? You can't read my mind?? <vbg>

>
>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 !!!!
>
>
>
>
>
>
Received on Mon Oct 04 2004 - 08:22:36 CDT