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 -> init.ora - changs not recognised - From other thread

init.ora - changs not recognised - From other thread

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 25 Jan 2003 02:01:47 -0800
Message-ID: <92eeeff0.0301250201.7b7c6e9@posting.google.com>


BTW, OP asked for log_archive_start and not log_archive_dest. To further add to your post, it would be better to use,

alter system set log_archive_start=true scope=spfile; then
alter system archive log start;
and wait for scheduled shutdown startup. On next startup, archiving will be automatic.

Regards
/Rauf Sarwar

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<8qkY9.32459$jM5.82597_at_newsfeeds.bigpond.com>...
> Alternatively, since it seems apparent that he is already using an
> spfile, issue the command:
>
> alter system set log_archive_dest='xxxxx' scope=spfile;
>
> ...to edit it directly.
>
> And then shutdown immediate, followed by startup to get the change to
> take effect.
>
> Regards
> HJR
Received on Sat Jan 25 2003 - 04:01:47 CST

Original text of this message

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