Alter log_archive_format on Oracle failsafe?

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

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.

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

I think you can only do it in the spfile only

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

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. :o

However, I still stick to my responce regarding the first part of the question (Fail Safe)....