dynamic spfile value change in RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dynamic spfile value change in RAC

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    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';

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    Thx ebrain.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width