DBA Hub

📋Steps in this guide1/6

DG Broker Error – ORA-16714

DG Broker Error – ORA-16714 Issue: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting Data collection: On Primary [oracle@rac1 ~]$ dgmgrl DGMGRL for Linux: Versi

oracle clusteringintermediate
by OracleDba
12 views
1

Overview

Issue: Data collection: On Primary

Code/Command (click line numbers to comment):

1
2
3
ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
2

Section 2

On Primary DELL_DG - Physical standby database Warning: ORA-16792: configurable property value is inconsistent with database setting WARNING <------------ SHOW CONFIGURATION VERBOSE; show database "DELL" statusreport;

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
[oracle@rac1 ~]$
dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL>
connect /
Connected.
DGMGRL>
DGMGRL>
DGMGRL>
show configuration;
Configuration - DELL

  Protection Mode: MaxPerformance
  Databases:
    DELL    - Primary database
DELL_DG - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting
Fast-Start Failover: DISABLED

Configuration Status:
WARNING <------------
DGMGRL>

DGMGRL>
SHOW CONFIGURATION VERBOSE;
Configuration - DELL

  Protection Mode: MaxPerformance
  Databases:
    DELL    - Primary database
DELL_DG - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting
Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: DISABLED

Configuration Status:
WARNING
DGMGRL> 

DGMGRL>
show database "DELL" statusreport;
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT

DGMGRL>
show database "DELL_DG" statusreport
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT
             DELL_DG
WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
DELL_DG
WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
DELL_DG
WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
DGMGRL> 

DGMGRL>
show database "DELL_DG" InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE
         DELL_DG
ArchiveLagTarget                    0                                         0
DELL_DG
LogArchiveMaxProcesses                    4                                         4
DELL_DG
LogArchiveMinSucceedDest                    1                                         1
DGMGRL>
3

Section 3

show database "DELL_DG" statusreport show database "DELL_DG" InconsistentProperties Solution: On Standby
4

Section 4

PHYSICAL STANDBY alter system set log_archive_max_processes=4 scope=both; alter system set archive_lag_target=0 scope=both; alter system set log_archive_min_succeed_dest=1 scope=both; On Primary

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
SQL> select name,open_mode,db_unique_name,database_role from v$database;

NAME      OPEN_MODE            DB_UNIQUE_NAME                 DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
DELL      MOUNTED
DELL_DG
PHYSICAL STANDBY
SQL>

SQL>
alter system set log_archive_max_processes=4 scope=both;
System altered.

SQL>
alter system set archive_lag_target=0 scope=both;
System altered.

SQL>
alter system set log_archive_min_succeed_dest=1 scope=both;
System altered.

SQL>
5

Section 5

On Primary show database "DELL_DG" statusreport <---- No errors this time show configuration; SUCCESS <----------

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
DGMGRL>
show database "DELL_DG" statusreport
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT
<---- No errors this time
DGMGRL>
DGMGRL>
DGMGRL>
show configuration;
Configuration - DELL

  Protection Mode: MaxPerformance
  Databases:
    DELL    - Primary database
DELL_DG - Physical standby database
Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS <----------
DGMGRL>
6

Section 6

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!