Change archive log destination in Oracle using ASM
Summary
To change archive log destination of Oracle database, follow the following simple steps
log_archive_dest_1 is set to ORADATA, and you want to change it to ORAFLASH.
- reset log_archive_dest_1 to null
- set log_archive_dest_10 to new location.
NOTE : This does not require bouncing of database.
# of course db_recovery_file_dest should be set to +ORAFLASH (new location)
STEPS:-
Log into the oracle user.
Set Oracle database environment, using
. oraenv
Connect to the database by issuing the following command in the database directory:
sqlplus
Check db_recovery_file_dest to make sure db_recovery_file_dest is set to +ORAFLASH
connect / as sysdba
sql> show parameter db_file_recovery_file_dest
Change the archive log destination
Change values of following parameters, where
log_archive_dest_1 # old location
log_archive_dest_10 # new location
1) sql> alter system set log_archive_dest_10='LOCATION=use_db_recovery_file_dest' scope=both sid='*';
2) sql> alter system set log_archive_dest_1='' scope=both sid='*'; # to null out this parameter/reset
3) sql> alter system switch logfile; # to test, check alert log
Hope this help. Regards Rupam
