-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|