my instance has 2 archive log dest:
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
ALTER SYSTEM SET log_archive_dest='/ora1/arch/DBA1/arch.log'
ALTER SYSTEM SET
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.
Will the init***.ora file be updated automatically or will he have to change that as well?
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?
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
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?
Click Here to Expand Forum to Full Width