如何使用DGBroker关闭redo应用(1)

发布时间:2020-07-31 00:23:49 作者:roidba
来源:网络 阅读:737


A LITTLE EFFORT EVERY DAY.YOU WILL MAKE A BIG DIFFERENCE.


如何使用DGBroker关闭redo应用


一、描述

Oracle 12c

rhel 7


二、实验

1.查看配置

DGMGRL> show configuration;


Configuration - dg_config


  Protection Mode: MaxAvailability

  Members:

  orcl   - Primary database

    orcldg - Physical standby database 


Fast-Start Failover: DISABLED


Configuration Status:

SUCCESS   (status updated 27 seconds ago)


DGMGRL> 


2.查看数据库信息

DGMGRL> show database verbose orcl;


Database - orcl


  Role:               PRIMARY

  Intended State:     TRANSPORT-ON    --启用传输

  Instance(s):

    orcl


  Properties:

    DGConnectIdentifier             = 'orcl'

    ObserverConnectIdentifier       = ''

    LogXptMode                      = 'sync'

    RedoRoutes                      = ''

    DelayMins                       = '0'

    Binding                         = 'optional'

    MaxFailure                      = '0'

    MaxConnections                  = '1'

    ReopenSecs                      = '300'

    NetTimeout                      = '10'

    RedoCompression                 = 'DISABLE'

    LogShipping                     = 'ON'

    PreferredApplyInstance          = ''

    ApplyInstanceTimeout            = '0'

    ApplyLagThreshold               = '0'

    TransportLagThreshold           = '0'

    TransportDisconnectedThreshold  = '30'

    ApplyParallel                   = 'AUTO'

    StandbyFileManagement           = 'AUTO'

    ArchiveLagTarget                = '0'

    LogArchiveMaxProcesses          = '4'

    LogArchiveMinSucceedDest        = '1'

    DbFileNameConvert               = ''

    LogFileNameConvert              = ''

    FastStartFailoverTarget         = ''

    InconsistentProperties          = '(monitor)'

    InconsistentLogXptProps         = '(monitor)'

    SendQEntries                    = '(monitor)'

    LogXptStatus                    = '(monitor)'

    RecvQEntries                    = '(monitor)'

    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=roidb01)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'

    StandbyArchiveLocation          = '+DATADG/arch'

    AlternateLocation               = ''

    LogArchiveTrace                 = '0'

    LogArchiveFormat                = 'log_%t_%s_%r_%d.arc'

    TopWaitEvents                   = '(monitor)'


Database Status:

SUCCESS


DGMGRL> show database verbose orcldg;


Database - orcldg


  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: 0 Byte/s

  Active Apply Rate:  0 Byte/s

  Maximum Apply Rate: 0 Byte/s

  Real Time Query:    ON

  Instance(s):

    orcldg


  Properties:

    DGConnectIdentifier             = 'orcldg'

    ObserverConnectIdentifier       = ''

    LogXptMode                      = 'sync'

    RedoRoutes                      = ''

    DelayMins                       = '0'

    Binding                         = 'optional'

    MaxFailure                      = '0'

    MaxConnections                  = '1'

    ReopenSecs                      = '300'

    NetTimeout                      = '10'

    RedoCompression                 = 'DISABLE'

    LogShipping                     = 'ON'

    PreferredApplyInstance          = ''

    ApplyInstanceTimeout            = '0'

    ApplyLagThreshold               = '0'

    TransportLagThreshold           = '0'

    TransportDisconnectedThreshold  = '30'

    ApplyParallel                   = 'AUTO'

    StandbyFileManagement           = 'AUTO'

    ArchiveLagTarget                = '0'

    LogArchiveMaxProcesses          = '4'

    LogArchiveMinSucceedDest        = '1'

    DbFileNameConvert               = ''

    LogFileNameConvert              = ''

    FastStartFailoverTarget         = ''

    InconsistentProperties          = '(monitor)'

    InconsistentLogXptProps         = '(monitor)'

    SendQEntries                    = '(monitor)'

    LogXptStatus                    = '(monitor)'

    RecvQEntries                    = '(monitor)'

    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=roidb02)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcldg_DGMGRL)(INSTANCE_NAME=orcldg)(SERVER=DEDICATED)))'

    StandbyArchiveLocation          = '+DATADG/arch'

    AlternateLocation               = ''

    LogArchiveTrace                 = '0'

    LogArchiveFormat                = 'log_%t_%s_%r_%d.arc'

    TopWaitEvents                   = '(monitor)'


Database Status:

SUCCESS


DGMGRL> edit database 'orcldg' set state='apply-off';

Succeeded.

DGMGRL> 


SQL> select process,status from v$managed_standby;


PROCESS   STATUS

--------- ------------

ARCH      CLOSING

ARCH      CLOSING

ARCH      CONNECTED

ARCH      CLOSING

RFS       IDLE

RFS       IDLE

RFS       IDLE

RFS       IDLE


8 rows selected.


DGMGRL> edit database 'orcldg' set state='apply-on';   

Succeeded.

DGMGRL> 


SQL> /


PROCESS   STATUS

--------- ------------

ARCH      CLOSING

ARCH      CLOSING

ARCH      CONNECTED

ARCH      CLOSING

RFS       IDLE

RFS       IDLE

RFS       IDLE

RFS       IDLE

MRP0      APPLYING_LOG


9 rows selected.


三、知识点

1.使用DGBroker启停redo apply 

2.物理standby 数据库状态

3.MRP0进程作用


官网解释如下:


Physical standby


APPLY-ON

Redo Apply is started on a physical standby database.  --启动redo应用

If the standby database is an Oracle RAC database, the broker starts Redo Apply on exactly one standby instance, 

called the apply instance. If this instance fails, the broker automatically chooses another instance that is either 

mounted or open read-only. This new instance then becomes the apply instance.

This is the default state for a physical standby database when it is enabled for the first time.

If a license for the Oracle Active Data Guard option has been purchased, a physical standby database

can be open while Redo Apply is active. This capability is known as real-time query. 

See Oracle Data Guard Concepts and Administration for more details.


Physical standby


APPLY-OFF

Redo Apply is stopped.  --关闭redo应用

If this is an Oracle RAC database, there is no instance running Apply Services until you change the database state to APPLY-ON.


推荐阅读:
  1. DGBroker修改数据库属性(2)
  2. The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1)

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

dg broker edit database

上一篇:如何建立大数据风控的框架

下一篇:关于手游的开发

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》