O processo de Switchover utilizando o Data Broker \u00e9 basicamente o mesmo, para ambientes physical ou logical standby. Neste artigo simularei o processo em cima de um physical.<\/p>\n\n\n\n
Checando a condi\u00e7\u00e3o atual do ambiente:<\/p>\n\n\n
\n[oracle@fornix1 ~]$ dgmgrl sys\/oracle@CORTEX\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 04:46:58 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortex"\nConnected as SYSDBA.\nDGMGRL> SHOW CONFIGURATION;\n \nConfiguration - cortex\n \n Protection Mode: MaxPerformance\n Members:\n cortex - Primary database\n cortexdr - Physical standby database\n \nFast-Start Failover: Disabled\n \nConfiguration Status:\nSUCCESS (status updated 22 seconds ago)\n \nDGMGRL> SHOW DATABASE CORTEX;\n \nDatabase - cortex\n \n Role: PRIMARY\n Intended State: TRANSPORT-ON\n Instance(s):\n cortex\n \nDatabase Status:\nSUCCESS\n \nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-OFF\n Transport Lag: 0 seconds (computed 0 seconds ago)\n Apply Lag: (unknown)\n Average Apply Rate: (unknown)\n Real Time Query: OFF\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n \nDGMGRL>\n<\/pre><\/div>\n\n\n\u00c9 poss\u00edvel ver que o Redo Apply ainda est\u00e1 OFF no standby. Por\u00e9m, antes de lig\u00e1-lo, vamos criar o Flashback Database Guaranteed Restore Point (GRP) nos bancos envolvidos, para termos esse m\u00e9todo de rollback em caso de falha na opera\u00e7\u00e3o de Switchover:<\/p>\n\n\n
\n[oracle@fornix1 ~]$ sqlplus sys\/oracle@CORTEX as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 04:50:38 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> CREATE RESTORE POINT before_switchover GUARANTEE FLASHBACK DATABASE;\n \nRestore point created.\n<\/pre><\/div>\n\n\n[oracle@fornix2 ~]$ sqlplus sys\/oracle@CORTEXDR as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 04:51:21 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> CREATE RESTORE POINT before_switchover GUARANTEE FLASHBACK DATABASE;\n \nRestore point created.\n<\/pre><\/div>\n\n\nLigando o Redo Apply:<\/p>\n\n\n
\n[oracle@fornix1 ~]$ dgmgrl sys\/oracle@CORTEX\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 04:52:25 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortex"\nConnected as SYSDBA.\nDGMGRL> EDIT DATABASE CORTEXDR SET STATE=APPLY-ON;\nSucceeded.\nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 0 seconds ago)\n Apply Lag: (unknown)\n Average Apply Rate: (unknown)\n Real Time Query: OFF\n Instance(s):\n CORTEXDR\n \n Database Warning(s):\n ORA-16854: apply lag could not be determined\n \nDatabase Status:\nWARNING\n \nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 105.00 KByte\/s\n Real Time Query: OFF\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\n\u00c9 necess\u00e1rio confirmar se os bancos (primary e standby) est\u00e3o registrados de forma est\u00e1tica no listener. No meu caso, j\u00e1 estavam registrados com sucesso:<\/p>\n\n\n
\n[grid@fornix1 admin]$ cat listener.ora\n#Backup file is \/grid\/19.3.0\/base\/crsdata\/fornix1\/output\/listener.ora.bak.fornix1.grid line added by Agent\n#LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent\nVALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent\n \nLISTENER =\n (DESCRIPTION_LIST =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP) (HOST = fornix1.localdomain) (PORT = 1521))\n (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1522))\n )\n )\n \nSID_LIST_LISTENER =\n (SID_LIST =\n (SID_DESC =\n (GLOBAL_DBNAME = CORTEX_DGMGRL.localdomain)\n (ORACLE_HOME = \/grid\/19.3.0\/product)\n (SID_NAME = CORTEX)\n )\n)\n<\/pre><\/div>\n\n\n[grid@fornix2 admin]$ cat listener.ora\n#Backup file is \/grid\/19.3.0\/base\/crsdata\/fornix2\/output\/listener.ora.bak.forni x2.grid line added by Agent\nLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent\nVALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent\n \nLISTENERDR =\n (DESCRIPTION_LIST =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP) (HOST = fornix2.localdomain) (PORT = 1522))\n (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1522))\n )\n )\n \nSID_LIST_LISTENERDR=\n (SID_LIST=\n (SID_DESC=\n (GLOBAL_DBNAME=CORTEXDR.localdomain)\n (SID_NAME=CORTEXDR)\n (ORACLE_HOME=\/oracle\/19.3.0\/product)\n )\n ( SID_DESC=\n (GLOBAL_DBNAME=CORTEXDR_DGMGRL.localdomain)\n (ORACLE_HOME=\/grid\/19.3.0\/product)\n (SID_NAME=CORTEXDR)\n )\n )\nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENERDR=ON # line added by Agent\nVALID_NODE_CHECKING_REGISTRATION_LISTENERDR=ON # line added by Agent\n<\/pre><\/div>\n\n\nConfirmando se o ambiente standby est\u00e1 recebendo todos os redos:<\/p>\n\n\n
\n[oracle@fornix1 ~]$ sqlplus sys\/oracle@CORTEX as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 04:58:15 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> SELECT THREAD#,SEQUENCE#,STATUS FROM V$LOG;\n \n THREAD# SEQUENCE# STATUS\n---------- ---------- ----------------\n 1 70 INACTIVE\n 1 71 INACTIVE\n 1 72 CURRENT\n<\/pre><\/div>\n\n\n[oracle@fornix2 ~]$ sqlplus sys\/oracle@CORTEXDR as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 04:58:48 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> SELECT CLIENT_PROCESS,PROCESS,SEQUENCE#,STATUS FROM V$MANAGED_STANDBY;\n \nCLIENT_P PROCESS SEQUENCE# STATUS\n-------- --------- ---------- ------------\nLGWR RFS 72 IDLE\nUNKNOWN RFS 0 IDLE\nArchival RFS 0 IDLE\nARCH ARCH 0 CONNECTED\nN\/A DGRD 0 ALLOCATED\nN\/A DGRD 0 ALLOCATED\nARCH ARCH 0 CONNECTED\nARCH ARCH 71 CLOSING\nARCH ARCH 0 CONNECTED\nN\/A MRP0 72 APPLYING_LOG\n \n10 rows selected.\n<\/pre><\/div>\n\n\nA forma alternativa de confirmar isso \u00e9 pelo utilit\u00e1rio do broker:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/oracle@CORTEXDR\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 04:59:43 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortexDR"\nConnected as SYSDBA.\nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 0 seconds ago)\n Apply Lag: 0 seconds (computed 0 seconds ago)\n Average Apply Rate: 12.00 KByte\/s\n Real Time Query: OFF\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\nConfirmando que o status do processo MRP est\u00e1 como “APPLYING_LOG”:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ sqlplus sys\/oracle@CORTEXDR as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 05:00:51 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> SELECT STATUS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE 'MRP%';\n \nSTATUS\n------------\nAPPLYING_LOG\n<\/pre><\/div>\n\n\nNesta etapa j\u00e1 estamos prontos para realizar o validate no atual standby, para verificar se o mesmo est\u00e1 apto a virar o novo primary. Podemos assim j\u00e1 ficar monitorando o alert.log dos 2 bancos, al\u00e9m do alert do pr\u00f3prio broker. Realizando o validate:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/oracle@CORTEXDR\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 05:02:25 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortexDR"\nConnected as SYSDBA.\nDGMGRL> VALIDATE DATABASE CORTEXDR;\n \n Database Role: Physical standby database\n Primary Database: cortex\n \n Ready for Switchover: Yes\n Ready for Failover: Yes (Primary Running)\n \n Managed by Clusterware:\n cortex : YES\n cortexdr: YES\n \n Log Files Cleared:\n cortex Standby Redo Log Files: Cleared\n cortexdr Online Redo Log Files: Not Cleared\n cortexdr Standby Redo Log Files: Available\n \n Transport-Related Property Settings:\n Property cortex Value cortexdr Value\n ReopenSecs 300 20\n NetTimeout 30 20\n \nDGMGRL>\n<\/pre><\/div>\n\n\nNo alert do standby:<\/p>\n\n\n
\n2021-04-20T05:02:45.120419-03:00\nSWITCHOVER VERIFY BEGIN\nSWITCHOVER VERIFY COMPLETE\n<\/pre><\/div>\n\n\nRealizando finalmente o switchover:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/oracle@CORTEXDR\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 05:06:28 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortexDR"\nConnected as SYSDBA.\nDGMGRL> SWITCHOVER TO CORTEXDR;\nPerforming switchover NOW, please wait...\nNew primary database "cortexdr" is opening...\nOracle Clusterware is restarting database "cortex" ...\nConnected to "cortex"\nConnected to "cortex"\nSwitchover succeeded, new primary is "cortexdr"\nDGMGRL>\n<\/pre><\/div>\n\n\nAlert do antigo primary e novo standby:<\/p>\n\n\n
\n2021-04-20T05:06:47.157685-03:00\nRSM0 (PID:3680): Switchover complete. Database shutdown required\nTMI: dbsdrv switchover to target END 2021-04-20 05:06:47.157717\nCompleted: ALTER DATABASE SWITCHOVER TO 'cortexdr'\n2021-04-20T05:06:47.319037-03:00\nStarting background process NSV0\n2021-04-20T05:06:47.329677-03:00\nNSV0 started with pid=53, OS id=5572\n2021-04-20T05:06:58.081998-03:00\nClusterware restarting instance for Data Guard Broker operation; shutting down instance now\n<\/pre><\/div>\n\n\nAlert do antigo standby e novo primary:<\/p>\n\n\n
\n2021-04-20T05:06:47.554811-03:00\n rmi (PID:5162): Database role cleared from PHYSICAL STANDBY [kcvs.c:1030]\nSwitchover: Complete - Database mounted as primary\nTMI: kcv_commit_to_so_to_primary Switchover from physical END 2021-04-20 05:06:47.556114\nSWITCHOVER: completed request from primary database.\n<\/pre><\/div>\n\n\nAlert do Broker:<\/p>\n\n\n
\n2021-04-20T05:06:47.158-03:00\nSQL [ALTER DATABASE SWITCHOVER TO 'cortexdr'] executed successfully\nSwitchover successful\n<\/pre><\/div>\n\n\nVerificando a nova configura\u00e7\u00e3o do ambiente:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/oracle@CORTEXDR\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 05:14:43 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortexDR"\nConnected as SYSDBA.\nDGMGRL> SHOW CONFIGURATION;\n \nConfiguration - cortex\n \n Protection Mode: MaxPerformance\n Members:\n cortexdr - Primary database\n cortex - Physical standby database\n \nFast-Start Failover: Disabled\n \nConfiguration Status:\nSUCCESS (status updated 55 seconds ago)\n \nDGMGRL> SHOW DATABASE CORTEX;\n \nDatabase - cortex\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 0 seconds ago)\n Apply Lag: 0 seconds (computed 0 seconds ago)\n Average Apply Rate: 18.00 KByte\/s\n Real Time Query: OFF\n Instance(s):\n cortex\n \nDatabase Status:\nSUCCESS\n \nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PRIMARY\n Intended State: TRANSPORT-ON\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\nRealizando o Switchback:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/oracle@CORTEXDR\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Apr 20 05:16:25 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortexDR"\nConnected as SYSDBA.\nDGMGRL> SWITCHOVER TO CORTEX;\nPerforming switchover NOW, please wait...\nOperation requires a connection to database "cortex"\nConnecting ...\nConnected to "cortex"\nConnected as SYSDBA.\nNew primary database "cortex" is opening...\nOracle Clusterware is restarting database "cortexdr" ...\nConnected to an idle instance.\nConnected to an idle instance.\nConnected to an idle instance.\nConnected to an idle instance.\nConnected to an idle instance.\nConnected to "cortexDR"\nConnected to "cortexDR"\nSwitchover succeeded, new primary is "cortex"\nDGMGRL> SHOW CONFIGURATION;\n \nConfiguration - cortex\n \n Protection Mode: MaxPerformance\n Members:\n cortex - Primary database\n cortexdr - Physical standby database\n \nFast-Start Failover: Disabled\n \nConfiguration Status:\nSUCCESS (status updated 48 seconds ago)\n \nDGMGRL> SHOW DATABASE CORTEX;\n \nDatabase - cortex\n \n Role: PRIMARY\n Intended State: TRANSPORT-ON\n Instance(s):\n cortex\n \nDatabase Status:\nSUCCESS\n \nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 56.00 KByte\/s\n Real Time Query: OFF\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n \nDGMGRL>\n<\/pre><\/div>\n\n\nRemovendo os GRPs criados:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 05:22:05 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> DROP RESTORE POINT before_switchover;\n \nRestore point dropped.\n<\/pre><\/div>\n\n\n[oracle@fornix1 ~]$ sqlplus sys\/oracle@CORTEX as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 05:22:41 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> DROP RESTORE POINT before_switchover;\n \nRestore point dropped.\n<\/pre><\/div>\n\n\nObs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"
O processo de Switchover utilizando o Data Broker \u00e9 basicamente o mesmo, para ambientes physical ou logical standby. Neste artigo simularei o processo em cima de um physical. Checando a condi\u00e7\u00e3o atual do ambiente: \u00c9 poss\u00edvel ver que o Redo Apply ainda est\u00e1 OFF no standby. Por\u00e9m, antes de lig\u00e1-lo, vamos criar o Flashback Database […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3960","post","type-post","status-publish","format-standard","hentry","category-high-availability"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=3960"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3960\/revisions"}],"predecessor-version":[{"id":9163,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3960\/revisions\/9163"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}