在create configuration 的时候的报错! 警醒

最新推荐文章于 2023-04-17 10:14:13 发布
转载 最新推荐文章于 2023-04-17 10:14:13 发布 · 865 阅读 · 0
标签
#数据库 #网络
本文详细描述了在配置Oracle数据库环境时遇到的问题及解决方案，包括如何通过DGMGRL命令解决数据库状态获取失败、配置物理备库与主库连接、调整配置参数以确保数据同步和实时查询功能。通过步骤指导，读者可以有效解决类似问题，提高数据库管理效率。
Qwen3-32B

Qwen3-32B

文本生成
Qwen3

Qwen3 是 Qwen 系列中的最新一代大型语言模型，提供了一整套密集型和专家混合（MoE）模型。基于广泛的训练，Qwen3 在推理、指令执行、代理能力和多语言支持方面取得了突破性进展


监听和tns全部畅通
ORA11GR2 是备库 
ENMOEDU 是主库

DGM-17016: failed to retrieve status for database "ora11gr2"
ORA-16664: unable to receive the result from a database

 
DGMGRL> show database verbose ORA11GR2

Database - ora11gr2

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   (unknown)
  Apply Lag:       (unknown)
  Real Time Query: OFF
  Instance(s):
    ORA11GR2

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
DGM-17016: failed to retrieve status for database "ora11gr2"
ORA-16664: unable to receive the result from a database

DGMGRL> EXIT
[oracle@enmo2 ~]$ dgmgrl
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.
.
DGMGRL> connect sys/oracle@ORA11GR2
Connected.
DGMGRL> SHOW DATABASE VERBOSE ora11gr2

Database - ora11gr2

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: ON
  Instance(s):
    ORA11GR2

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> show configuration verbose;

Configuration - df

  Protection Mode: MaxPerformance
  Databases:
    enmoedu  - Primary database
    ora11gr2 - Physical standby database

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'

Fast-Start Failover: DISABLED

Configuration Status:
ORA-16642: DB_UNIQUE_NAME mismatch
ORA-16625: cannot reach database "enmoedu"
DGM-17017: unable to determine configuration status

DGMGRL> show database verbose ENMOEDU;

Database - enmoedu

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '1'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
DGM-17016: failed to retrieve status for database "enmoedu"
ORA-16642: DB_UNIQUE_NAME mismatch
ORA-16625: cannot reach database "enmoedu"

DGMGRL> SHOW DATABASE VERBOSE ora11gr2;

Database - ora11gr2

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: ON
  Instance(s):
    ORA11GR2

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS


DGMGRL> SHOW DATABASE VERBOSE ENMOEDU;

Database - enmoedu

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '1'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> SHOW DATABASE VERBOSE ora11gr2;

Database - ora11gr2

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   (unknown)
  Apply Lag:       (unknown)
  Real Time Query: OFF
  Instance(s):
    ORA11GR2

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
DGM-17016: failed to retrieve status for database "ora11gr2"
ORA-16664: unable to receive the result from a database



DGMGRL> REMOVE CONFIGURATION PRESERVE DESTINATIONS;
Warning: ORA-16620: one or more databases could not be reached for a delete operation

Removed configuration
DGMGRL> help create

Creates a broker configuration

Syntax:

  CREATE CONFIGURATION AS
    PRIMARY DATABASE IS
    CONNECT IDENTIFIER IS ;

DGMGRL> CREATE CONFIGURATION EN AS PRIMARY DATABASE IS ENMOEDU CONNECT IDENTIFIER IS ENMOEDU;
Configuration "en" created with primary database "enmoedu"
DGMGRL> HELP ADD

Adds a standby database to the broker configuration

Syntax:

  ADD DATABASE
    [AS CONNECT IDENTIFIER IS ]
    [MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> ADD DATABASE ORA11GR2 AS CONNECT IDENTIFIER IS ORA11GR2 MAINTAINED AS PHYSICAL;
Database "ora11gr2" added
DGMGRL> connect sys/oracle@ENMOEDU;
Connected.
DGMGRL> SHOW DATABASE verbose ENMOEDU;

Database - enmoedu

  Role:            PRIMARY
  Intended State:  OFFLINE
  Instance(s):
    ENMOEDU

  Properties:
    DGConnectIdentifier             = 'enmoedu'
    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          = '1'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
DISABLED

DGMGRL> ENABLE CONFIGURATION;
Enabled.
DGMGRL> SHOW CONFIGURATION VERBOSE;

Configuration - en

  Protection Mode: MaxPerformance
  Databases:
    enmoedu  - Primary database
    ora11gr2 - Physical standby database (disabled)

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

以上是我搭建环境的时候报错 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30176559/viewspace-1697017/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30176559/viewspace-1697017/

您可能感兴趣的与本文相关的镜像

Qwen3-32B

Qwen3-32B

文本生成
Qwen3

Qwen3 是 Qwen 系列中的最新一代大型语言模型，提供了一整套密集型和专家混合（MoE）模型。基于广泛的训练，Qwen3 在推理、指令执行、代理能力和多语言支持方面取得了突破性进展

cn00909332
关注
DataGuard 问题集1 ----V$DATAGUARD_STATS的transport lag, apply lag的增长
weixin_56440136的博客
04-08 2365
DataGuard 问题集1 ----V$DATAGUARD_STATS的transport lag, apply lag的增长 现象： 2node RAC Primary–2node RAC Standby环境 DataGuard的同步没有问题，但是V$DATAGUARD_STATS的transport lag, apply lag有增长的趋势，并且越来越大。 这篇文章记录了我的分析解决过程。虽然绕了弯子，但是让我认识了RAC DataGuard的一些POINT，加深了理解。 客户提供的确认command
【dg】配置 dg_broker遇到的错误记录
viviliving的专栏
06-28 1497
1、监听改了起不来 最开始报错的版本 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl) (GLOBAL_DBNAME= ora10g_DGMGRL.localdomain) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) ...
oracle 11.2.0.4 DataGuard Broker配置过程中可能遇到的问题及解决方法
clm20482的博客
04-16 492
本文记录oracle 11.2.0.4 DG Broker配置过程中遇到的一些问题及解决方法，由于部署环境不同，问题现象和处理办法供参考，如果 有问题欢迎批评指正。 1、归档参数log_archive_dest_2设...
【dgmgrl】使用dgmgrl做switchover切换报错ORA-16501, ORA-16625等
coco3600的博客
08-15 501
【dgmgrl】使用dgmgrl做switchover切换报错ORA-16501, ORA-16625, DGM-17017,DGM-17016 ...
oracle11g broker,oracle11g broker主庫異常斷電后的測試
weixin_35662171的博客
04-03 203
測試了11g 物理dg情況下主庫異常斷電的測試。發現主庫在異常斷電后，broker通過從庫登錄后，show configuration;等待很長時間返回：Configuration Status:ORA-16662: network timeout when contacting a databaseDGM-17017: unable to determine configuration stat...
v$dataguard_stats里的transport lag与apply lag的含义
loryliu的专栏
05-28 7981
10.2.0.5 on windows 64 bit 官方文档的解释是
oracle11g broker主库异常断电后的测试
敖尔其楞的专栏
11-30 1224
测试了11g 物理dg情况下主库异常断电的测试。 发现主库在异常断电后，broker通过从库登录后，show configuration;等待很长时间返回： Configuration Status: ORA-16662: network timeout when contacting a database DGM-17017: unable to determine configurati
配置dg broker的问题分析及修复
congbao6525的博客
10-10 582
最近从同事那儿接手了一套新环境，备库因为服务器问题已经下架，重新配了一台服务器，所以需要搭一套备库，主库已经配置好了，而且同事已经把在主库把dg broker配好了。 使用dgmgrl来验证，只有主库孤零零的在那儿。 DGM...
备库TNS写错了，导致在dgmgrl中无法添加备库
ciomp3888的博客
04-17 338
备库TNS写错了，导致在dgmgrl中无法添加备库 主库bj,对应TNS为bj_DGMGRL.test.com 备库tj,对应TNS为tj_DGMGRL.test.com 错误写法 ADD DATABASE ...
oracle概率问题,oracle 11.2.0.4 DataGuard Broker配置过程中可能遇到的问题及解决方法...
weixin_42131890的博客
04-04 413
本文记录oracle 11.2.0.4 DG Broker配置过程中遇到的一些问题及解决方法，由于部署环境不同，问题现象和处理办法供参考，如果有问题欢迎批评指正。1、归档参数log_archive_dest_2设置不当导致的主备库告警日志警告问题现象：主库Web Apr 11 14:17:16 2018RFS[85]: Assigned to RFS proess 28893RFS[85]: Da...
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
oracle sysdate aix,V$DATAGUARD_STATS中 transport lag 或 apply finish time 是空值
weixin_39719727的博客
04-12 794
Oracle 11.2.0.2 , AIX 6.1从生产RAC数据库上通过RMAN备份恢复出一个单机测试数据库， 然后建立这个测试数据库的ADG , 然后将这个ADG 备库convert 为 snapshot 数据库然后open 做一些测试 , 这时候应该可以传输log , 只是不apply , 但是通过以下语句查看时， apply lag 是合理的， transport lag 没有对...
Oracle 19c Physical Standby Switchover 最佳实践
weixin_60275015的博客
04-17 936
如果主备库的数据文件和 redo 文件的路径不同则需要设置参数 db_file_name_convert 和 log_file_name_convert。检查备库应用的最新归档日志序列号（ 可能不包括主库当前的 sequence 号 详见视图 v$archived_log ）-- 检查备库收到的主库最新的归档日志（ RAC 显示每一个 thread 的结果 ）-- 安装和配置检查：确认主备的数据库版本一致、确认 alert 日志无报错。-- 检查备库 redo 和 归档日志应用正常无 gap。
Oracle DG暂停主库日志传输、备库日志应用
Sebastien23的博客
02-26 2401
进程负责接收主库传输过来的日志，并将其写入备库重做日志（Standby Redo Log）；可以看到，transport lag一直为0，但是apply lag随着时间一直在增长。显示在等待编号为19的日志序列（Log Sequence Number）。进程负责把LGWR进程写好的联机重做日志传输到备库的。可以看到，负责应用归档重做日志的MRP0进程没了。可以看到，负责向备库传输日志的LNS进程没了。进程负责应用归档重做日志，将其恢复到备库。显示编号为19的日志序列还未被归档。异步模式下，DG主库上的。
oracle数据库使用dgbroker搭建DG以及一些常见的小问题
freedompuge的专栏
04-23 5454
oracle DG： 英文全称dataguard 提供备份和灾难恢复 dg----必须要有两台数据库，一台主一台备，主备可以来回切换 dg功能 1.备份（硬件可以低于主库，软件可以不一致） 2.提供容灾（硬件必须不低于主库，软件路径版本必须一致） 3.读写分离（主库读写对外服务。备库只读）逻辑备库可以读，11g物理备库也可以读 4.可以做测试（快照备库可以读写，测试
LSI 3008
热门推荐
HHFQ的博客
11-12 1万+
原文参见LSI SAS3008 文章目录@[toc] LSI SAS30081 概述2 功能2.1 提供多种类型的控制器2.2 提供高速接口和模块2.3 可连接多个扩展设备2.4 支持SAS/SATA/SSD硬盘2.5 一致性检查2.6 故障自修复2.7 硬盘热备份2.8 硬盘直通2.9 硬盘低格2.10 硬盘节能2.11 硬盘热插拔2.12 硬盘指示灯2.13 支持...
oracle bin 权限问题,ORA-16664，ORA-16625，TNS-12537- bin/oracle命令权限有关问题导致DGMGRL报错...
weixin_28759259的博客
04-08 490
ORA-16664，ORA-16625，TNS-12537- bin/oracle命令权限问题导致DGMGRL报错1.1.ORA-16664，ORA-16625，TNS-12537主库：16664, 0000, "unable to receive theresult from a database"// *Cause:During execution of a command, a da...
ORA-16625，ORA-16603，broker
09-30 1084
DGMGRL> show configuration   Configuration - dg     Protection Mode: MaxPerformance   Databases:     ogg2 - Primary database     ogg1 - Physical standby database (disabled)   Fast-Start Fa...
【oracle案例】ORA-16664，ORA-16625，TNS-12537
03-30 2400
ORA-16664，ORA-16625，TNS-12537- bin/oracle命令权限问题导致DGMGRL报错
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值