12c broker fast-start failover - ORA-16820解决

简介:

大早上起来测试一波fsfl,遇到一个小问题记录一下。

DGMGRL> 
DGMGRL> show configuration;

Configuration - dg_config

  Protection Mode: MaxAvailability
  Members:
  orcl   - Primary database
    Error: ORA-16820: fast-start failover observer is no longer observing this database

    orcldg - (*) Physical standby database 
      Error: ORA-16820: fast-start failover observer is no longer observing this database

Fast-Start Failover: ENABLED

Configuration Status:
ERROR   (status updated 26 seconds ago)

DGMGRL> 
DGMGRL> 
DGMGRL> show configuration;

Configuration - dg_config

  Protection Mode: MaxAvailability
  Members:
  orcl   - Primary database
    Error: ORA-16820: fast-start failover observer is no longer observing this database

    orcldg - (*) Physical standby database 
      Error: ORA-16820: fast-start failover observer is no longer observing this database

Fast-Start Failover: ENABLED

Configuration Status:
ERROR   (status updated 20 seconds ago)

DGMGRL> start observer;
[P001 02/27 07:04:10.37] Authentication failed.
DGM-16979: Unable to log on to the primary or standby database as SYSDBA
Failed.
DGMGRL> connect sys/sys   ##这里需要注意一下,使用sys用户连接
Connected as SYSDG.
DGMGRL> start observer
Observer started

#再次查看
[root@roidb01 ~]# su - oracle
Last login: Tue Feb 27 06:45:19 CST 2018 on pts/0
<roidb01:orcl:/home/oracle>$dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;

Configuration - dg_config

  Protection Mode: MaxAvailability
  Members:
  orcl   - Primary database
    orcldg - (*) Physical standby database 

Fast-Start Failover: ENABLED

Configuration Status:
SUCCESS   (status updated 25 seconds ago)

DGMGRL> 









本文转自 roidba 51CTO博客,原文链接:http://blog.51cto.com/roidba/2073336,如需转载请自行联系原作者
目录
相关文章
|
26天前
Failed to start LVS and VRRP High Availability Monitor.
Failed to start LVS and VRRP High Availability Monitor.
23 1
|
5月前
|
消息中间件
RabbitMQ ha-promote-on-shutdown 与 ha-promote-on-failure
RabbitMQ ha-promote-on-shutdown 与 ha-promote-on-failure
zookepeer启动节点报错,unable to run quorum server
zookepeer启动节点报错,unable to run quorum server
185 0
|
关系型数据库 MySQL Linux
Error connecting to master ‘slave@192.168.200.128:3307‘ - retry-time: 30 retries: 1
Error connecting to master ‘slave@192.168.200.128:3307‘ - retry-time: 30 retries: 1
218 0
Error connecting to master ‘slave@192.168.200.128:3307‘ - retry-time: 30 retries: 1
|
SQL 监控 关系型数据库
mysql主从复制出现Waiting for Slave Worker to release partition
本文分享mysql主从复制出现Waiting for Slave Worker to release partition
mysql主从复制出现Waiting for Slave Worker to release partition