change archive log location

my instance has 2 archive log dest:
log_archive_dest =/ora1/arch/arch.log
log_archive_duplex_dest=/ora2/arch/arch.log

now I need to move them to different location without shutdown the instance
move /ora1/arch/arch.log to /ora1/arch/DBA1/arch.log
move /ora2/arch/arch.log to /ora2/arch/DBA1/arch.log
could someone tell me the syntax

thanks in advance

How about:

ALTER SYSTEM SET log_archive_dest='/ora1/arch/DBA1/arch.log'

and,

ALTER SYSTEM SET
log_archive_duplex_dest='/ora2/arch/DBA1/arch.log'


Both LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST are dynamic parameters - you don't need to shut down the instance to modify there values.


-amar

Will the init***.ora file be updated automatically or will he have to change that as well?
MH

The init.ora file will most definitely NOT be updated. When the instance is bounced it would revert back to the old values (different in 9i BTW)

do I have to issue
alter system archive log current

before switch to the new location?

Hi

As Jeff surely it will not update the init.ora file you will have to change the init.ora file setting and bounce the database to make those changes permanent.

Yes do a alter system archive log current before you switch

Regards

thanks I tried it works but I read from some place, I can use

alter system archive log stop;
alter system archive log start to 'new locatin';

does this work? if yes, how I switch the 2nd archive log location?