Re: Cannot change ARCHIVELOG-MODE via EM

From: Chris Seidel <>
Date: Thu, 04 Mar 2010 15:00:59 +0100
Message-ID: <op.u81qjx13w1eelo_at_msrvcn04.belkin>

On Thu, 04 Mar 2010 14:43:08 +0100, Mladen Gogala <> wrote:

> Database can only be switched between
> archivelog and noarchivelog when it's mounted and not open. Also, it must
> be shut down cleanly.

Doing this via EM allows it to do this in "open mode" because when you set the checkbox all the stuff (shutdown, startup, alter ...) is done for you by the EM.

For an unknown reason this checkbox is grayed out on one system. All other systems are working well with an enabled checkbox. All these systems have an open database and are fully operational.

> sqlplus "/ as sysdba"
> shutdown immediate
> startup mount
> alter database archivelog;
> alter database open;

Yes of course. But the customer needs it via EM too.

> I dunno how to do that in EM.

But this was the question ;)

Thank you. Received on Thu Mar 04 2010 - 08:00:59 CST

Original text of this message