DG BROKER模式下关闭Data Guard传输以及打开DG的步骤

DG BROKER关闭DG以及打开DG步骤

1.进入dgmgrl管理
oracle@oratest:~> dgmgrl /
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.

2.检查DG状态
DGMGRL> show configuration verbose;
Configuration - cpscv
  Protection Mode: MaxAvailability
  Databases:
    cpscv   - Primary database
    Warning: ORA-16809: multiple warnings detected for the database

    cpscvdg - Physical standby database
    Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: DISABLED
Configuration Status:
WARNING

3.关闭Data Guard
直接sqlplus / as sysdba;
然后 shutdown immediate;

4.开启Data Guard
Sqlplus / as sysdba;
Startup mount;

5.然后再进入dgmgrl里检查DG状态.(一般显示的是Success,但是由于可能保护模式不一样,所以显示warning.)

6.主库再进行一次日志切换，再检查查备库视图的applied,观察归档日志是否传输并进行了应用.