如何使用DGBroker關(guān)閉redo應(yīng)用（1）

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

如何使用DGBroker關(guān)閉redo應(yīng)用

一、描述

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.查看數(shù)據(jù)庫信息

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   --應(yīng)用啟用

  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.

三、知識點(diǎn)

1.使用DGBroker啟停redo apply 

2.物理standby 數(shù)據(jù)庫狀態(tài)

3.MRP0進(jìn)程作用

官網(wǎng)解釋如下：

Physical standby

APPLY-ON

Redo Apply is started on a physical standby database.  --啟動redo應(yīng)用

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.  --關(guān)閉redo應(yīng)用

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