I am on Oracle 10.2.0.4. I have Data Guard + RMAN + RMAN catalog. On the OS level my flashback recovery area was set up as */data/archive*. Everything was working fine. I then had to change this location (on the OS level) to */data/flashback*. I created pfile from spfile, made the corresponding changes in the pfile, made the change on the OS level, then started both db (primary and standby) with this pfile and then created spfile from pfile. Upon restart my primary would not come up - i.e. would stay in the mount mode. I see the following errors on primary:
DGMGRL> show database andev1 'StatusReport';
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
andev1 ERROR ORA-16783: instance andev1 not open for read and write access
andev1 WARNING ORA-16714: the value of property LogArchiveTrace is inconsistent with the database setting
andev1 WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
* WARNING ORA-16817: unsynchronized Fast-Start Failover configuration
On the standby I see the following:
DGMGRL> show database andev2 'StatusReport';
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
andev2 WARNING ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
andev2 WARNING ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
andev2 WARNING ORA-16714: the value of property LogArchiveTrace is inconsistent with the database setting
andev2 WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
* WARNING ORA-16817: unsynchronized Fast-Start Failover configuration
* WARNING ORA-16818: Fast-Start Failover suspended
* ERROR ORA-16766: Redo Apply unexpectedly offline
When I do
show database verbose andev1 I see:
StandbyArchiveLocation = '/data/archive/'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
So definatelly broker value is /data/archive and in SPFILE I have /data/flashback + these other settings dont match.
So I try to change these broker properties manually via dgmgrl as follows on primary:
DGMGRL> edit database 'andev1' set property 'LogArchiveTrace'='0';
Property "LogArchiveTrace" updated
DGMGRL> edit database 'andev1' set property 'LogArchiveFormat'='%t_%s_%r.arc';
Property "LogArchiveFormat" updated
DGMGRL> edit database 'andev1' set property 'StandbyArchiveLocation'='/data/flashback/;
Property "LogArchiveFormat" updated
However, StandbyArchiveLocation does not get updated in the broker. On the standby I cannot change these values:
DGMGRL> edit database 'andev2' set property 'StandbyArchiveLocation'='/data/flashback/';
Property "StandbyArchiveLocation" updated
These do not get upadted either. So the only option is to delete broker files and recreate them. Am I right? I mean if I want to change something in SPFILE, like location of my archive logs, I have to delete and recreate broker configuration? Or is there an easier way?
Thank you!