CONFIGURATION SET PROTECTION MODE
Syntax for change the Mode.
dgmgrl <<eof
connect sys/abc#123@lapprimdb
EDIT DATABASE 'lapdrdb' SET PROPERTY 'LogXptMode'='SYNC';
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
show configuration;
exit;
eof
[oraprd@prd1 STANDBY]$ cat change_mode_dg.sh
dgmgrl <<eof
connect sys/abc#123@lapprimdb
EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;
show configuration;
exit;
eof
dgmgrl <<eof
connect sys/abc#123@lapdrdb
show configuration;
show configuration verbose
show database verbose 'LAPDRDB';
show database verbose 'LAPPRIMDB';
exit
eof
echo "Bye...:"
connect sys/abc#123@lapprimdb
EDIT DATABASE 'lapdrdb' SET PROPERTY 'LogXptMode'='SYNC';
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
show configuration;
exit;
eof
[oraprd@prd1 STANDBY]$ cat change_mode_dg.sh
dgmgrl <<eof
connect sys/abc#123@lapprimdb
EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;
show configuration;
exit;
eof
dgmgrl <<eof
connect sys/abc#123@lapdrdb
show configuration;
show configuration verbose
show database verbose 'LAPDRDB';
show database verbose 'LAPPRIMDB';
exit
eof
echo "Bye...:"
[oraprd@prd2 STANDBY]$ ./5_show_dg.sh
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPDRDB"
Connected as SYSDBA.
DGMGRL>
Configuration - NewDR
Protection Mode: MaxPerformance
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 55 seconds ago)
DGMGRL>
Configuration - NewDR
Protection Mode: MaxPerformance ====> Change to Max Availability Mode
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby databaseProperties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'LAP_CFG'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
Database - LAPDRDB
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
LAPDRDB
Properties:
DGConnectIdentifier = 'lapdrdb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'prd2.hana.com'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.19)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPDRDB_DGMGRL.hana.com)(INSTANCE_NAME=LAPDRDB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /oracle/PRD/diag/rdbms/lapdrdb/LAPDRDB/trace/alert_LAPDRDB.log
Data Guard Broker log : /oracle/PRD/diag/rdbms/lapdrdb/LAPDRDB/trace/drcLAPDRDB.log
Database Status:
SUCCESS
DGMGRL>
Database - lapprimdb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 0 seconds (computed 1 second ago)
Average Apply Rate: 10.00 KByte/s
Active Apply Rate: 661.00 KByte/s
Maximum Apply Rate: 4.21 MByte/s
Real Time Query: OFF
Instance(s):
LAPPRIMDB
Properties:
DGConnectIdentifier = 'lapprimdb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''s
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'prd1.hana.com'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL.hana.com)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /oracle/PRD/diag/rdbms/lapprimdb/LAPPRIMDB/trace/alert_LAPPRIMDB.log
Data Guard Broker log : /oracle/PRD/diag/rdbms/lapprimdb/LAPPRIMDB/trace/drcLAPPRIMDB.log
Database Status:
SUCCESS
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPPRIMDB"
Connected as SYSDBA.
DGMGRL>
Property "LogXptMode" updated
DGMGRL> Error: ORA-16627: operation disallowed since no member would remain to support protection mode ===> i Got this Error
Failed.
DGMGRL>
Configuration - NewDR
Protection Mode: MaxPerformance===> Still Show Performance???
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 41 seconds ago)
DGMGRL>
Database - LAPDRDB
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
LAPDRDB
Properties:
DGConnectIdentifier = 'lapdrdb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'SYNC'===> Primary Show SYNC
BUT DR SIDE Show ASYNCH
DGMGRL>
Database - lapprimdb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 0 seconds (computed 1 second ago)
Average Apply Rate: 6.00 KByte/s
Active Apply Rate: 204.00 KByte/s
Maximum Apply Rate: 204.00 KByte/s
Real Time Query: OFF
Instance(s):
LAPPRIMDB
Properties:
DGConnectIdentifier = 'lapprimdb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'===> DR side still show
let me update ASYNC to SYNC
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'prd1.hana.com'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL.hana.com)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /oracle/PRD/diag/rdbms/lapprimdb/LAPPRIMDB/trace/alert_LAPPRIMDB.log
Data Guard Broker log : /oracle/PRD/diag/rdbms/lapprimdb/LAPPRIMDB/trace/drcLAPPRIMDB.log
Database Status:
SUCCESS
DGMGRL> Bye...:
Let me Update DR side.
[oraprd@prd1 STANDBY]$ cat change_mode_ava_dg.sh
dgmgrl <<eof
connect sys/abc#123@lapprimdb
EDIT DATABASE 'lapprimdb' SET PROPERTY 'LogXptMode'='SYNC';
show configuration;
exit;
eof
[oraprd@prd1 STANDBY]$ ./update_synch.sh
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 12:17:34 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPPRIMDB"
Connected as SYSDBA.
DGMGRL>
Property "LogXptMode" updated
DGMGRL>
Configuration - NewDR
Protection Mode: MaxPerformance
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 52 seconds ago)
DGMGRL> [oraprd@prd1 STANDBY]$
[oraprd@prd1 STANDBY]$ ./show_dg.sh
DGMGRL>
Database - lapprimdb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 0 seconds (computed 1 second ago)
Average Apply Rate: 3.00 KByte/s
Active Apply Rate: 204.00 KByte/s
Maximum Apply Rate: 204.00 KByte/s
Real Time Query: OFF
Instance(s):
LAPPRIMDB
Properties:
DGConnectIdentifier = 'lapprimdb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'SYNC'====> SYNCH
DelayMins = '0'
Now lets Try to Make it Max Available Mode.
[oraprd@prd2 STANDBY]$ ./change_mode_ava_dg.sh
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon May 31 12:19:15 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPPRIMDB"
Connected as SYSDBA.
DGMGRL> Property "LogXptMode" updated
DGMGRL> Succeeded.
DGMGRL>
Configuration - NewDR
Protection Mode: MaxAvailability
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 16 seconds ago)
DGMGRL>
[oraprd@prd2 STANDBY]$
[oraprd@prd2 STANDBY]$
DGMGRL>
Configuration - NewDR
Protection Mode: MaxAvailability ====> Max Available
Members:
LAPDRDB - Primary database
lapprimdb - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '0'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'LAP_CFG'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
Long Story in short would be.
1)EDIT DATABASE 'lapprimdb' SET PROPERTY 'LogXptMode'='SYNC';
2)EDIT DATABASE 'lapdrdb' SET PROPERTY 'LogXptMode'='SYNC';
3)connect sys/abc#123@lapdrdb
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
4)connect sys/abc#123@lapprimdb
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
No comments:
Post a Comment