Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Alter NoARCHIVELOG mode to ARCHIVELOG

Re: How to Alter NoARCHIVELOG mode to ARCHIVELOG

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Thu, 17 Jun 1999 15:22:56 -0400
Message-ID: <37694B10.28D3B004@lucent.com>


The database needs to be mounted, but not opened.

>connect internal;
>startup mount;
>alter database archivemode;

Ken

Mike Schmidt wrote:

> Sam,
>
> Please provide the error msg and when do you get it after the alter database
> statement?
>
> Thanks,
> Mike
> Shi yousong <yousong_at_bigpond.com> wrote in message
> news:3765BA8E.A0F49B5E_at_bigpond.com...
> > Hi ,
> >
> > I tried to make it in this way.
> >
> > SVRMGR> connect internal
> > SVRMGR> startup NOMOUNT
> > SVRMGR>alter database archivelog ;
> >
> > But I got a error message. Could anyone tell me how to alter this ?
> >
> > Sam
> >
Received on Thu Jun 17 1999 - 14:22:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US