Neste artigo, vamos explorar uma op\u00e7\u00e3o de configura\u00e7\u00e3o de pol\u00edtica de dele\u00e7\u00e3o de archivelogs em ambiente Data Guard.<\/p>\n\n\n\n
Configura\u00e7\u00e3o de nosso ambiente laborat\u00f3rio:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ dgmgrl sys\/oracle@CORTEX as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 05:15:13 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 62 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: 13.00 KByte\/s\n Real Time Query: ON\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n \nDGMGRL>\n<\/pre><\/div>\n\n\nUma estrat\u00e9gia que podemos adotar no ambiente Primary \u00e9 configurar a pol\u00edtica abaixo, que permite o delete dos archivelog que j\u00e1 foram enviados para todos os ambientes Standby:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ rman target sys\/oracle@CORTEX CATALOG CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:16:17 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> configure ARCHIVELOG DELETION POLICY to SHIPPED TO ALL STANDBY;\n \nold RMAN configuration parameters:\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nnew RMAN configuration parameters:\nCONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;\nnew RMAN configuration parameters are successfully stored\nstarting full resync of recovery catalog\nfull resync complete\n \nRMAN>\n<\/pre><\/div>\n\n\nPara validar essa abordagem, vamos interromper os processos de transporte e Redo Apply do nosso ambiente:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ dgmgrl sys\/oracle@CORTEX as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 05:19:16 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-OFF;\nSucceeded.\nDGMGRL> EDIT DATABASE CORTEX SET STATE='TRANSPORT-OFF';\nSucceeded.\nDGMGRL>\n<\/pre><\/div>\n\n\nVamos gerar alguns archives novos no primary:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 29 05:20:29 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> \/\n \nSystem altered.\n \nSQL> \/\n \nSystem altered.\n \nSQL>\n<\/pre><\/div>\n\n\nAo tentar deletar os archivelogs, um erro \u00e9 apresentado pelo RMAN:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ rman target sys\/oracle@CORTEX CATALOG CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:29:56 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL ;\n \n \nstarting full resync of recovery catalog\nfull resync complete\n \nresyncing from database with DB_UNIQUE_NAME CORTEXDR\nDELETE ARCHIVELOG ALL;\nstarting resync of recovery catalog\nresync complete\n \nRMAN>\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=99 device type=DISK\nRMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_11.300.1076476837 thread=1 sequence=11\nRMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_12.299.1076476841 thread=1 sequence=12\nRMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_13.301.1076477377 thread=1 sequence=13\nRMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_14.302.1076477379 thread=1 sequence=14\nRMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_15.303.1076477379 thread=1 sequence=15\n \nRMAN>\n<\/pre><\/div>\n\n\nHabilitando novamente os servi\u00e7os de Transport e Redo Apply:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ dgmgrl sys\/oracle@CORTEX as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 05:31:39 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> EDIT DATABASE CORTEX SET STATE=TRANSPORT-ON;\nSucceeded.\nDGMGRL>\n<\/pre><\/div>\n\n\nAgora conseguimos realizar o delete dos archivelogs:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ rman target sys\/oracle@CORTEX CATALOG CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:32:50 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> DELETE ARCHIVELOG ALL;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=122 device type=DISK\nList of Archived Log Copies for database with db_unique_name CORTEX\n=====================================================================\n \nKey Thrd Seq S Low Time\n------- ---- ------- - ---------\n354 1 11 A 29-JUN-21\n Name: +DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_11.300.1076476837\n \n355 1 12 A 29-JUN-21\n Name: +DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_12.299.1076476841\n \n372 1 13 A 29-JUN-21\n Name: +DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_13.301.1076477377\n \n373 1 14 A 29-JUN-21\n Name: +DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_14.302.1076477379\n \n374 1 15 A 29-JUN-21\n Name: +DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_15.303.1076477379\n \n381 1 16 A 29-JUN-21\n Name: +DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_16.304.1076477535\n \n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_11.300.1076476837 RECID=140 STAMP=1076476837\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_12.299.1076476841 RECID=141 STAMP=1076476840\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_13.301.1076477377 RECID=142 STAMP=1076477377\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_14.302.1076477379 RECID=143 STAMP=1076477378\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_15.303.1076477379 RECID=144 STAMP=1076477379\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEX\/ARCHIVELOG\/2021_06_29\/thread_1_seq_16.304.1076477535 RECID=145 STAMP=1076477536\nDeleted 6 objects\n \n \nRMAN>\n<\/pre><\/div>\n\n\nJ\u00e1 do lado do Standby Database, podemos aplicar a pol\u00edtica abaixo, que apenas permite o delete dos archivelogs quandos os mesmos j\u00e1 foram aplicados no Standby:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ rman target sys\/oracle@CORTEXDR catalog CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:42:04 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\n \nold RMAN configuration parameters:\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nnew RMAN configuration parameters:\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nnew RMAN configuration parameters are successfully stored\n \nRMAN>\n<\/pre><\/div>\n\n\nRecebendo mensagem de erro ao tentar deletar o archivelog, pois os mesmos ainda n\u00e3o haviam sido aplicados no Standby:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ rman target sys\/oracle@CORTEXDR catalog CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:44:55 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL ;\n \n \nresyncing from database with DB_UNIQUE_NAME CORTEX\nstarting full resync of recovery catalog\nfull resync complete\n \nstarting resync of recovery catalog\nresync complete\n \nRMAN> DELETE ARCHIVELOG ALL;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=86 device type=DISK\nRMAN-08120: warning: archived log not deleted, not yet applied by standby\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_17.338.1076478291 thread=1 sequence=17\nRMAN-08120: warning: archived log not deleted, not yet applied by standby\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_18.343.1076478291 thread=1 sequence=18\n \nRMAN>\n<\/pre><\/div>\n\n\nAp\u00f3s alguns segundos, j\u00e1 \u00e9 poss\u00edvel delet\u00e1-los:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ rman target sys\/oracle@CORTEXDR catalog CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:47:13 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> DELETE ARCHIVELOG ALL;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=88 device type=DISK\nList of Archived Log Copies for database with db_unique_name CORTEXDR\n=====================================================================\n \nKey Thrd Seq S Low Time\n------- ---- ------- - ---------\n412 1 17 A 29-JUN-21\n Name: +DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_17.338.1076478291\n \n413 1 18 A 29-JUN-21\n Name: +DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_18.343.1076478291\n \n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_17.338.1076478291 RECID=67 STAMP=1076478290\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_18.343.1076478291 RECID=68 STAMP=1076478291\nDeleted 2 objects\n<\/pre><\/div>\n\n\nVamos baixar o processo de Redo Apply:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ dgmgrl sys\/oracle@CORTEXDR as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 05:49:45 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>\n<\/pre><\/div>\n\n\nGerando archives no Primary:<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 29 05:50:17 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> \/\n \nSystem altered.\n \nSQL>\n<\/pre><\/div>\n\n\nTentando deletar archives no standby:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ rman target sys\/oracle@CORTEXDR catalog CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:50:53 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> DELETE ARCHIVELOG ALL;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=87 device type=DISK\nRMAN-08120: warning: archived log not deleted, not yet applied by standby\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_19.343.1076478625 thread=1 sequence=19\nRMAN-08120: warning: archived log not deleted, not yet applied by standby\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_20.338.1076478627 thread=1 sequence=20\n \nRMAN>\n<\/pre><\/div>\n\n\nSubindo servi\u00e7o de Redo Apply:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ dgmgrl sys\/oracle@CORTEXDR as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 05:52:02 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-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 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 4.00 KByte\/s\n Real Time Query: ON\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\nDeletando archivelogs:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ rman target sys\/oracle@CORTEXDR catalog CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 05:56:13 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> DELETE ARCHIVELOG ALL;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=86 device type=DISK\nList of Archived Log Copies for database with db_unique_name CORTEXDR\n=====================================================================\n \nKey Thrd Seq S Low Time\n------- ---- ------- - ---------\n429 1 19 A 29-JUN-21\n Name: +DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_19.343.1076478625\n \n430 1 20 A 29-JUN-21\n Name: +DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_20.338.1076478627\n \n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_19.343.1076478625 RECID=69 STAMP=1076478626\ndeleted archived log\narchived log file name=+DG_RECO\/CORTEXDR\/ARCHIVELOG\/2021_06_29\/thread_1_seq_20.338.1076478627 RECID=70 STAMP=1076478626\nDeleted 2 objects\n \n \nRMAN>\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":"
Neste artigo, vamos explorar uma op\u00e7\u00e3o de configura\u00e7\u00e3o de pol\u00edtica de dele\u00e7\u00e3o de archivelogs em ambiente Data Guard. Configura\u00e7\u00e3o de nosso ambiente laborat\u00f3rio: Uma estrat\u00e9gia que podemos adotar no ambiente Primary \u00e9 configurar a pol\u00edtica abaixo, que permite o delete dos archivelog que j\u00e1 foram enviados para todos os ambientes Standby: Para validar essa abordagem, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5],"tags":[],"class_list":["post-5648","post","type-post","status-publish","format-standard","hentry","category-backup-recovery","category-high-availability"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5648","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=5648"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5648\/revisions"}],"predecessor-version":[{"id":9089,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5648\/revisions\/9089"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}