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,观察归档日志是否传输并进行了应用.