Monday, 8 October 2012

Change Log Archive Dest 1 In ASM

In my scenario I am planning to change One diskgroup to another disk group log archive dest 1


Currently set : 


Show parameter log_archive_dest_1

log_archive_dest_1                   string      LOCATION=+DATA_01/mald4dp


Need to Change +DATA_01 to +RECOVERY disk group



SQL> alter system set log_archive_dest_1='LOCATION=+RECOVERY' scope=both sid='*';

System altered.

Once executed above command switch the logfile so that we can make sure new archive log will generated in +RECOVERY disk group. 

SQL>  alter system switch logfile;

System altered.



Please go and check that particular new archive log destination once switch the log file to make sure everything working fine.

No comments:

Post a Comment