Re: Cannot change ARCHIVELOG-MODE via EM

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 4 Mar 2010 13:43:08 +0000 (UTC)
Message-ID: <hmoddc$5o5$11_at_solani.org>

On Thu, 04 Mar 2010 13:24:20 +0100, Chris Seidel wrote:

> Hi,
>
> I connected to an Oracle 10.2 via Enterprise Manager (EM) as sysdba. The
> checkbox to enable/disable Archivelog-Mode is disabled (grayed out).
>
> Why?
>
> Thank you!

You're a DBA 2.0? Not a problem. Database can only be switched between archivelog and noarchivelog when it's mounted and not open. Also, it must be shut down cleanly. So, at approximately 10:30 AM, do the following:

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

Being just an old DBA 1.0 hack, I dunno how to do that in EM.

-- 
http://mgogala.freehostia.com

Received on Thu Mar 04 2010 - 07:43:08 CST