Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changed destinaton for FRA - broker and SPFILE are out of sync.

rysalkaJul 22 2009 — edited Aug 13 2009
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Jul 22 2009
2 comments
4,951 views