Re: Changing archive destination without DB restart

Rick,

As a "best practice", you should *not* stop archiving (that can hang the primary).
You should just make the change dynamically, and if you want the change to take effect immediately, do a manual log switch (or an "archive log current" manual archival operation).
Otherwise, the changes will take place on the next automatic archival operation.

Hope this helps.

Rick

Rick Denoire wrote:

> Thomas Kyte <tkyte_at_oracle.com> wrote:
>
> >In article <hnkvlushfjmt5m7v01pg9ufi5t9hms7a74_at_4ax.com>, Rick says...
> >>
> >>Hello
> >>
> >>How can I change the destination of archived redo logs without having
> >>to: stop_the_instance/edit_the_init_file/start_the_instance? I need to
> >>be sure to do it right at my first try, otherwise if things get messed
> >>up I would need to restart the DB, which is what I am trying to
> >>avoid...
>
> >see the alter system command which allows you to set the log_archive_dest or
> >log_archive_dest_n settings for the system.
>
> Yes I know, but should I stop archiving before doing that? (..and
> restart it again afterwards?).
>
> Bye
> Rick
>
> PS: By the way, I am very impressed about your book. But don't tell me
> to look into it now.. it is at my office, while I am at home now, and
> I am trying to change the archive destination BEFORE people begin
> working with the DB, so I have to do it from home..)
Received on Tue Aug 20 2002 - 06:13:34 CDT