Friday, 27 February 2015

Changing archive log location LOG_ARCHIVE_DEST_1 and db_recovery_file_dest to the new ASM disk Group

++ Check the current location

archive log dest;

++ Alter the spfile with the new disk group location
  
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+BW_FRA_01 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TESTDB' SCOPE=spfile;

++  Restart the db
shut immediate;
startup mount;
archive log list;
show parameter LOG_ARCHIVE_DEST_1

++ Changing FRA and other file locations which is pointing to old disk group.

alter system set db_recovery_file_dest='+BW_FRA_01' scope=both sid='*';
alter system set db_create_file_dest='+BW_DATA_01' scope=spfile sid='*';
alter system set db_create_online_log_dest_1='+BW_REDO_01' scope=spfile sid='*';
alter system set db_create_online_log_dest_2='+BW_REDO_01' scope=spfile sid='*';

Restart the DB

No comments: