odg db2 oracle,ODG Switchover hangs for minutes

Hello!

We experience long downtimes when doing switchover to the physical standby database with dgmgrl under Oracle 12c.

The broker shuts down the former primary site (SITE1), brings the standby site (SITE2) into mount status and keeps it there for about 10 minutes.

After 10 minutes, SITE1 is started and mounted and SITE2 is opened.

This situation only occurs when using dgmgrl and only when switching from SITE1 to SITE2.

There's no delay because of outstanding redo apply and the manual switchover with sqlplus works without problems.

The alert.log of SITE1 shows:

=============================

[...]

Mon Nov 05 09:27:06 2018

Data Guard Broker operation requires restart; shutting down instance now

DMON (ospid: 18821): terminating the instance

Mon Nov 05 09:27:07 2018

Instance terminated by DMON, pid = 18821                       

Mon Nov 05 09:37:20 2018

Starting ORACLE instance (normal) (OS id: 18265)

The alert.log of SITE2 shows:

=============================

[...]

Standby became primary SCN: 234478875478

Switchover: Complete - Database mounted as primary

SWITCHOVER: completed request from primary database.

Mon Nov 05 09:27:50 2018

ARC1: Becoming the 'no SRL' ARCH                       

With dgmgrl 'show configuration verbose' and 'show database verbose ...' show no warnings or errors.

The 'validate database verbose ' shows no possible problems:

DGMGRL> validate database verbose ''

Database Role:     Physical standby database

Primary Database: 

Ready for Switchover:  Yes

Ready for Failover:    Yes (Primary Running)

[...]

Standby Apply-Related Information:

Apply State:      Running

Apply Lag:        0 seconds (computed 1 second ago)

Apply Delay:      0 minutes

Transport-Related Information:

Transport On:      Yes

Gap Status:        No Gap

Transport Lag:     0 seconds (computed 1 second ago)

Transport Status:  Success

Log Files Cleared:

Standby Redo Log Files:  Cleared

Online Redo Log Files:   Cleared

Standby Redo Log Files:  Available

Current Log File Groups Configuration:

Thread #  Online Redo Log Groups  Standby Redo Log Groups Status

()          ()

1         4                       5                       Sufficient SRLs

Future Log File Groups Configuration:

Thread #  Online Redo Log Groups  Standby Redo Log Groups Status

()          ()

1         4                       5                       Sufficient SRLs

[...]

Apply-Related Property Settings:

Property                          Value       Value

DelayMins                       0                        0

ApplyParallel                   AUTO                     AUTO

Transport-Related Property Settings:

Property                            Value       Value

LogXptMode                      SYNC                     SYNC

RedoRoutes                                       

Dependency                                       

DelayMins                         0                        0

Binding                              optional                 optional

MaxFailure                        0                        0

MaxConnections              1                        1

ReopenSecs                    300                     300

NetTimeout                      30                       30

RedoCompression           DISABLE                  DISABLE

LogShipping                     ON                       ON

I've removed and created the configuration again but the problem remains.

I have no idea what else to check.

Any help is appreciated.

Note:

- Block Change tracking is disabled.

Ricardo

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值