We just found that one of the setups was wrongly configured as MaxPerformance. Since Oracle 11.2 it is possible to increase the protection mode without restarting the primary (if going from MaxPerformance to MaxProtection you need to do in two steps, through MaxPerformance).<\/p>\n
Here how to move from MaxPerformance to MaxAvailability in a config with DataGuard Broker (removed some lines to make it shorter):<\/p>\n
\r\nDGMGRL> connect \/\r\nConnected.\r\n\r\nDGMGRL> show configuration\r\n\r\nConfiguration - azores\r\n\r\n Protection Mode: MaxPerformance\r\n Databases:\r\n azores_site1 - Primary database\r\n azores_site2 - (*) Physical standby database\r\n\r\nFast-Start Failover: ENABLED\r\n\r\nConfiguration Status:\r\nSUCCESS\r\n\r\nDGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;\r\nError: ORA-16654: fast-start failover is enabled\r\n\r\nFailed.\r\n\r\nDGMGRL> stop observer\r\nDone.\r\nDGMGRL> show configuration\r\n\r\nConfiguration - azores\r\n\r\n Protection Mode: MaxPerformance\r\n Databases:\r\n azores_site1 - Primary database\r\n Warning: ORA-16819: fast-start failover observer not started\r\n\r\n azores_site2 - (*) Physical standby database\r\n Warning: ORA-16819: fast-start failover observer not started\r\n\r\nFast-Start Failover: ENABLED\r\n\r\nConfiguration Status:\r\nWARNING\r\n\r\nDGMGRL> DISABLE FAST_START FAILOVER\r\nDisabled.\r\nDGMGRL> show configuration\r\n\r\nConfiguration - azores\r\n\r\n Protection Mode: MaxPerformance\r\n Databases:\r\n azores_site1 - Primary database\r\n azores_site2 - Physical standby database\r\n\r\nFast-Start Failover: DISABLED\r\n\r\nConfiguration Status:\r\nSUCCESS\r\n\r\nDGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;\r\nError: ORA-16627: operation disallowed since no standby databases would remain to support protection mode\r\nFailed.\r\n\r\nDGMGRL> show database verbose azores_site1\r\n\r\nDatabase - azores_site1\r\n\r\n Role: PRIMARY\r\n Intended State: TRANSPORT-ON\r\n Instance(s):\r\n azores\r\n\r\n Properties:\r\n DGConnectIdentifier = 'azores_site1.portugal'\r\n ObserverConnectIdentifier = ''\r\n LogXptMode = 'async'\r\n\t...\r\n\t\r\nDatabase Status:\r\nSUCCESS\r\n\r\nDGMGRL> show database verbose azores_site2\r\n\r\nDatabase - azores_site2\r\n\r\n Role: PHYSICAL STANDBY\r\n Intended State: APPLY-ON\r\n Transport Lag: 0 seconds (computed 2 seconds ago)\r\n Apply Lag: 0 seconds (computed 2 seconds ago)\r\n Apply Rate: 1.84 MByte\/s\r\n Real Time Query: OFF\r\n Instance(s):\r\n azores\r\n\r\n Properties:\r\n DGConnectIdentifier = 'azores_site2.portugal'\r\n ObserverConnectIdentifier = ''\r\n LogXptMode = 'async'\r\n\t...\r\n\t\r\nDatabase Status:\r\nSUCCESS\r\n\r\nDGMGRL> edit database azores_site2 set state=APPLY-OFF;\r\nSucceeded.\r\nDGMGRL> edit database azores_site2 set property LogXptMode='SYNC';\r\nProperty "logxptmode" updated\r\nDGMGRL> edit database azores_site1 set property LogXptMode='SYNC';\r\nProperty "logxptmode" updated\r\nDGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;\r\nSucceeded.\r\nDGMGRL> show configuration;\r\n\r\nConfiguration - azores\r\n\r\n Protection Mode: MaxAvailability\r\n Databases:\r\n azores_site1 - Primary database\r\n azores_site2 - Physical standby database\r\n\r\nFast-Start Failover: DISABLED\r\n\r\nConfiguration Status:\r\nSUCCESS\r\n\r\nDGMGRL> enable fast_start failover;\r\nEnabled.\r\n\r\nDGMGRL> edit database azores_site2 set state=APPLY-ON;\r\nSucceeded.\r\n\r\nDGMGRL> show database verbose azores_site2\r\n\r\nDatabase - azores_site2\r\n\r\n Role: PHYSICAL STANDBY\r\n Intended State: APPLY-ON\r\n Transport Lag: 0 seconds (computed 1 second ago)\r\n Apply Lag: 0 seconds (computed 1 second ago)\r\n\r\nDatabase Status:\r\nSUCCESS\r\n\r\nDGMGRL> show configuration;\r\n\r\nConfiguration - azores\r\n\r\n Protection Mode: MaxAvailability\r\n Databases:\r\n azores_site1 - Primary database\r\n azores_site2 - (*) Physical standby database\r\n\r\nFast-Start Failover: ENABLED\r\n\r\nConfiguration Status:\r\nSUCCESS\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"We just found that one of the setups was wrongly configured as MaxPerformance. Since Oracle 11.2 it is possible to increase the protection mode without restarting the primary (if going from MaxPerformance to MaxProtection you need to do in two steps, through MaxPerformance). Here how to move from MaxPerformance to MaxAvailability in a config with […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,2],"tags":[],"class_list":{"0":"post-231","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dataguard","7":"category-oracle-11g","8":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=231"}],"version-history":[{"count":2,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/231\/revisions"}],"predecessor-version":[{"id":233,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/231\/revisions\/233"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}