DBA Hub

📋Steps in this guide1/2

12c DG Broker Configuration - Bright DBA

12c DG Broker Configuration – Error ORA-16698 Issue [oracle@rac1 ~]$ dgmgrl DGMGRL for Linux: Release 12.2.0.1.0 - Production on Thu May 16 18:03:42 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect / Connected to "DELL" Connected as SYSDG. DGMGRL> DGMGRL> create configuration 'DELL' … Continue reading

oracle Oracle 12cclusteringintermediate
by OracleDba
13 views
1

12c DG Broker Configuration – Error ORA-16698

Issue

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
[oracle@rac1 ~]$
dgmgrl
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Thu May 16 18:03:42 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL>
connect /
Connected to "DELL"
Connected as SYSDG.
DGMGRL>
DGMGRL>
create configuration 'DELL' as primary database is 'DELL' connect identifier is DELL;
Configuration "DELL" created with primary database "DELL"
DGMGRL>
DGMGRL>
add database 'DELL_DG' as connect identifier is DELL_DG maintained as physical;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Failed.
DGMGRL>
DGMGRL> exit
2

Solution

1. Remove the DG Broker configuration 2. Disable log_archive_dest_2 On Primary On Standby 3. Disable / Enable DG Broker 4. Configure DG Broker 5. Enbale LOG_ARCHIVE_DEST_2 6. Enable DG Broker Configuration Recommendation: Please DON’T create password file on standby. Please copy from 12c primary to 12c standby server. 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.

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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
DGMGRL>
remove configuration;
Removed configuration
DGMGRL>

SQL>
show parameter log_archive_dest_2
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string
SERVICE=DELL_DG LGWR ASYNC VAL
                                                 ID_FOR=(ONLINE_LOGFILES,PRIMAR
                                                 Y_ROLE) DB_UNIQUE_NAME=DELL_DG
SQL>

SQL>
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='' scope=both;
System altered.

SQL> show parameter log_archive_dest_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string

SQL>

SQL>
show parameter log_archive_dest_2
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string
SERVICE=DELL LGWR ASYNC VALID_
                                                 FOR=(ONLINE_LOGFILES,PRIMARY_R
                                                 OLE) DB_UNIQUE_NAME=DELL
SQL>

SQL>
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='' scope=both;
System altered.

SQL>
show parameter log_archive_dest_2
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string

SQL>

SQL>
show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean
TRUE
SQL>
SQL>
alter system set dg_broker_start=false scope=both;
System altered.

SQL>
alter system set dg_broker_start=true scope=both;
System altered.

SQL>
show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean
TRUE
SQL>

SQL>
show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean
TRUE
SQL>
SQL>
alter system set dg_broker_start=false scope=both;
System altered.

SQL>
alter system set dg_broker_start=true scope=both;
System altered.

SQL>
show parameter dg_broker_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean
TRUE
SQL>

[oracle@rac1 ~]$
dgmgrl
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Thu May 16 18:25:13 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL>
connect /
Connected to "DELL"
Connected as SYSDG.
DGMGRL>
create configuration 'DELL' as primary database is 'DELL' connect identifier is DELL;
Configuration "DELL" created with primary database "DELL"
DGMGRL>
DGMGRL>
add database 'DELL_DG' as connect identifier is DELL_DG maintained as physical;
Database "DELL_DG" added
DGMGRL>
DGMGRL>
show configuration;
Configuration - DELL

  Protection Mode: MaxPerformance
  Members:
  DELL    - Primary database
    DELL_DG - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL>

SQL>
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(DELL,DELL_DG)' scope=both;
System altered.

SQL>

SQL>
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DELL_DG LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DELL_DG' scope=both;
System altered.

SQL>

SQL>
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(DELL,DELL_DG)' scope=both;
System altered.

SQL>


SQL>
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DELL LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DELL' scope=both;
System altered.

SQL>

DGMGRL>
enable configuration;
Enabled.
DGMGRL>

DGMGRL>
show configuration;
Configuration - DELL

  Protection Mode: MaxPerformance
  Members:
  DELL    - Primary database
    DELL_DG - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS
(status updated 11 seconds ago)
<----
DGMGRL>
Useful commands:
DGMGRL>
show database "DELL" InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE

DGMGRL>
show database "DELL_DG" statusreport
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT

DGMGRL>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!