Is it possible to change the archivelogs destination on a live database. I have oracle 10g on linux. We are not using the DB_RECOVERY_FILE_DEST , instead are using ARCHIVELOG_DEST. Can someone let me know the steps to change this parameter. Will doing the following work
certainly u can change the archive log destination dynamically by using the command what u mentioned.Then check the database archive process that it shouldn't stuck and here should be normal database activity.suppose the archive process is stuck then use
sql>Alter system archive log stop
sql>alter system archive log start
It is nothing wrong to change the destination.
In fact, you should be familarize this quite often. This will help you whenever arch dest is full, you must be in a position to change the location.
SQL> alter system set log_archive_dest_1='location=/tmp' ;