首页 > 其他分享 >o同步传输timeout 内hang

o同步传输timeout 内hang

时间：2024-10-11 13:33:00浏览次数：7  
标签：ago computed seconds Lag hang 传输 IDLE timeout archive 

原有状态最大性能：
DGMGRL> SHOW CONFIGURATION lag verbose
Configuration - dg_config
  Protection Mode: MaxPerformance
  Members:
  orcl    - Primary database
    orcl2dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)
    orcl0dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    TraceLevel                      = 'USER'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'
    ConfigurationWideServiceName    = 'orcl_CFG'

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS

DGMGRL> DGMGRL> DGMGRL> 



--准备设置保护模式！
edit database  orcl2dg set property  LogXptMode='sync';
edit database  orcl2dg set property  NetTimeout=30;


DGMGRL>  show database verbose orcl2dg
Database - orcl2dg
  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 12.00 KByte/s
  Active Apply Rate:  0 Byte/s
  Maximum Apply Rate: 0 Byte/s
  Real Time Query:    ON
  Instance(s):
    orcl2dg
  Properties:
    DGConnectIdentifier             = 'prdg19/orcl2dg'
    ObserverConnectIdentifier       = ''
    FastStartFailoverTarget         = ''
    PreferredObserverHosts          = ''
    LogShipping                     = 'ON'
    RedoRoutes                      = ''
    LogXptMode                      = 'sync'
    DelayMins                       = '0'
    Binding                         = 'optional'
    

DGMGRL>  EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;
Succeeded.
DGMGRL>     



--设置保护模式后：

DGMGRL>  SHOW CONFIGURATION lag verbose

Configuration - dg_config

  Protection Mode: MaxAvailability
  Members:
  orcl    - Primary database
    orcl2dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)
    orcl0dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    TraceLevel                      = 'USER'
    FastStartFailoverLagLimit       = '0'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'
    ConfigurationWideServiceName    = 'orcl_CFG'

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS

DGMGRL> 


--归档信息
log_archive_dest_2                   string      service="prdg19/orcl2dg", SYNC  ***** 同步传输
                                                  AFFIRM delay=0 optional compr
                                                 ession=disable max_failure=0 r
                                                 eopen=5 db_unique_name="orcl2d
                                                 g" net_timeout=30, valid_for=(
                                                 online_logfile,all_roles)
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string
log_archive_dest_27                  string
log_archive_dest_28                  string
log_archive_dest_29                  string 
log_archive_dest_3                   string      service="prdg19/orcl0dg", ASYN   *** 异步传输
                                                 C NOAFFIRM delay=0 optional co
                                                 mpression=disable max_failure=
                                                 0 reopen=5 db_unique_name="orc
                                                 l0dg" net_timeout=8, valid_for
                                                 =(online_logfile,all_roles)
                                                                                              

备库：hang rfs进程
SQL> set linesize 300
SQL> set pagesize 3000
SQL> select pid,NAME,TYPE,CLIENT_PID,THREAD#, BLOCK#,ROLE,ACTION,CLIENT_ROLE  from v$dataguard_process;

PID                      NAME  TYP CLIENT_PID    THREAD#     BLOCK# ROLE                     ACTION       CLIENT_ROLE
------------------------ ----- --- ---------- ---------- ---------- ------------------------ ------------ ----------------
5846                     LGWR  KSB          0          0          0 log writer               IDLE         none
5882                     TMON  KSB          0          0          0 redo transport monitor   IDLE         none
5950                     TT00  KSV          0          0          0 gap manager              IDLE         none
5956                     TT01  KSV          0          0          0 redo transport timer     IDLE         none
5948                     ARC0  KSB          0          0          0 archive local            IDLE         none
5958                     ARC1  KSB          0          0          0 archive redo             IDLE         none
5960                     ARC2  KSB          0          0          0 archive redo             IDLE         none
5962                     ARC3  KSB          0          0          0 archive redo             IDLE         none
6013                     INSV  KSB          0          0          0 broker instance slave    IDLE         none
5867                     DMON  KSB          0          0          0 broker monitor           IDLE         none
6075                     NSV0  KSB          0          0          0 broker net slave         IDLE         none
6438                     rfs   NET      22518          0          0 RFS archive              IDLE         archive gap
6460                     RSM0  KSB          0          0          0 broker worker            IDLE         none
6837                     MRP0  KSB          0          1         69 managed recovery         APPLYING_LOG none
16586                    rfs   NET      22521          1          0 RFS archive              IDLE         archive gap
19983                    rfs   NET      22104          1         69 RFS sync                 IDLE         log writer
20193                    rfs   NET      22509          1          0 RFS ping                 IDLE         gap manager
17 rows selected.

SQL> oradebug setospid 19983
Oracle pid: 48, Unix process pid: 19983, image: oracle@prdg19
SQL> oradebug suspend
Statement processed.
SQL> oradebug resume;
Statement processed.
SQL> oradebug suspend


--经过测试，主库到同城备库timeout内，主库hang
脚本：

alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
select sysdate from dual;
create table 03 as select 1 a from dual;
select sysdate from dual;

 

  结果：

SQL> select sysdate from dual;
SYSDATE
-------------------
2024-10-11 13:23:18
SQL> create table a03 as select 1 a from dual;
select sysdate from dual;
Table created.
SQL> 
SYSDATE
-------------------
2024-10-11 13:23:37



--保护模式降级
DGMGRL> SHOW CONFIGURATION lag verbose
Configuration - dg_config
  Protection Mode: MaxAvailability
  Members:
  orcl    - Primary database
    Warning: ORA-16629: database reports a different protection level from the protection mode
    orcl2dg - Physical standby database 
      Warning: ORA-16809: multiple warnings detected for the member
              Transport Lag:      2 minutes 7 seconds (computed 0 seconds ago)
              Apply Lag:          2 minutes 7 seconds (computed 0 seconds ago)

    orcl0dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)

 

DGMGRL> SHOW CONFIGURATION lag verbose

Configuration - dg_config

  Protection Mode: MaxAvailability
  Members:
  orcl    - Primary database
    orcl2dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)
    orcl0dg - Physical standby database 
              Transport Lag:      0 seconds (computed 0 seconds ago)
              Apply Lag:          0 seconds (computed 0 seconds ago)

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    TraceLevel                      = 'USER'
    FastStartFailoverLagLimit       = '0'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'
    ConfigurationWideServiceName    = 'orcl_CFG'

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS

DGMGRL>

oradebug resum 后恢复

标签：ago,computed,seconds,Lag,hang,传输,IDLE,timeout,archive
From： https://www.cnblogs.com/notonlydba/p/18458176

相关文章

  • SMB签名是一种通过数字签名技术保障数据在网络传输过程中的完整性和来源验证的机制。
    SMB签名是ServerMessageBlock（SMB）协议中的一种安全机制，旨在确保数据的完整性和身份验证。1.什么是SMB签名？SMB签名是一种通过数字签名技术保障数据在网络传输过程中的完整性和来源验证的机制。它通过对数据进行哈希处理，并附加一个签名，确保接收方能够确认收到的数据没有被篡改。......
  • CS224 Program Analysis@Shanghaitech 24 Fall Notes
    1.IntroductionRice'sTheoremStaticAnalysisanalyzesaprogramPtoreasonaboutitsbehaviorsanddetermineswhetheritsatisfiessomepropertiesbeforerunningP.Rice'sTheorem:Anynon-trivialpropertyofthebehaviorofprogramsinare......
  • 洛谷题单指南-字符串-P4391 [BOI2009] Radio Transmission 无线传输
    原题链接：https://www.luogu.com.cn/problem/P4391题意解读：s1由若干个s2组成，求s2的最小长度，注意题目中说明s1是子串，但是不影响，可以认为s1是补全的由若干s2组成的字符串。解题思路：设s1由x个s2组成，如图所示设s1的Next数组从0开始，那么其最长相同前后缀长度为x-1个s2，即Next[s1.siz......
  • 【FMC214】基于VITA57.1标准的4路12G SDI视频传输FMC子卡模块
     板卡概述FMC214是基于VITA57.1标准的4路12GSDI视频传输FMC子卡模块，该板卡可以作为一个理想的IO单元耦合至FPGA前端，4路BNC接口形式的SDI信号通过电平转换（线缆均衡器）连接至FMC（HPC）接口的高速串行总线上，与FPGA内部的万兆位级收发器（MGT）互联，FPGA内部的SDI固件IP来完成SDI的编解码。......
  • USB协议详解第12讲（USB传输-初探）
    1.USB传输、事务、包的关系USB传输、事务、包是从不同层次上去说明一次数据交互的三个概念。举个例子可能更好些，"某领导和一个早起的程序员进行了一次交流，说了5件事"。OK，其实这里的"这次交流"就相当于USB的一次传输，"说了5件事"就相当于这次传输过程中的5个事务，当然每件事肯定有......
  • The 2023 ICPC Asia Hangzhou Regional Contest (The 2nd Universal Cup. Stage 22: H
    The2023ICPCAsiaHangzhouRegionalContest(The2ndUniversalCup.Stage22:Hangzhou)M.V-Diagram题意：给定一个“v图”，求平均值最大的子"v图"思路：原图的最低点以及左右两个点必须取，如何先取满左边或者右边在贪心即可voidsolve(){lln;cin>>n;vect......
  • [Javascript] Using defineProperty to observe the object props changes
    constobj={a:1,b:2,c:{a:1,b:2,},};functionisObject(val){returnval!==null&&typeofval==="object";}functionobserve(obj){for(letkeyinobj){letv=obj[key];if(isObject(v)){......
  • Error: There was a timeout while attempting to connect to the network at undefin
     trufflemigrate--networksepolia报错Error:Therewasatimeoutwhileattemptingtoconnecttothenetworkatundefined.Checktoseethatyourproviderisvalid.Ifyouhaveaslowinternetconnection,tryconfiguringalongertimeoutin......
  • 基于VITA57.1标准的8路SFP+光纤通道数据传输FMC子卡模块
     板卡概述FMC213是我司自主研制的一块基于FMC标准的8路万兆光纤子卡模块。该板卡符合VITA57.1标准，该板卡可以作为一个理想的IO模块耦合至FPGA前端，8路SFP+的高速串行信号直接连接至FMC（HPC）接口的高速串行总线上，与FPGA内部的万兆位级收发器（MGT）互联，SFP+模块支持业界标准的小型可插......
  • RabbitMQ学习心得体会之Exchange
    参考：https://www.rabbitmq.com/tutorials/tutorial-three-dotnet在工作队列中，一个消息只会投递一个消费者，但是发布订阅模式，同一个消息可以发送个多个消费者。（交换）ExchangesrabbitMQ的核心是把生产者把消息发送给exchange，这个x一边是从p接收消息，一边是把这些消息推送给队列。生......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99