{"id":3082,"date":"2021-03-24T08:13:13","date_gmt":"2021-03-24T08:13:13","guid":{"rendered":"https:\/\/swiv.com.br\/taking-incremental-database-backup\/"},"modified":"2026-05-27T20:02:49","modified_gmt":"2026-05-27T19:02:49","slug":"taking-incremental-database-backup","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/24\/taking-incremental-database-backup\/","title":{"rendered":"Taking Incremental Database Backup"},"content":{"rendered":"\n<p>Os backups incrementais nos d\u00e3o uma op\u00e7\u00e3o a mais para definirmos a nossa estrat\u00e9gia de backup. Em vez de realizarmos um backup FULL toda vez, podemos ter backups do tipo Diferencial e Cumulativos. Durante o artigo vou tentar mostrar a diferen\u00e7a deles. Mas o ponto de partida \u00e9 termos um backup do banco inteiro, o que \u00e9 feito no caso abaixo. Al\u00e9m disso, \u00e9 indicado o uso de TAGs nessas opera\u00e7\u00f5es para que o RMAN possa aplicar seu algoritmo de forma plena:<\/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 OPatch]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Wed Mar 24 04:47:05 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; BACKUP INCREMENTAL LEVEL 0 DATABASE TAG &#039;BSS&#039;;\n \nStarting backup at 2021-03-24:04:47:30\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=73 device type=DISK\nchannel ORA_DISK_1: starting incremental level 0 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-03-24:04:47:32\nchannel ORA_DISK_1: finished piece 1 at 2021-03-24:04:48:37\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd0_BSS_j5ovnncl_.bkp tag=BSS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:05\nFinished backup at 2021-03-24:04:48:37\n \nStarting Control File and SPFILE Autobackup at 2021-03-24:04:48:37\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068007717_j5ovpq5m_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-24:04:48:40\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Algumas observa\u00e7\u00f5es sobre o backup acima: apesar do mesmo ser level 0, ou seja, realizar a opera\u00e7\u00e3o do banco de dados inteiro, ele \u00e9 diferente do backup FULL tradicional. N\u00e3o \u00e9 poss\u00edvel realizar backups incrementais a partir de um backup FULL tradicional, mas sim do backup que fizemos acima. Outro ponto que \u00e9 importante notarmos \u00e9 o tempo decorrido (elapsed time: 00:01:05) e o tamanho dos arquivos listados abaixo (1.21G):<\/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 BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n102     Incr 0  1.21G      DISK        00:00:54     2021-03-24:04:48:26\n        BP Key: 102   Status: AVAILABLE  Compressed: NO  Tag: BSS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd0_BSS_j5ovnncl_.bkp\n  List of Datafiles in backup set 102\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1    0  Incr 2001021    2021-03-24:04:47:32              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3    0  Incr 2001021    2021-03-24:04:47:32              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4    0  Incr 2001021    2021-03-24:04:47:32              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5    0  Incr 2001021    2021-03-24:04:47:32              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7    0  Incr 2001021    2021-03-24:04:47:32              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Para simularmos a mudan\u00e7a de blocos de dados no banco de dados, vamos criar um procedure simples e execut\u00e1-la, para realizar algumas DMLs no schema HR:<\/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 OPatch]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Wed Mar 24 04:53:53 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL&gt; SET SERVEROUTPUT ON\nCREATE OR REPLACE PROCEDURE HR.TEST_UPDATE( N NUMBER )\nIS\n \/* This procedure performs sequential update on HR.EMPLOYEES table for testing\n    purposes. It doesn\u2019t make any real changes on data but real transactions\n    will be generated\n *\/\n T1 DATE;\n TYPE EMP_TABLE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;\n EMPS EMP_TABLE;\nBEGIN\n IF N IS NULL OR N &amp;lt; 1 THEN\n    DBMS_OUTPUT.PUT_LINE(&#039;INVALID VALUE OF PASSED PARAMETER.&#039;);\n    RETURN;\n END IF;\n SELECT SYSDATE INTO T1 FROM DUAL;\n SELECT EMPLOYEE_ID\n    BULK COLLECT\n    INTO EMPS\n    FROM HR.EMPLOYEES\n    ORDER BY 1;\n \n FOR I IN 1..N LOOP\n    FOR J IN 1..EMPS.COUNT LOOP\n     UPDATE HR.EMPLOYEES SET SALARY = SALARY * 1 WHERE EMPLOYEE_ID=EMPS(J) ;\n     COMMIT;\n    END LOOP;\n  END LOOP;\n DBMS_OUTPUT.PUT_LINE(TO_CHAR( (SYSDATE-T1)*24*60*60 , &#039;999,999.99&#039;) || &#039; s&#039;);\nEND TEST_UPDATE;\n\/SQL&gt;   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30\n \nProcedure created.\n \nSQL&gt; set serveroutput on\nSQL&gt; exec HR.TEST_UPDATE(1000);\n13.00 s\n \nPL\/SQL procedure successfully completed.\n<\/pre><\/div>\n\n\n<p>Agora podemos realizar o backup incremental DIFERENCIAL. Notem que por ser o tipo default no rman, omitimos essa op\u00e7\u00e3o no script. E para observa\u00e7\u00e3o tamb\u00e9m, os backups incrementais s\u00e3o de n\u00edvel 1:<\/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 INCREMENTAL LEVEL 1 DATABASE TAG &#039;BSS&#039;;\n \nStarting backup at 2021-03-24:04:56:53\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=78 device type=DISK\nchannel ORA_DISK_1: starting incremental level 1 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-03-24:04:56:54\nchannel ORA_DISK_1: finished piece 1 at 2021-03-24:04:56:57\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ow681r_.bkp tag=BSS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 2021-03-24:04:56:57\n \nStarting Control File and SPFILE Autobackup at 2021-03-24:04:56:57\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008218_j5ow6bsh_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-24:04:57:01\n<\/pre><\/div>\n\n\n<p>Ap\u00f3s realizar a consulta deste backup, \u00e9 poss\u00edvel notar que seu tempo de execu\u00e7\u00e3o foi de 3 segundos, com tamanho de 16.59M:<\/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 BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n...\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n104     Incr 1  16.59M     DISK        00:00:03     2021-03-24:04:56:57\n        BP Key: 104   Status: AVAILABLE  Compressed: NO  Tag: BSS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ow681r_.bkp\n  List of Datafiles in backup set 104\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1    1  Incr 2216672    2021-03-24:04:56:54              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3    1  Incr 2216672    2021-03-24:04:56:54              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4    1  Incr 2216672    2021-03-24:04:56:54              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5    1  Incr 2216672    2021-03-24:04:56:54              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7    1  Incr 2216672    2021-03-24:04:56:54              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Realizando novamente um backup diferencial:<\/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 INCREMENTAL LEVEL 1 DATABASE TAG &#039;BSS&#039;;\n \nStarting backup at 2021-03-24:05:04:27\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting incremental level 1 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-03-24:05:04:28\nchannel ORA_DISK_1: finished piece 1 at 2021-03-24:05:04:31\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ownd3g_.bkp tag=BSS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 2021-03-24:05:04:31\n \nStarting Control File and SPFILE Autobackup at 2021-03-24:05:04:31\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008671_j5ownhqy_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-24:05:04:34\n<\/pre><\/div>\n\n\n<p>Listando o backup, vemos que o tempo foi o mesmo (3 segundos) mas o backup piece foi muito menor (288K):<\/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 BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n...\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n106     Incr 1  288.00K    DISK        00:00:01     2021-03-24:05:04:28\n        BP Key: 106   Status: AVAILABLE  Compressed: NO  Tag: BSS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ownd3g_.bkp\n  List of Datafiles in backup set 106\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1    1  Incr 2216915    2021-03-24:05:04:28              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3    1  Incr 2216915    2021-03-24:05:04:28              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4    1  Incr 2216915    2021-03-24:05:04:28              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5    1  Incr 2216915    2021-03-24:05:04:28              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7    1  Incr 2216915    2021-03-24:05:04:28              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Agora vamos realizar um backup incremental cumulativo. Este tipo de backup contempla todos os blocos alterados a partir do \u00faltimo backup level 0:<\/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 INCREMENTAL LEVEL 1 CUMULATIVE DATABASE TAG &#039;BSS&#039;;\n \nStarting backup at 2021-03-24:05:09:14\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting incremental level 1 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-03-24:05:09:15\nchannel ORA_DISK_1: finished piece 1 at 2021-03-24:05:09:18\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5owxcp5_.bkp tag=BSS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 2021-03-24:05:09:18\n \nStarting Control File and SPFILE Autobackup at 2021-03-24:05:09:18\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008958_j5owxh8s_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-24:05:09:19\n<\/pre><\/div>\n\n\n<p>Ao listar as informa\u00e7\u00f5es, vemos que o seu tamanho foi de 16.74M:<\/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 BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n...\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n108     Incr 1  16.74M     DISK        00:00:01     2021-03-24:05:09:16\n        BP Key: 108   Status: AVAILABLE  Compressed: NO  Tag: BSS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5owxcp5_.bkp\n  List of Datafiles in backup set 108\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1    1  Incr 2217335    2021-03-24:05:09:15              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3    1  Incr 2217335    2021-03-24:05:09:15              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4    1  Incr 2217335    2021-03-24:05:09:15              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5    1  Incr 2217335    2021-03-24:05:09:15              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7    1  Incr 2217335    2021-03-24:05:09:15              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Limpando todos os backupsets do artigo:<\/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;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n102     102     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd0_BSS_j5ovnncl_.bkp\n103     103     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068007717_j5ovpq5m_.bkp\n104     104     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ow681r_.bkp\n105     105     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008218_j5ow6bsh_.bkp\n106     106     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ownd3g_.bkp\n107     107     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008671_j5ownhqy_.bkp\n108     108     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5owxcp5_.bkp\n109     109     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008958_j5owxh8s_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd0_BSS_j5ovnncl_.bkp RECID=102 STAMP=1068007652\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068007717_j5ovpq5m_.bkp RECID=103 STAMP=1068007719\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ow681r_.bkp RECID=104 STAMP=1068008216\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008218_j5ow6bsh_.bkp RECID=105 STAMP=1068008218\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5ownd3g_.bkp RECID=106 STAMP=1068008668\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008671_j5ownhqy_.bkp RECID=107 STAMP=1068008671\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_24\/o1_mf_nnnd1_BSS_j5owxcp5_.bkp RECID=108 STAMP=1068008955\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_24\/o1_mf_s_1068008958_j5owxh8s_.bkp RECID=109 STAMP=1068008959\nDeleted 8 objects\n<\/pre><\/div>\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>Os backups incrementais nos d\u00e3o uma op\u00e7\u00e3o a mais para definirmos a nossa estrat\u00e9gia de backup. Em vez de realizarmos um backup FULL toda vez, podemos ter backups do tipo Diferencial e Cumulativos. Durante o artigo vou tentar mostrar a diferen\u00e7a deles. Mas o ponto de partida \u00e9 termos um backup do banco inteiro, o [&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-3082","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\/3082","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=3082"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3082\/revisions"}],"predecessor-version":[{"id":9206,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3082\/revisions\/9206"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}