SOLVED

ORA-16855: Transport Lag Has Exceeded Specified Threshold

Asked by OracleDba••16 views•oracle
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
ORA-16855: Transport Lag Has Exceeded Specified Threshold

Problem :

We have observed below error in dgmgrl :

DGMGRL>

show database prim

Database – prim

Role: PHYSICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 9 minutes 24 seconds (computed 0 seconds ago)

Apply Lag: 9 minutes 24 seconds (computed 0 seconds ago)

Average Apply Rate: 488.00 KByte/s

Real Time Query: ON

Instance(s):

prim

Database Warning(s):

ORA-16853: apply lag has exceeded specified threshold

ORA-16855: transport lag has exceeded specified threshold

Database Status:

WARNING

DGMGRL>

show configuration

Configuration – dg_config_PRD

Protection Mode: MaxPerformance

Members:

ne – Primary database

prdby – Physical standby database

prim – Physical standby database

Warning: ORA-16809: multiple warnings detected for the member

Fast-Start Failover: DISABLED
#oracle#error

Solutions(1)

Accepted Solution
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
1.Check for the delaymin parametr:

DGMGRL> show database verbose prim DelayMins

DelayMins = ‘0’

2. Change the value to a higher value

DGMGRL> edit database prim set property DelayMins=15;

Property “delaymins” updated

DGMGRL>

3. Now check again:

DGMGRL> show database prim

Database – prim

Role: PHYSICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 0 seconds (computed 0 seconds ago)

Apply Lag: 0 seconds (computed 0 seconds ago)

Average Apply Rate: 502.00 KByte/s

Real Time Query: ON

Instance(s):

prim

Database Status:

SUCCESS

Hope it Helps!
OracleDba•

Post Your Solution