From: Eric on 5 Mar 2010 13:44 On 2010-03-05, gazzag <gareth(a)jamms.org> wrote: > On 4 Mar, 13:43, Mladen Gogala <gogala.mla...(a)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
From: Mladen Gogala on 5 Mar 2010 14:31 On Fri, 05 Mar 2010 18:44:39 +0000, Eric wrote: >> OP stated version 10.2. The quotes aren't needed: > > Platform dependent! I am on the holly platform and he is right, but I do like my double quotes. Don't take away my double quotes, I see no reason for changing my bad habits. uname -a Linux lpo-oracle11-01 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux -- http://mgogala.byethost5.com
From: John Hurley on 5 Mar 2010 19:43 On Mar 5, 2:31 pm, Mladen Gogala <n...(a)email.here.invalid> wrote: snip > I am on the holly platform and he is right, but I do like my double > quotes. Don't take away my double quotes, I see no reason for changing my > bad habits. Holly platform? Holy platform? Hollister? My daughters have definitely spent a fair amount of my former income on Hollister but I didn't know they offered a linux flavor!
From: Mladen Gogala on 5 Mar 2010 20:56 On Fri, 05 Mar 2010 16:43:20 -0800, John Hurley wrote: > Holly platform? Holy platform? Hollister? Consecrated by the Oracle Corp. and having Oracle*Halo(TM) -- http://mgogala.freehostia.com
From: Matthias Hoys on 6 Mar 2010 08:03
"gazzag" <gareth(a)jamms.org> wrote in message news:ca3f5932-5881-4ffc-986d-b0bdd4ded8db(a)33g2000yqj.googlegroups.com... > On 4 Mar, 13:43, Mladen Gogala <gogala.mla...(a)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 |