Re: Cannot change ARCHIVELOG-MODE via EM
From: gazzag <gareth_at_jamms.org>
Date: Fri, 5 Mar 2010 02:12:17 -0800 (PST)
Message-ID: <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.
Date: Fri, 5 Mar 2010 02:12:17 -0800 (PST)
Message-ID: <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 Received on Fri Mar 05 2010 - 04:12:17 CST