dg oracle 切换模式_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,观察归档日志是否传输并进行了应用.

阅读(724) | 评论(0) | 转发(0) |