配置 broker 时遇到的两个错误 ORA-16797、ORA-16627

最新推荐文章于 2023-11-18 18:13:29 发布
最新推荐文章于 2023-11-18 18:13:29 发布
阅读量1.4k 收藏 1
点赞数
分类专栏： 数据库 文章标签： 数据库 Broker ORA-16627 ORA-16797 DGMGRL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/JiekeXu/article/details/106031144
版权

这里先说明这两个错误的解决办法然后直接看下面配置即可，
当添加完主备库后查看配置时出现 ORA-16797: database is not using a server parameter file。这个很明显就是数据库没有使用 Spfile 启库，直接用 pfile 启库所报的错误，解决办法关闭备库，创建 Spfile 文件后启库即可。


SYS@SBDB1> show parameter spfile

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
spfile                               string
SYS@SBDB1> shu immediate 
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@SBDB1> create spfile from pfile;

File created.

SYS@SBDB1> startup
ORACLE instance started.

Total System Global Area  941600768 bytes
Fixed Size                  1348860 bytes
Variable Size             683674372 bytes
Database Buffers          251658240 bytes
Redo Buffers                4919296 bytes
Database mounted.
Database opened.
SYS@SBDB1> 
SYS@SBDB1> select database_role,open_mode,protection_mode from v$database;

DATABASE_ROLE    OPEN_MODE            PROTECTION_MODE
---------------- -------------------- --------------------
PHYSICAL STANDBY READ ONLY            MAXIMUM PERFORMANCE

当切换模式为最高可用时出现 Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode；
这个错误没遇到过便网上查看了一番，几乎网上所有的文章均在说是由于传输模式为异步的原因，MOS 上到说明可能还 standby log 日志组没有建立的原因，但都不是这样的原因，我这里只是由于备库 dg_broker_start 参数没有设置为 TRUE，太坑了，居然只设置了主库的忘记备库设置此参数了。


SYS@prod1> show parameter dg_broker

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
dg_broker_config_file1               string                           /u01/app/oracle/product/11.2.0
                                                                      /dbhome_1/dbs/dr1PROD1.dat
dg_broker_config_file2               string                           /u01/app/oracle/product/11.2.0
                                                                      /dbhome_1/dbs/dr2PROD1.dat
dg_broker_start                      boolean                          FALSE
SYS@prod1> alter system set dg_broker_start=true;

System altered.

SYS@prod1> select count(*) from v$standby_log;

  COUNT(*)
----------
         4

SYS@prod1> shu immediate 
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@prod1> 
SYS@prod1> 
SYS@prod1> startup
ORACLE instance started.

Total System Global Area  941600768 bytes
Fixed Size                  1348860 bytes
Variable Size             692062980 bytes
Database Buffers          243269632 bytes
Redo Buffers                4919296 bytes
Database mounted.
Database opened.
SYS@prod1> 

--备库参数也需要修改

SYS@SBDB1> select flashback_on from v$database;

FLASHBACK_ON
------------------
YES

SYS@SBDB1> show parameter dg_broker;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
dg_broker_config_file1               string                           /u01/app/oracle/product/11.2.0
                                                                      /db_1/dbs/dr1SBDB1.dat
dg_broker_config_file2               string                           /u01/app/oracle/product/11.2.0
                                                                      /db_1/dbs/dr2SBDB1.dat
dg_broker_start                      boolean                          FALSE
SYS@SBDB1> 
SYS@SBDB1> alter system set dg_broker_start=true;

System altered.

SYS@SBDB1> show parameter dg_broker;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
dg_broker_config_file1               string                           /u01/app/oracle/product/11.2.0
                                                                      /db_1/dbs/dr1SBDB1.dat
dg_broker_config_file2               string                           /u01/app/oracle/product/11.2.0
                                                                      /db_1/dbs/dr2SBDB1.dat
dg_broker_start                      boolean                          TRUE
SYS@SBDB1> 

-----------------------------------------------------------------------------
以下是全部配置过程，直接贴出来供查看。


--使用 dgmgrl 远程登陆主库进行配置

[oracle@JiekeXu_p2 ~]$ dgmgrl sys/oracle@prod1
DGMGRL for Linux: Version 11.2.0.3.0 - Production

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

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> help create  --使用帮助命令添加主库

Creates a broker configuration

Syntax:

  CREATE CONFIGURATION <configuration name> AS
    PRIMARY DATABASE IS <database name>
    CONNECT IDENTIFIER IS <connect identifier>;

DGMGRL>  CREATE CONFIGURATION sbdb1_broker as PRIMARY DATABASE IS PROD1 CONNECT IDENTIFIER IS PROD1;
Configuration "sbdb1_broker" created with primary database "prod1"
DGMGRL> show CONFIGURATION

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL> help add           --使用帮助命令添加备库 SBDB1

Adds a standby database to the broker configuration

Syntax:

  ADD DATABASE <database name>
    [AS CONNECT IDENTIFIER IS <connect identifier>]
    [MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> add database SBDB1 AS CONNECT IDENTIFIER IS SBDB1;
Database "sbdb1" added
DGMGRL> enable Configuration;   --启用配置
Enabled.
DGMGRL> show Configuration --检查配置出现第一个错误ORA-16797

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database
      Error: ORA-16797: database is not using a server parameter file

Fast-Start Failover: DISABLED

Configuration Status:
ERROR

--这里已使用 SPfile 重启备库了，但埋下了第二个错误的种子，备库 disabled 

DGMGRL> show Configuration

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> show database PROD1;   --查看主库

Database - prod1

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    PROD1

Database Status:
SUCCESS

DGMGRL> help show 

Displays information about a configuration, database, or instance

Syntax:

  SHOW CONFIGURATION [VERBOSE];

  SHOW DATABASE [VERBOSE] <database name> [<property name>];

  SHOW INSTANCE [VERBOSE] <instance name> [<property name>]
    [ON DATABASE <database name>];

  SHOW FAST_START FAILOVER;

--查看主库详细配置，发现日志传输为异步，需要修改为同步 SYNC

DGMGRL> SHOW DATABASE VERBOSE PROD1; 

Database - prod1

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    PROD1

  Properties:
    DGConnectIdentifier             = 'prod1'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '10'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'SBDB1, PROD1'
    LogFileNameConvert              = 'SBDB1, PROD1'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'PROD1'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JiekeXu_p1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD1_DGMGRL.us.oracle.com)(INSTANCE_NAME=PROD1)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/flash'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> EDIT DATABASE PROD1 SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated

--配置完检查也是同步模式了

DGMGRL> SHOW DATABASE VERBOSE PROD1;

Database - prod1

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    PROD1

  Properties:
    DGConnectIdentifier             = 'prod1'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '10'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'SBDB1, PROD1'
    LogFileNameConvert              = 'SBDB1, PROD1'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'PROD1'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JiekeXu_p1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD1_DGMGRL.us.oracle.com)(INSTANCE_NAME=PROD1)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/flash'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

--这里切换保护模式是出现第二个报错 ORA-16627
 
DGMGRL> 
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.
DGMGRL> show CONFIGURATION

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

--开始排查，退出重新登录也是报错

DGMGRL> quit
[oracle@JiekeXu_p2 ~]$ dgmgrl sys/oracle@prod1
DGMGRL for Linux: Version 11.2.0.3.0 - Production

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

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show CONFIGURATION

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.
DGMGRL> 
DGMGRL> SHOW DATABASE VERBOSE SBDB1;

Database - sbdb1

  Role:            PHYSICAL STANDBY
  Intended State:  OFFLINE
  Transport Lag:   (unknown)
  Apply Lag:       (unknown)
  Real Time Query: OFF
  Instance(s):
    SBDB1

  Properties:
    DGConnectIdentifier             = 'sbdb1'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '10'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'PROD1, SBDB1'
    LogFileNameConvert              = 'PROD1, SBDB1'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'SBDB1'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JiekeXu_p2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SBDB1_DGMGRL.us.oracle.com)(INSTANCE_NAME=SBDB1)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/flash'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SHUTDOWN

DGMGRL> SHOW DATABASE VERBOSE PROD1;

Database - prod1

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    PROD1

  Properties:
    DGConnectIdentifier             = 'prod1'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '10'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'SBDB1, PROD1'
    LogFileNameConvert              = 'SBDB1, PROD1'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'PROD1'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JiekeXu_p1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD1_DGMGRL.us.oracle.com)(INSTANCE_NAME=PROD1)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/flash'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

--检查主备库日志传输均是同步模式

DGMGRL> EDIT DATABASE PROD1 SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.
DGMGRL> edit database 'PROD1' set PROPERTY 'LogXptMode'='SYNC';
Object "PROD1" was not found
DGMGRL> 
DGMGRL> edit database PROD1 set PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated
DGMGRL> 
DGMGRL> edit database SBDB1 set PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated
DGMGRL>  EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.

--这里主库重启了一次，断开需要重新连接

DGMGRL>  EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
ORA-03113: end-of-file on communication channel
Process ID: 3068
Session ID: 70 Serial number: 155

Configuration details cannot be determined by DGMGRL
DGMGRL> 

DGMGRL> DGMGRL> 
DGMGRL> 
DGMGRL> quit
[oracle@JiekeXu_p2 ~]$ dgmgrl sys/oracle@prod1
DGMGRL for Linux: Version 11.2.0.3.0 - Production

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

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>  EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.
DGMGRL> show CONFIGURATION;

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> START OBSERVER;
Observer started


--这里新开一个窗口进行操作

[oracle@JiekeXu_p2 ~]$ dgmgrl sys/oracle@prod1
DGMGRL for Linux: Version 11.2.0.3.0 - Production

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

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> 
DGMGRL> show CONFIGURATION;

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> enable FAST_START FAILOVER;
Error: ORA-16651: requirements not met for enabling fast-start failover

Failed.
DGMGRL> help add

Adds a standby database to the broker configuration

Syntax:

  ADD DATABASE <database name>
    [AS CONNECT IDENTIFIER IS <connect identifier>]
    [MAINTAINED AS {PHYSICAL|LOGICAL}];

--这里检测发现状态均是未知的

DGMGRL> show database SBDB1;

Database - sbdb1

  Role:            PHYSICAL STANDBY
  Intended State:  OFFLINE
  Transport Lag:   (unknown)
  Apply Lag:       (unknown)
  Real Time Query: OFF
  Instance(s):
    SBDB1

Database Status:
SHUTDOWN

DGMGRL> show database PROD1;

Database - prod1

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    PROD1

Database Status:
SUCCESS

--这里尝试删除 SBDB1 备库重新添加

DGMGRL> help delete
Unrecognized command "delete", try "help"
DGMGRL> help move
Unrecognized command "move", try "help"
DGMGRL> help

The following commands are available:

add            Adds a standby database to the broker configuration
connect        Connects to an Oracle database instance
convert        Converts a database from one type to another
create         Creates a broker configuration
disable        Disables a configuration, a database, or fast-start failover
edit           Edits a configuration, database, or instance
enable         Enables a configuration, a database, or fast-start failover
exit           Exits the program
failover       Changes a standby database to be the primary database
help           Displays description and syntax for a command
quit           Exits the program
reinstate      Changes a database marked for reinstatement into a viable standby
rem            Comment to be ignored by DGMGRL
remove         Removes a configuration, database, or instance
show           Displays information about a configuration, database, or instance
shutdown       Shuts down a currently running Oracle database instance
sql            Executes a SQL statement
start          Starts the fast-start failover observer
startup        Starts an Oracle database instance
stop           Stops the fast-start failover observer
switchover     Switches roles between a primary and standby database

Use "help <command>" to see syntax for individual commands

DGMGRL> help remove              

Removes a configuration, database, or instance

Syntax:

  REMOVE CONFIGURATION [PRESERVE DESTINATIONS];

  REMOVE DATABASE <database name> [PRESERVE DESTINATIONS];

  REMOVE INSTANCE <instance name> [ON DATABASE <database name>];

DGMGRL> remove database SBDB1;
Removed database "sbdb1" from the configuration
DGMGRL> 
DGMGRL> 
DGMGRL> help add

Adds a standby database to the broker configuration

Syntax:

  ADD DATABASE <database name>
    [AS CONNECT IDENTIFIER IS <connect identifier>]
    [MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> add database SBDB1 as connect IDENTIFIER IS SBDB1;
Database "sbdb1" added
DGMGRL> 
DGMGRL> help show 

Displays information about a configuration, database, or instance

Syntax:

  SHOW CONFIGURATION [VERBOSE];

  SHOW DATABASE [VERBOSE] <database name> [<property name>];

  SHOW INSTANCE [VERBOSE] <instance name> [<property name>]
    [ON DATABASE <database name>];

  SHOW FAST_START FAILOVER;

DGMGRL> SHOW CONFIGURATION;

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

-- 重新添加后备库还是 disabled

DGMGRL> SHOW CONFIGURATION;

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

--到这里终于检查到了是由于备库参数没有修改，配置好 dg_broker_start 参数后， enable 备库。

DGMGRL> help enable

Enables a configuration, a database, or fast-start failover

Syntax:

  ENABLE CONFIGURATION;

  ENABLE DATABASE <database name>;

  ENABLE FAST_START FAILOVER [CONDITION <condition>];

DGMGRL> ENABLE DATABASE SBDB1;
Enabled.
DGMGRL> SHOW CONFIGURATION;

Configuration - sbdb1_broker

  Protection Mode: MaxPerformance
  Databases:
    prod1 - Primary database
    sbdb1 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

--修改模式为最大保护模式成功，start failover 也成功了。

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Succeeded.
DGMGRL> 
DGMGRL> enable FAST_START FAILOVER;
Enabled.
DGMGRL> SHOW CONFIGURATION;

Configuration - sbdb1_broker

  Protection Mode: MaxAvailability
  Databases:
    prod1 - Primary database
    sbdb1 - (*) Physical standby database

Fast-Start Failover: ENABLED

Configuration Status:
SUCCESS

DGMGRL> 

这个步骤算是基本完成，特此记录学习。

JiekeXu
关注
专栏目录
Oracle事件诊断列表
10-13 1万+
oracle事件诊断列表，从0到20000，并输出到文件oracle.txt中。 SET linesize 120 SET feedback off SET SERVEROUTPUT ON spool "d:\oracl.txt" DECLARE err_msg VARCHAR2(120); BEGIN dbms_output.enable(1000000); FOR err
Data Guard配置Broker解决ORA-16664、ORA-16792
crc89714的博客
03-22 458
给某一个客户安装ADG完毕，配置Broker方便日后的管理与切换，碰到些许问题，以作记录 创建完configuration之后，enable的过程很慢，而且状态出现error 主库查询： ...
ORA-16627 max protection FASTSYNC Cascading ADG
最新发布
jnrjian的博客
11-18 198
MAXIMUM PROTECTION 要点： 最好两个备库 ，可以考虑far sync database。
oracle报错及解决方案
Lei狮的博客
10-16 3424
在做oracle12c+dataguard+broker的时候遇到的报错，以及其他报错，记录一下方便查看。 ORA-16136: Managed Standby Recovery not active 在物理备库取消日志应用时，出现ORA-16136的错误 SQL> alter database recover managed standby database cancel; alter...
Oracle 11g Data Guard 物理备库快速配置指南（下）
Vincent的专栏
04-16 1799
第二部分 作者介绍 作者 Jed Walker 是科罗拉多 Centennial Comcast 媒体中心的数据操作经理(Manager of Databse Operation)。他从1997年开始做 Oracle 数据库相关工作，是9i, 10g和11g的OCP。 简介 本文的第一部分讲解了如何配置一个基本的 Data Guard 环境。在第二部分里，我将介绍主备切换、故障转移(数据库
oracle切换broker,Oracle学习之DATAGUARD(七) 使用Broker管理DG
weixin_29267307的博客
04-13 288
一、修改Broker的配置属性1.1 使用EDIT命令你可以修改三个级别的属性：configuration, database,instanceEDIT CONFIGURATION SET PROPERTY =EDIT DATABASE SET PROPERTY =EDIT INSTANCE SET PROPERTY =如果在整个primary-standby系统中实例名不是唯一的，你可以在S...
【DATAGUARD】物理dg配置客户端无缝切换 (八.4)--ora-16652 和 ora-16603错误
07-31
### DATAGUARD 物理DG配置客户端无缝切换——ora-16652与ora-16603错误解析 #### 1. DataGuardBroker的配置 **DataGuardBroker** 是Oracle提供的用于简化Oracle Data Guard管理和配置的工具。通过使用...
ORA-16525 dg broker不可用
cqszpx的博客
07-21 272
oracle@oeltrace]$catdrcorcl150.log(drcorcl150.log在$结论将主备库dg_broker_start修改为true，showconfiguration正常显示.ORACLE_BASE/rdbms/orcl150/orcl150/trace目录下)此处主备库的dg_broker_start均为false。尝试将dg_broker_start设置为"true".数据库Oracle11.2.0.4。系统CentOS7.9。...
oracle ora 00279,ORA-01113 、ORA-00279
weixin_36373013的博客
04-06 1248
造成这种原因，是因为我一开始 restore 一个数据文件，当时忘了recover database;导致重启时报错。处理方式：C:\Documents and Settings\Administrator>net start oracleservicewmsOracleServiceWMS 服务正在启动 .............................................
oracle11g ora12170,11g告警日志中大量ORA-12170错误
weixin_42297810的博客
04-05 1175
在11g数据库的告警日志中，经常可以看到ORA-12170错误信息。如果这个错误是偶然出现，问题可能是网络问题所致，但是如果这个错误短时间内频繁出现，那么问题就不一定是网络不畅那么简单了。客户的数据库出现了应用无法连接的错误，而应用程序日志出现下面的错误信息：ORA-12519, TNS:no appropriateservice handler found在告警日志中比较频繁的出现了下面的错误：...
librdkafka 打印连接断开错误
石权的博客
07-08 1万+
kafka 0.9.0+ 版本会每隔一段时间主动关闭空闲连接，默认是10分钟。 在librdkafka中，有一个决定是否打印断连信息的开关。如果对接的是0.9.0+版本的kafka，建议关闭。非关闭状态下，librdkafka可能会打印断连接信息，实际不会丢数据。
Kafka集群生产/消费的负载均衡(Rebalance)测试
热门推荐
cjf_wei的博客
02-25 2万+
基于Kafka客户端的高级API，配合zookeeper的使用，可以有效的实现Kafka集群的Rebalance，提高生产环境下的健壮性。本文使用librdkafka(https://github.com/edenhill/librdkafka) 提供的高级API来实现生产/消费，作为测试的基础。
ORA-01779的处理方法(更新数据处理)
s123917的博客
08-26 835
[quote]oracle11g不支持使用 BYPASS_UJVC [/quote]Oracle中试图对一个子查询进行更新时可能会出现ORA-01779错误。该错误的内容为： ORA-01779: cannot modify a column which maps to a non-key-preserved table例如，使用以下的更新查询就会出现该错误。 [code="java"]C...
oracle错误日志4,Oracle错误一览表4
weixin_35941169的博客
04-05 520
ORA-16789: 备用重做日志缺失 ORA-16790: 可配置属性的值无效ORA-16791: 无法检查备用重做日志是否存在 ORA-16792: 某些可配置属性的值与数据库设置不一致 ORA-16793: 逻辑备用数据库 Guard 意外关闭 ORA-16794: 数据库 Guard 已为主数据库打开ORA-16795: 数据库资源防护程序检测到数据库需要重新实例化 ORA-16...
ORA-16820: fast-start failover observer is no longer observing this database
blockheading的博客
05-13 2093
解决过程： ORA-16820: fast-start failover observer is no longer observing this database DGMGRL> stop observer Done. DGMGRL> show configuration Configuration - testdg Protection Mode: MaxAvailability
RocketMQ关于Broker闪断故障排查【实战笔记】
gaoliang1719的专栏
03-21 4616
目录一、问题描述 二、Broker日志分析 1.查看GC日志 2.查看Broker日志 三、系统监控分析 1.网络监控 2.磁盘IO监控 3.CP...
oracle is avaliable,ora-16525: the Data Guard broker is not yet available解决
06-10
ORA-16525错误提示表明，Data Guard broker还没有准备好。可以尝试以下步骤来解决该问题： 1. 确保Data Guard broker已经启用。可以通过以下命令来检查： ``` SELECT NAME,VALUE FROM V$PARAMETER WHERE NAME='DG_BROKER_START'; ``` 如果值为TRUE，表示已经启用，否则需要启用它。 2. 确保tnsnames.ora文件中定义了正确的连接信息。可以使用以下命令来检查： ``` tnsping <tnsname> ``` 如果连接不成功，则需要检查tnsnames.ora文件中的定义是否正确。 3. 确保tnsnames.ora文件中定义的连接信息可以连接到目标数据库。可以使用以下命令来测试： ``` sqlplus /@<tnsname> ``` 如果连接不成功，则需要检查连接信息是否正确以及目标数据库是否可用。 4. 确保Data Guard broker已经启动。可以使用以下命令来检查： ``` DGMGRL ``` 如果可以连接到Data Guard broker，则表示已经启动，否则需要启动它。 以上是一些可能的解决方法，希望对你有所帮助。如果问题仍然存在，请提供更多详细信息以便更好地帮助你解决问题。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值