Re: Cannot change ARCHIVELOG-MODE via EM
Date: Thu, 4 Mar 2010 13:43:08 +0000 (UTC)
On Thu, 04 Mar 2010 13:24:20 +0100, Chris Seidel wrote:
> I connected to an Oracle 10.2 via Enterprise Manager (EM) as sysdba. The
> checkbox to enable/disable Archivelog-Mode is disabled (grayed out).
> 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"
alter database archivelog;
alter database open;
Being just an old DBA 1.0 hack, I dunno how to do that in EM.Received on Thu Mar 04 2010 - 07:43:08 CST