Re: Cannot change ARCHIVELOG-MODE via EM

From: Eric <eric_at_deptj.eu>
Date: Fri, 5 Mar 2010 18:44:39 +0000
Message-ID: <slrnhp2k8n.ld1.eric_at_tasso.deptj.eu>

On 2010-03-05, gazzag <gareth_at_jamms.org> wrote:
> On 4 Mar, 13:43, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>> 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.
>
> OP stated version 10.2. The quotes aren't needed:

Platform dependent!

>
> sqlplus "/ as sysdba" could also be
>
> sqlplus / as sysdba
>
> ;)
>
> -g
Received on Fri Mar 05 2010 - 12:44:39 CST