Hi Oracle Gurus,
Our Environment:
Oracle12c 2-Node Grid/RAC with ASM on RHEL Platform
Exiting Database Deployment:
RAC to RAC Active Data guard
Solution we are looking for:
We want to configure Data guard - Data broker FSFO with Maximum Performance Mode.
We don't want to configure Flashback database on primary or standby.
We don't want to reinstate automatically.
DGMGRL> show configuration
Configuration - DGConfig
Protection Mode: MaxPerformance
Members:
blrdb - Primary database
blrdr - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 44 seconds ago)
DGMGRL> show fast_start failover;
Fast-Start Failover: DISABLED
Threshold: 60 seconds
Target: (none)
Observer: csm-srv-130
Lag Limit: 10 seconds
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Offline YES
Oracle Error Conditions:
(n
one)
DGMGRL> show configuration verbose
Configuration - DGConfig
Protection Mode: MaxPerformance
Members:
blrdb - Primary database
blrdr - Physical standby database
Properties:
FastStartFailoverThreshold = '60'
OperationTimeout = '30'
TraceLevel = 'SUPPORT'
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
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover
Regards,
Hitgon