Re: Known Problems in Archivelog mode

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Oct 2001 12:13:28 +0200
Message-ID: <tt7tcn52o8oo7e@corp.supernews.com>

Answers embedded

Hth
Sybrand Bakker
Senior Oracle DBA

"Totx" <zunda_at_softhome.net> wrote in message news:9r0njt$mvd1_at_tid.tid.es...
> Hello!
>
> I want to change my database from NoArchivelog to Archivelog mode.
> Does anybody know any "bug" or any problem that may appear in ma database
> when I change it?.

NO, there are none

>
> I've heard that It can appear redo contention.
Has NOTHING to do with archivelog and can appear in noarchivelog as well. However you told you this knows very little about Oracle.

And, I think than when there
> is no enough space to archieve, my database will stop. Is it true?.
Yes that is true. However that has nothing to do with Oracle, but with a badly setup server
Also the database will 'hang' only, as soon as you archive one single file, it will proceed again. No connections are lost, the database only suspends

There
> are more "hidden" problems in archivelog mode?.

Why do you think that?
>
> Thanks!
>
>
>
Received on Mon Oct 22 2001 - 05:13:28 CDT