Alter log_archive_format on Oracle failsafe?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Alter log_archive_format on Oracle failsafe?

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Alter log_archive_format on Oracle failsafe?

    Can I alter the log_archive_format whilst using Oracle Failsafe and online? Thanks.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Sure, why not. Fail Safe has got absolutely nothing with archive log format ( except that you will probably want to change tha parameter on the "passive" server side too, when you chang it on the active side).

    And yes, you can change it while your database is online.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    I get the following error when I try to change this parameter online:
    SQL> alter system set log_archive_format="res1%s.arc" scope=memory;
    alter system set log_archive_format="res1%s.arc" scope=memory
    *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified

    Rgds.
    Sheryl

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    I think you can only do it in the spfile only

    http://www.orafaq.com/parms/parm797.htm

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quote Originally Posted by ssmith
    I get the following error when I try to change this parameter online:
    SQL> alter system set log_archive_format="res1%s.arc" scope=memory;
    alter system set log_archive_format="res1%s.arc" scope=memory
    *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified
    Well, there you have it. My advice regarding the ability to change it online was obviously and definitively wrong.

    However, I still stick to my responce regarding the first part of the question (Fail Safe)....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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