Re: Cannot change ARCHIVELOG-MODE via EM
Date: Sat, 6 Mar 2010 14:03:04 +0100
Message-ID: <4b92523e$0$2882$ba620e4c_at_news.skynet.be>
"gazzag" <gareth_at_jamms.org> wrote in message
news:ca3f5932-5881-4ffc-986d-b0bdd4ded8db_at_33g2000yqj.googlegroups.com...
> 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
>
> ;)
>
> -g
I believe on Windoze the quotes are still needed!
Matthias Received on Sat Mar 06 2010 - 07:03:04 CST