DGMGRL> show configuration; Configuration - dg_config Protection Mode: MaxAvailability ..."/>
溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

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

發(fā)布時(shí)間：2020-07-27 17:07:05 來(lái)源：網(wǎng)絡(luò) 閱讀：1030 作者：roidba 欄目：關(guān)系型數(shù)據(jù)庫(kù)

大早上起來(lái)測(cè)試一波fsfl，遇到一個(gè)小問(wèn)題記錄一下。

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>
向AI問(wèn)一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手