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