{"id":5194,"date":"2021-06-04T07:18:22","date_gmt":"2021-06-04T07:18:22","guid":{"rendered":"https:\/\/swiv.com.br\/converting-the-physical-standby-database-to-snapshot-database-using-data-broker\/"},"modified":"2026-05-27T20:02:31","modified_gmt":"2026-05-27T19:02:31","slug":"converting-the-physical-standby-database-to-snapshot-database-using-data-broker","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/06\/04\/converting-the-physical-standby-database-to-snapshot-database-using-data-broker\/","title":{"rendered":"Converting the Physical Standby Database to Snapshot Database (using Data Broker)"},"content":{"rendered":"\n

Neste artigo, vamos explorar a convers\u00e3o de um Standby para Snapshot Database, usando o utilit\u00e1rio Data DGMGRL (Data Broker).<\/p>\n\n\n\n

Analisando condi\u00e7\u00e3o atual do ambiente:<\/p>\n\n\n

\n[oracle@fornix1 ~]$ dgmgrl sys\/CORTEX\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Jun 4 04:00:17 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 61 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 0 seconds ago)\n  Apply Lag:          0 seconds (computed 0 seconds ago)\n  Average Apply Rate: 8.00 KByte\/s\n  Real Time Query:    OFF\n  Instance(s):\n    CORTEXDR\n \nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\n
Podemos parar o processo de Redo Apply no Standby:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/CORTEXDR\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Jun 4 04:05:34 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> EDIT DATABASE CORTEXDR SET STATE=APPLY-OFF;\nSucceeded.\nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n  Role:               PHYSICAL STANDBY\n  Intended State:     APPLY-OFF\n  Transport Lag:      0 seconds (computed 1 second ago)\n  Apply Lag:          0 seconds (computed 1 second ago)\n  Average Apply Rate: (unknown)\n  Real Time Query:    OFF\n  Instance(s):\n    CORTEXDR\n \nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\n
Como nosso banco Standby est\u00e1 em MOUNT, podemos disparar o comando de convers\u00e3o para Snapshot:<\/p>\n\n\n
\nDGMGRL> CONVERT DATABASE 'cortexdr' TO SNAPSHOT STANDBY;\nConverting database "cortexdr" to a Snapshot Standby database, please wait...\nDatabase "cortexdr" converted successfully\n<\/pre><\/div>\n\n\n
Validando nova condi\u00e7\u00e3o do banco:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 4 04:08:10 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 DATABASE_ROLE, OPEN_MODE, FLASHBACK_ON FROM V$DATABASE;\n \nDATABASE_ROLE    OPEN_MODE            FLASHBACK_ON\n---------------- -------------------- ------------------\nSNAPSHOT STANDBY READ WRITE           YES\n<\/pre><\/div>\n\n\n
Realizando opera\u00e7\u00f5es de DDL e DML no Snapshot Database:<\/p>\n\n\n
\nSQL> CREATE TABLE SOE.TESTE2 (DESCRICAO VARCHAR2(50));\n \nTable created.\n \nSQL> INSERT INTO SOE.TESTE2 (DESCRICAO) VALUES ('SNAP DATABASE');\n \n1 row created.\n \nSQL> COMMIT;\n \nCommit complete.\n \nSQL> SELECT * FROM SOE.TESTE2;\n \nDESCRICAO\n--------------------------------------------------\nSNAP DATABASE\n<\/pre><\/div>\n\n\n
Podemos observar que os Redos provenientes do Primary ainda s\u00e3o endere\u00e7ados para o Standby, mas n\u00e3o s\u00e3o aplicados:<\/p>\n\n\n
\n[oracle@fornix1 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 4 04:11:20 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> ALTER SYSTEM SWITCH LOGFILE ;\n \nSystem altered.\n \nSQL> SELECT THREAD#, MAX(SEQUENCE#) FROM V$LOG GROUP BY THREAD# ;\n \n   THREAD# MAX(SEQUENCE#)\n---------- --------------\n         1             77\n<\/pre><\/div>\n\n
\n[oracle@fornix2 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 4 04:11:57 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 PROCESS,STATUS,SEQUENCE# FROM V$MANAGED_STANDBY;\n \nPROCESS   STATUS        SEQUENCE#\n--------- ------------ ----------\nDGRD      ALLOCATED             0\nARCH      CONNECTED             0\nDGRD      ALLOCATED             0\nARCH      CONNECTED             0\nARCH      CLOSING              75\nARCH      CLOSING              76\nDGRD      ALLOCATED             0\nRFS       IDLE                  0\nRFS       IDLE                 77\nRFS       IDLE                  0\n \n10 rows selected.\n<\/pre><\/div>\n\n\n
Obs: 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":"
Neste artigo, vamos explorar a convers\u00e3o de um Standby para Snapshot Database, usando o utilit\u00e1rio Data DGMGRL (Data Broker). Analisando condi\u00e7\u00e3o atual do ambiente: Podemos parar o processo de Redo Apply no Standby: Como nosso banco Standby est\u00e1 em MOUNT, podemos disparar o comando de convers\u00e3o para Snapshot: Validando nova condi\u00e7\u00e3o do banco: Realizando opera\u00e7\u00f5es […]<\/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-5194","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\/5194","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=5194"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5194\/revisions"}],"predecessor-version":[{"id":9111,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5194\/revisions\/9111"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}