{"id":3138,"date":"2021-03-25T07:46:04","date_gmt":"2021-03-25T07:46:04","guid":{"rendered":"https:\/\/swiv.com.br\/creating-database-incrementally-updated-backup\/"},"modified":"2026-05-27T20:02:49","modified_gmt":"2026-05-27T19:02:49","slug":"creating-database-incrementally-updated-backup","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/25\/creating-database-incrementally-updated-backup\/","title":{"rendered":"Creating Database Incrementally Updated Backup"},"content":{"rendered":"

Nos backups do tipo “AS COPY”, temos um recurso muito interessante que pode nos ajudar a diminuir o tempo de recupera\u00e7\u00e3o de um ambiente. Este mecanismo consiste em ter um backup level 0 do banco de dados, e os posteriores backups level 1 sendo \\”aplicados\\” dos datafiles gerados no backup level 0. E nos bastidores, o que ocorre n\u00e3o \u00e9 um recover dos datafiles, mas sim uma altera\u00e7\u00e3o a n\u00edvel de bloco de dados, o que \u00e9 muito mais r\u00e1pido caso fa\u00e7amos uma compara\u00e7\u00e3o. Uma breve descri\u00e7\u00e3o desse item est\u00e1 documentada AQUI<\/a>. Neste artigo, vou tentar simular esta funcionalidade.<\/p>\n\n\n

Executando o comando abaixo, como ainda n\u00e3o temos nenhum banco level 0, o RMAN ignorar\u00e1 a primeira linha, que \u00e9 referente \u00e0 altera\u00e7\u00e3o dos copy datafiles (no copy of datafile 1 found to recover). Depois disso, como um backup level 0 ainda n\u00e3o existe, o mesmo ser\u00e1 disparado (no parent backup or copy of datafile 1 found):<\/p>\n\n\n

\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Thu Mar 25 04:21:02 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> Run\n{\n        RECOVER COPY OF DATABASE WITH TAG 'BSS';\n        BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'BSS' DATABASE;\n}2> 3> 4> 5>\n \nStarting recover at 2021-03-25:04:21:12\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=68 device type=DISK\nno copy of datafile 1 found to recover\nno copy of datafile 3 found to recover\nno copy of datafile 4 found to recover\nno copy of datafile 5 found to recover\nno copy of datafile 7 found to recover\nFinished recover at 2021-03-25:04:21:12\n \nStarting backup at 2021-03-25:04:21:12\nusing channel ORA_DISK_1\nno parent backup or copy of datafile 1 found\nno parent backup or copy of datafile 3 found\nno parent backup or copy of datafile 4 found\nno parent backup or copy of datafile 5 found\nno parent backup or copy of datafile 7 found\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j5rgh980_.dbf tag=BSS RECID=22 STAMP=1068092488\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j5rgj29n_.dbf tag=BSS RECID=23 STAMP=1068092505\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j5rgjkfy_.dbf tag=BSS RECID=24 STAMP=1068092516\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j5rgjo05_.dbf tag=BSS RECID=25 STAMP=1068092518\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j5rgjqqp_.dbf tag=BSS RECID=26 STAMP=1068092519\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nFinished backup at 2021-03-25:04:22:00\n \nStarting Control File and SPFILE Autobackup at 2021-03-25:04:22:00\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068092520_j5rgjsc1_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-25:04:22:01\n<\/pre><\/div>\n\n\n
Listando as informa\u00e7\u00f5es m\u00ednimas do ambiente:<\/p>\n\n\n
\nRMAN> LIST COPY OF DATABASE;\n \nList of Datafile Copies\n=======================\n \nKey     File S Completion Time     Ckp SCN    Ckp Time            Sparse\n------- ---- - ------------------- ---------- ------------------- ------\n22      1    A 2021-03-25:04:21:28 2226174    2021-03-25:04:21:13 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j5rgh980_.dbf\n        Tag: BSS\n \n23      3    A 2021-03-25:04:21:45 2226185    2021-03-25:04:21:38 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j5rgj29n_.dbf\n        Tag: BSS\n \n24      4    A 2021-03-25:04:21:56 2226193    2021-03-25:04:21:53 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j5rgjkfy_.dbf\n        Tag: BSS\n \n25      5    A 2021-03-25:04:21:58 2226197    2021-03-25:04:21:56 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j5rgjo05_.dbf\n        Tag: BSS\n \n26      7    A 2021-03-25:04:21:59 2226201    2021-03-25:04:21:59 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j5rgjqqp_.dbf\n        Tag: BSS\n<\/pre><\/div>\n\n\n
Como as informa\u00e7\u00f5es acima s\u00e3o limitadas, podemos extrair um pouco mais de informa\u00e7\u00f5es utilizando o comando abaixo, principalmente no que se referel ao level de backup que foi utilizado (0):<\/p>\n\n\n
\nRMAN> SELECT FILE#, STATUS, CREATION_TIME, COMPLETION_TIME, TAG, BLOCKS*BLOCK_SIZE\/1024\/1024 SIZE_MB, INCREMENTAL_LEVEL FROM V$DATAFILE_COPY WHERE DELETED ='NO' ORDER BY FILE#, RECID;\n \n     FILE# S CREATION_TIME       COMPLETION_TIME\n---------- - ------------------- -------------------\nTAG                                 SIZE_MB INCREMENTAL_LEVEL\n-------------------------------- ---------- -----------------\n         1 A 2018-02-07:19:20:19 2021-03-25:04:21:28\nBSS                                     860                 0\n \n         3 A 2018-02-07:19:20:39 2021-03-25:04:21:45\nBSS                                     630                 0\n \n         4 A 2018-02-07:21:43:00 2021-03-25:04:21:56\nBSS                                     305                 0\n \n         5 A 2020-05-02:22:06:13 2021-03-25:04:21:58\nBSS                                     200                 0\n \n         7 A 2018-02-07:19:22:01 2021-03-25:04:21:59\nBSS                                       5                 0\n<\/pre><\/div>\n\n\n
Gerando alguns archives:<\/p>\n\n\n
\nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n<\/pre><\/div>\n\n\n
Executando novamente o bloco RMAN. Observem que a primeira linha novamente foi ignorada, pois ainda n\u00e3o havia backups level 1 para serem aplicados nos backups level 0. Desse modo, foi realizado um backup level 1 conforme abaixo:<\/p>\n\n\n
\nRMAN> Run\n{\n        RECOVER COPY OF DATABASE WITH TAG 'BSS';\n        BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'BSS' DATABASE;\n}2> 3> 4> 5>\n \nStarting recover at 2021-03-25:04:31:56\nusing channel ORA_DISK_1\nno copy of datafile 1 found to recover\nno copy of datafile 3 found to recover\nno copy of datafile 4 found to recover\nno copy of datafile 5 found to recover\nno copy of datafile 7 found to recover\nFinished recover at 2021-03-25:04:31:56\n \nStarting backup at 2021-03-25:04:31:56\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-25:04:31:57\nchannel ORA_DISK_1: finished piece 1 at 2021-03-25:04:31:58\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rh3fht_.bkp tag=BSS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-25:04:31:58\n \nStarting Control File and SPFILE Autobackup at 2021-03-25:04:31:58\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068093118_j5rh3gwl_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-25:04:31:59\n<\/pre><\/div>\n\n\n
Podemos ver o backupset gerado por conta do backup level 1 disparado:<\/p>\n\n\n
\nRMAN> LIST BACKUPSET OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n120     Incr 1  544.00K    DISK        00:00:00     2021-03-25:04:31:57\n        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: BSS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rh3fht_.bkp\n  List of Datafiles in backup set 120\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1    1  Incr 2226592    2021-03-25:04:31:57              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3    1  Incr 2226592    2021-03-25:04:31:57              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4    1  Incr 2226592    2021-03-25:04:31:57              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5    1  Incr 2226592    2021-03-25:04:31:57              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7    1  Incr 2226592    2021-03-25:04:31:57              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n
Gerando mais archives:<\/p>\n\n\n
\nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n<\/pre><\/div>\n\n\n
Executando o bloco RMAN pela terceira vez. Agora podemos ver que a primeira linha realizou a aplica\u00e7\u00e3o do level 1 nos datafiles copy level 0:<\/p>\n\n\n
\nRMAN> Run\n{\n        RECOVER COPY OF DATABASE WITH TAG 'BSS';\n        BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'BSS' DATABASE;\n}2> 3> 4> 5>\n \nStarting recover at 2021-03-25:04:36:27\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting incremental datafile backup set restore\nchannel ORA_DISK_1: specifying datafile copies to recover\nrecovering datafile copy file number=00001 name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j5rgh980_.dbf\nrecovering datafile copy file number=00003 name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j5rgj29n_.dbf\nrecovering datafile copy file number=00004 name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j5rgjkfy_.dbf\nrecovering datafile copy file number=00005 name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j5rgjo05_.dbf\nrecovering datafile copy file number=00007 name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j5rgjqqp_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rh3fht_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rh3fht_.bkp tag=BSS\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\nFinished recover at 2021-03-25:04:36:29\n \nStarting backup at 2021-03-25:04:36:29\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-25:04:36:29\nchannel ORA_DISK_1: finished piece 1 at 2021-03-25:04:36:30\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rhcy26_.bkp tag=BSS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-25:04:36:30\n \nStarting Control File and SPFILE Autobackup at 2021-03-25:04:36:30\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068093390_j5rhcz1j_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-25:04:36:31\n<\/pre><\/div>\n\n\n
Tamb\u00e9m \u00e9 poss\u00edvel constatar isso observando que o Checkpoint SCN dos datafiles copy foram incrementados, se comparados com as informa\u00e7\u00f5es que coletamos no in\u00edcio do artigo ap\u00f3s o primeiro backup:<\/p>\n\n\n
\nRMAN> LIST COPY OF DATABASE;\n \nList of Datafile Copies\n=======================\n \nKey     File S Completion Time     Ckp SCN    Ckp Time            Sparse\n------- ---- - ------------------- ---------- ------------------- ------\n27      1    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j5rgh980_.dbf\n        Tag: BSS\n \n31      3    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j5rgj29n_.dbf\n        Tag: BSS\n \n30      4    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j5rgjkfy_.dbf\n        Tag: BSS\n \n28      5    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j5rgjo05_.dbf\n        Tag: BSS\n \n29      7    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j5rgjqqp_.dbf\n        Tag: BSS\n<\/pre><\/div>\n\n\n
Limpando todos os arquivos e backup gerados no artigo:<\/p>\n\n\n
\nRMAN> DELETE COPY OF DATABASE;\n \nreleased channel: ORA_DISK_1\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=68 device type=DISK\nList of Datafile Copies\n=======================\n \nKey     File S Completion Time     Ckp SCN    Ckp Time            Sparse\n------- ---- - ------------------- ---------- ------------------- ------\n27      1    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j5rgh980_.dbf\n        Tag: BSS\n \n31      3    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j5rgj29n_.dbf\n        Tag: BSS\n \n30      4    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j5rgjkfy_.dbf\n        Tag: BSS\n \n28      5    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j5rgjo05_.dbf\n        Tag: BSS\n \n29      7    A 2021-03-25:04:36:28 2226592    2021-03-25:04:31:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j5rgjqqp_.dbf\n        Tag: BSS\n \n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted datafile copy\ndatafile copy file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j5rgh980_.dbf RECID=27 STAMP=1068093388\ndeleted datafile copy\ndatafile copy file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j5rgj29n_.dbf RECID=31 STAMP=1068093388\ndeleted datafile copy\ndatafile copy file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j5rgjkfy_.dbf RECID=30 STAMP=1068093388\ndeleted datafile copy\ndatafile copy file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j5rgjo05_.dbf RECID=28 STAMP=1068093388\ndeleted datafile copy\ndatafile copy file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j5rgjqqp_.dbf RECID=29 STAMP=1068093388\nDeleted 5 objects\n \n \nRMAN> 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------- ------- --- --- ----------- ----------- ----------\n119     119     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068092520_j5rgjsc1_.bkp\n120     120     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rh3fht_.bkp\n121     121     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068093118_j5rh3gwl_.bkp\n122     122     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rhcy26_.bkp\n123     123     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068093390_j5rhcz1j_.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\/autobackup\/2021_03_25\/o1_mf_s_1068092520_j5rgjsc1_.bkp RECID=119 STAMP=1068092521\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rh3fht_.bkp RECID=120 STAMP=1068093117\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068093118_j5rh3gwl_.bkp RECID=121 STAMP=1068093118\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_25\/o1_mf_nnnd1_BSS_j5rhcy26_.bkp RECID=122 STAMP=1068093390\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_25\/o1_mf_s_1068093390_j5rhcz1j_.bkp RECID=123 STAMP=1068093391\nDeleted 5 objects\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":"
Nos backups do tipo “AS COPY”, temos um recurso muito interessante que pode nos ajudar a diminuir o tempo de recupera\u00e7\u00e3o de um ambiente. Este mecanismo consiste em ter um backup level 0 do banco de dados, e os posteriores backups level 1 sendo \\”aplicados\\” dos datafiles gerados no backup level 0. E nos bastidores, […]<\/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-3138","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\/3138","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=3138"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3138\/revisions"}],"predecessor-version":[{"id":9204,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3138\/revisions\/9204"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}