change the value of log_archive_format
edited May 24, 2011 9:22PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
in a 10.2.0.4 dataguard setup, the primary has:
------------------------------
log_archive_format string %t_%s_%r.arc
and the standby has:
log_archive_format string %t_%s_%r.dbf
how can i change the standby so it's .arc also?
On the standby I ran:
SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
System altered.
But, in fact, nothing changed. I think i read that this parameter is not modifiable, so how do i proceed?
Thanks
log_archive_format string %t_%s_%r.arc
and the standby has:
log_archive_format string %t_%s_%r.dbf
how can i change the standby so it's .arc also?
On the standby I ran:
SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
System altered.
But, in fact, nothing changed. I think i read that this parameter is not modifiable, so how do i proceed?
Thanks
0