dynamic spfile value change in RAC

Hi,

I want to change the log_archive_dest spfile parameter in a RAC environment to different values for both instances.

How can do this dynamically ?

Say for eg., rac1.log_archive_dest='/u01/backup'
rac2.log_archive_dest='/u02/backup'

Is it possible to set dynamically ??

Thx.

Why use LOG_ARCHIVE_DEST ? This has been deprecated since 9i.

Nevertheless, you can use the following to set the parameter:

Code:

---

alter system set log_archive_dest='/u01/backup' scope=both sid='rac1';
alter system set log_archive_dest='/u02/backup' scope=both sid='rac2';

---

Thx ebrain.