Re: changing archive_log_dest

On Mon, 02 Jul 2007 11:25:14 -0700, dharm <dharmnagra_at_gmail.com> wrote:

>running oracle8i on windows 2003
>
>SQL> ARCHIVE LOG LIST
>Database log mode Archive Mode
>Automatic archival Enabled
>Archive destination I:\Oracle\oradata\pacs\archive
>Oldest online log sequence 23289
>Next log sequence to archive 23292
>Current log sequence 23292
>
>in my init.ora,
>
>log_archive_dest = I:\oracle\backup\archive
>log_archive_duplex_dest = I:\Oracle\oradata\pacs\archive
>
>I want to move my log_archive_dest to Z:\oracle\backup\archive
>
>I know I can make an init.ora change, but I cannot schedule some
>downtime for a little while.
>how can I make this change permanently on the fly (already assuming I
>have to use scope=pfile or both).
>
>remembering that this is oracle8i, is it possible/how to do this with
>zero downtime. remembering that I want a permanent change.
>
>thanks

Just verify from v$parameter whether log_archive_dest is a system_modifiable parameter.
IIRC it is.
In that case just issue
alter system set log_archive_dest=
and edit your init.ora subsequently
scope= doesn't exist in 8i.

BTW you are aware what risks you take by running a desupported version of Oracle on a platform for which it never certified?

-- 
Sybrand Bakker
Senior Oracle DBA