{"id":4126,"date":"2021-04-28T07:31:31","date_gmt":"2021-04-28T07:31:31","guid":{"rendered":"https:\/\/swiv.com.br\/comparing-compressed-rman-backups\/"},"modified":"2026-05-27T20:02:32","modified_gmt":"2026-05-27T19:02:32","slug":"comparing-compressed-rman-backups","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/04\/28\/comparing-compressed-rman-backups\/","title":{"rendered":"Comparing Compressed RMAN Backups"},"content":{"rendered":"\n<p>Caso precisemos aplicar algum tipo de compress\u00e3o nos backups realizados no Oracle, nos \u00e9 dada a op\u00e7\u00e3o de utilizar os pr\u00f3prios algoritmos de compress\u00e3o bin\u00e1ria do RMAN. Este tipo de opera\u00e7\u00e3o reduz o tamanho dos backups, e por padr\u00e3o, opera com a configura\u00e7\u00e3o BASIC (que n\u00e3o exige nenhum licenciamento extra). Caso seja relevante utilizar os outros tipos, como LOW,MEDIUM e HIGH, a licen\u00e7a &#8220;Oracle Advanced Compression&#8221; ser\u00e1 necess\u00e1ria. Obviamente este recurso traz um economia em rela\u00e7\u00e3o ao espa\u00e7o em disco\/fita necess\u00e1rios, mas exige mais processamento (CPU). Por outro lado, nenhuma etapa adicional \u00e9 necess\u00e1ria para realizar o restore a partir deste backups. Neste artigo exploraremos sobre estas diferen\u00e7as t\u00e9cnicas. <\/p>\n\n\n\n<p>Analisando o algoritmo de compress\u00e3o vigente:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue Apr 27 06:39:34 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt; SHOW COMPRESSION ALGORITHM;\n \nusing target database control file instead of recovery catalog\nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE COMPRESSION ALGORITHM &#039;BASIC&#039; AS OF RELEASE &#039;DEFAULT&#039; OPTIMIZE FOR LOAD TRUE ; # default\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Realizando um backup do banco de dados com esta op\u00e7\u00e3o habilitada:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; run {\n        ALLOCATE CHANNEL c1 DEVICE TYPE DISK;\n        BACKUP DATABASE TAG &#039;SEM_COMPRESSAO&#039;;\n}2&gt; 3&gt; 4&gt;\n \nallocated channel: c1\nchannel c1: SID=1 device type=DISK\n \nStarting backup at 2021-04-27:06:41:59\nchannel c1: starting full datafile backup set\nchannel c1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel c1: starting piece 1 at 2021-04-27:06:41:59\nchannel c1: finished piece 1 at 2021-04-27:06:43:54\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_27\/o1_mf_nnndf_SEM_COMPRESSAO_j8hq3l7z_.bkp tag=SEM_COMPRESSAO comment=NONE\nchannel c1: backup set complete, elapsed time: 00:01:55\nFinished backup at 2021-04-27:06:43:54\n \nStarting Control File and SPFILE Autobackup at 2021-04-27:06:43:54\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_27\/o1_mf_s_1070952234_j8hq6vpz_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-27:06:43:57\nreleased channel: c1\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Coletando as informa\u00e7\u00f5es deste backup para compara\u00e7\u00e3o posterior:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUPSET TAG &#039;SEM_COMPRESSAO&#039;;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n202     Full    1.22G      DISK        00:01:27     2021-04-27:06:43:26\n        BP Key: 202   Status: AVAILABLE  Compressed: NO  Tag: SEM_COMPRESSAO\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_27\/o1_mf_nnndf_SEM_COMPRESSAO_j8hq3l7z_.bkp\n  List of Datafiles in backup set 202\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2330319    2021-04-27:06:41:59              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2330319    2021-04-27:06:41:59              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2330319    2021-04-27:06:41:59              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2330319    2021-04-27:06:41:59              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2330319    2021-04-27:06:41:59              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Deletando backupset:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; DELETE BACKUPSET TAG &#039;SEM_COMPRESSAO&#039;;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=1 device type=DISK\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n202     202     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_04_27\/o1_mf_nnndf_SEM_COMPRESSAO_j8hq3l7z_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_27\/o1_mf_nnndf_SEM_COMPRESSAO_j8hq3l7z_.bkp RECID=202 STAMP=1070952130\nDeleted 1 objects\n<\/pre><\/div>\n\n\n<p>Alterando valor do algoritmo de compress\u00e3o do RMAN para LOW:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; SET COMPRESSION ALGORITHM &#039;LOW&#039;;\n \nexecuting command: SET compression\n<\/pre><\/div>\n\n\n<p>Executando backup com esta nova op\u00e7\u00e3o:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP AS COMPRESSED BACKUPSET DATABASE TAG &#039;COMPRESSAO_LOW&#039;;\n \nStarting backup at 2021-04-28:04:09:20\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=66 device type=DISK\nchannel ORA_DISK_1: starting compressed full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-28:04:09:21\nchannel ORA_DISK_1: finished piece 1 at 2021-04-28:04:10:16\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_LOW_j8l2k27b_.bkp tag=COMPRESSAO_LOW comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:55\nFinished backup at 2021-04-28:04:10:16\n \nStarting Control File and SPFILE Autobackup at 2021-04-28:04:10:16\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_28\/o1_mf_s_1071029416_j8l2lsbn_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-28:04:10:19\n<\/pre><\/div>\n\n\n<p>Coletando dados:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUPSET TAG &#039;COMPRESSAO_LOW&#039;;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n206     Full    423.23M    DISK        00:00:43     2021-04-28:04:10:04\n        BP Key: 206   Status: AVAILABLE  Compressed: YES  Tag: COMPRESSAO_LOW\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_LOW_j8l2k27b_.bkp\n  List of Datafiles in backup set 206\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2363901    2021-04-28:04:09:21              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2363901    2021-04-28:04:09:21              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2363901    2021-04-28:04:09:21              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2363901    2021-04-28:04:09:21              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2363901    2021-04-28:04:09:21              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Deletando arquivos de backup:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; DELETE BACKUPSET TAG &#039;COMPRESSAO_LOW&#039;;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n206     206     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_LOW_j8l2k27b_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_LOW_j8l2k27b_.bkp RECID=206 STAMP=1071029362\nDeleted 1 objects\n<\/pre><\/div>\n\n\n<p>Alterando algoritmo para MEDIUM:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; SET COMPRESSION ALGORITHM &#039;MEDIUM&#039;;\n \nexecuting command: SET compression\n<\/pre><\/div>\n\n\n<p>Backup:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP AS COMPRESSED BACKUPSET DATABASE TAG &#039;COMPRESSAO_MEDIUM&#039;;\n \nStarting backup at 2021-04-28:04:26:18\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=75 device type=DISK\nchannel ORA_DISK_1: starting compressed full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-28:04:26:18\nchannel ORA_DISK_1: finished piece 1 at 2021-04-28:04:26:54\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_MEDIUM_j8l3jtz0_.bkp tag=COMPRESSAO_MEDIUM comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:36\nFinished backup at 2021-04-28:04:26:54\n \nStarting Control File and SPFILE Autobackup at 2021-04-28:04:26:54\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_28\/o1_mf_s_1071030414_j8l3kyw4_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-28:04:26:57\n<\/pre><\/div>\n\n\n<p>Coletando dados:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUPSET TAG &#039;COMPRESSAO_MEDIUM&#039;;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n212     Full    361.59M    DISK        00:00:30     2021-04-28:04:26:48\n        BP Key: 212   Status: AVAILABLE  Compressed: YES  Tag: COMPRESSAO_MEDIUM\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_MEDIUM_j8l3jtz0_.bkp\n  List of Datafiles in backup set 212\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2365541    2021-04-28:04:26:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2365541    2021-04-28:04:26:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2365541    2021-04-28:04:26:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2365541    2021-04-28:04:26:18              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2365541    2021-04-28:04:26:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Deletando backup:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; DELETE BACKUPSET TAG &#039;COMPRESSAO_MEDIUM&#039;;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n208     208     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_MEDIUM_j8l2tnw0_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_MEDIUM_j8l2tnw0_.bkp RECID=208 STAMP=1071029668\nDeleted 1 objects\n<\/pre><\/div>\n\n\n<p>Alterando configura\u00e7\u00e3o para HIGH:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; SET COMPRESSION ALGORITHM &#039;HIGH&#039;;\n \nexecuting command: SET compression\nusing target database control file instead of recovery catalog\n<\/pre><\/div>\n\n\n<p>Backup:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP AS COMPRESSED BACKUPSET DATABASE TAG &#039;COMPRESSAO_HIGH&#039;;\n \nStarting backup at 2021-04-28:04:18:03\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=119 device type=DISK\nchannel ORA_DISK_1: starting compressed full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-28:04:18:04\nchannel ORA_DISK_1: finished piece 1 at 2021-04-28:04:19:59\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_HIGH_j8l31d5s_.bkp tag=COMPRESSAO_HIGH comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:55\nFinished backup at 2021-04-28:04:19:59\n \nStarting Control File and SPFILE Autobackup at 2021-04-28:04:19:59\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_28\/o1_mf_s_1071029999_j8l34zsx_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-28:04:20:00\n<\/pre><\/div>\n\n\n<p>Coleta:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUPSET TAG &#039;COMPRESSAO_HIGH&#039;;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n210     Full    293.19M    DISK        00:01:53     2021-04-28:04:19:57\n        BP Key: 210   Status: AVAILABLE  Compressed: YES  Tag: COMPRESSAO_HIGH\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_HIGH_j8l31d5s_.bkp\n  List of Datafiles in backup set 210\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2364312    2021-04-28:04:18:04              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2364312    2021-04-28:04:18:04 2364479      NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2364312    2021-04-28:04:18:04              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2364312    2021-04-28:04:18:04              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2364312    2021-04-28:04:18:04              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Removendo arquivos:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; DELETE BACKUPSET TAG &#039;COMPRESSAO_HIGH&#039;;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n210     210     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_HIGH_j8l31d5s_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_28\/o1_mf_nnndf_COMPRESSAO_HIGH_j8l31d5s_.bkp RECID=210 STAMP=1071029884\nDeleted 1 objects\n<\/pre><\/div>\n\n\n<p>Tabela comparativa entre todas as op\u00e7\u00f5es usadas neste artigo. Obviamente ela n\u00e3o representa de forma est\u00e1tica os pontos positivos e negativos para todos os ambientes, ent\u00e3o a melhor op\u00e7\u00e3o \u00e9 testar em seu ambiente a execu\u00e7\u00e3o e realizar tamb\u00e9m a compara\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-table \\&quot;wp-block-table\"><table><tbody><tr><td><strong>Algoritmo<\/strong><\/td><td><strong>Tamanho do Backup<\/strong><\/td><td><strong>Tempo do Backup<\/strong><\/td><\/tr><tr><td>BASIC<\/td><td>1.22G<\/td><td>00:01:27<\/td><\/tr><tr><td>LOW<\/td><td>423.23M<\/td><td>00:00:43<\/td><\/tr><tr><td>MEDIUM<\/td><td>361.59M<\/td><td>00:00:30<\/td><\/tr><tr><td>HIGH<\/td><td>293.19M<\/td><td>00:01:53<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>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":"<p>Caso precisemos aplicar algum tipo de compress\u00e3o nos backups realizados no Oracle, nos \u00e9 dada a op\u00e7\u00e3o de utilizar os pr\u00f3prios algoritmos de compress\u00e3o bin\u00e1ria do RMAN. Este tipo de opera\u00e7\u00e3o reduz o tamanho dos backups, e por padr\u00e3o, opera com a configura\u00e7\u00e3o BASIC (que n\u00e3o exige nenhum licenciamento extra). Caso seja relevante utilizar os [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4126","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4126","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=4126"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4126\/revisions"}],"predecessor-version":[{"id":9157,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4126\/revisions\/9157"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}