[Oracle] Oracle数据库 DGbroker三种保护模式的切换

DGMGRL> show configuration verbose;
Configuration - dgc
 Protection Mode: MaxPerformance
 Databases:
 atest1 - Primary database
 atest2 - 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:
SUCCESS

SQL> select database_role,protection_mode,protection_level from v$database;
DATABASE_ROLE  PROTECTION_MODE  PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY  MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

DGMGRL> show database verbose 'atest2';
Database - atest2
 Role:   PHYSICAL STANDBY
 Intended State: APPLY-ON
 Transport Lag: 0 seconds (computed 1 second ago)
 Apply Lag:  0 seconds (computed 1 second ago)
 Apply Rate:  97.00 KByte/s
 Real Time Query: ON
 Instance(s):
 atest
 Properties:
 DGConnectIdentifier  = 'atest2'
 ObserverConnectIdentifier  = ''
 LogXptMode    = 'sync'
 DelayMins    = '0'
 Binding     = 'optional'
 MaxFailure    = '0'
 MaxConnections   = '1'
 ReopenSecs    = '300'
 NetTimeout    = '30'
 RedoCompression   = 'DISABLE'
 LogShipping    = 'ON'
 PreferredApplyInstance   = ''
 ApplyInstanceTimeout   = '0'
 ApplyParallel   = 'AUTO'
 StandbyFileManagement   = 'AUTO'
 ArchiveLagTarget  = '0'
 LogArchiveMaxProcesses   = '4'
 LogArchiveMinSucceedDest  = '1'
 DbFileNameConvert  = ''
 LogFileNameConvert  = ''
 FastStartFailoverTarget   = ''
 InconsistentProperties   = '(monitor)'
 InconsistentLogXptProps   = '(monitor)'
 SendQEntries   = '(monitor)'
 LogXptStatus   = '(monitor)'
 RecvQEntries   = '(monitor)'
 ApplyLagThreshold  = '0'
 TransportLagThreshold   = '0'
 TransportDisconnectedThreshold = '30'
 SidName     = 'atest'
 StaticConnectIdentifier   = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vijay02.database.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=atest2_DGMGRL)(INSTANCE_NAME=atest)(SERVER=DEDICATED)))'
 StandbyArchiveLocation   = '/u01/app/oracle/oradata/ATEST/archivelog'
 AlternateLocation  = ''
 LogArchiveTrace   = '0'
 LogArchiveFormat  = '%t_%s_%r.dbf'
 TopWaitEvents   = '(monitor)'
Database Status:
SUCCESS

DGMGRL> edit database atest1 set property logxptmode=sync;
Property "logxptmode" updated

DGMGRL> edit configuration set protection mode as maxavailability;
Succeeded.

DGMGRL> edit configuration set protection mode as maxprotection;
Operation requires shutdown of instance "atest" on database "atest1"
Shutting down instance "atest"...
Unable to connect to database
ORA-12545: Connect failed because target host or object does not exist
Failed.
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish the operation:
 shut down instance "atest" of database "atest1"
 start up instance "atest" of database "atest1"