Re: Cannot change ARCHIVELOG-MODE via EM
Date: Sat, 6 Mar 2010 14:03:04 +0100
"gazzag" <gareth_at_jamms.org> wrote in message
> 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:
> sqlplus "/ as sysdba" could also be
> sqlplus / as sysdba
I believe on Windoze the quotes are still needed!
Matthias Received on Sat Mar 06 2010 - 07:03:04 CST