Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> init.ora - changs not recognised - From other thread
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