{"id":4321,"date":"2021-05-04T07:57:33","date_gmt":"2021-05-04T07:57:33","guid":{"rendered":"https:\/\/swiv.com.br\/backing-up-recovery-files\/"},"modified":"2026-05-27T20:02:32","modified_gmt":"2026-05-27T19:02:32","slug":"backing-up-recovery-files","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/05\/04\/backing-up-recovery-files\/","title":{"rendered":"Backing Up Recovery Files"},"content":{"rendered":"\n

Em um cen\u00e1rio onde n\u00e3o seja adequado executar nossos backups diretamente em fita, temos a op\u00e7\u00e3o dentro do RMAN de realizar o backup da FRA ou dos recovery files que est\u00e3o fora dela para outro diret\u00f3rio ou at\u00e9 mesmo em fita. Isso traz mais flexibilidade ao DBA, uma vez que algumas empresas j\u00e1 possuem um processo consagrado em rela\u00e7\u00e3o as fitas, por exemplo delas serem levadas diariamente para fora do datacenter da origem, diminuindo assim a reten\u00e7\u00e3o de arquivos para eventual recupera\u00e7\u00e3o. Dependendo do evento, esperar que essas fitas sejam trazidas novamente para o seu datacenter pode custar caro para a empresa, caso um banco importante esteja precisando disso. Neste artigo mostraremos o exemplo da utiliza\u00e7\u00e3o desse recurso.<\/p>\n\n\n\n

Realizando um backup do banco que ser\u00e1 destinado \u00e0 FRA:<\/p>\n\n\n

\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 4 04:34:10 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> BACKUP DATABASE;\n \nStarting backup at 2021-05-04:04:34:17\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=1 device type=DISK\nchannel ORA_DISK_1: starting 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-05-04:04:34:18\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:36:13\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnndf_TAG20210504T043418_j91y7wvo_.bkp tag=TAG20210504T043418 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:55\nFinished backup at 2021-05-04:04:36:13\n \nStarting Control File and SPFILE Autobackup at 2021-05-04:04:36:13\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071635773_j91ycg6j_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-04:04:36:16\n \nRMAN> 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------- ---- -- ---------- ----------- ------------ -------------------\n313     Full    1.29G      DISK        00:01:26     2021-05-04:04:35:44\n        BP Key: 334   Status: AVAILABLE  Compressed: NO  Tag: TAG20210504T043418\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnndf_TAG20210504T043418_j91y7wvo_.bkp\n  List of Datafiles in backup set 313\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2688140    2021-05-04:04:34:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2688140    2021-05-04:04:34:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2688140    2021-05-04:04:34:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2688140    2021-05-04:04:34:18              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2688140    2021-05-04:04:34:18              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n
Confirmando que o destino dos backups \u00e9 a FRA configurada no banco de dados:<\/p>\n\n\n
\n[oracle@oel8 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Tue May 4 04:37:36 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> select instance_name,status from v$instance;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\nRMANDB           OPEN\n \nSQL> SHOW PARAMETER RECOVERY;\n \nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest                string      \/oracle\/fra\ndb_recovery_file_dest_size           big integer 5G\nrecovery_parallelism                 integer     0\nremote_recovery_file_dest            string\n<\/pre><\/div>\n\n\n
Agora vamos realizar o backup dos archivelogs em um diret\u00f3rio fora da FRA:<\/p>\n\n\n
\nRMAN> BACKUP ARCHIVELOG ALL FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U';\n \nStarting backup at 2021-05-04:04:41:23\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=75 device type=DISK\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=68 RECID=75 STAMP=1069389781\ninput archived log thread=1 sequence=69 RECID=77 STAMP=1069390191\ninput archived log thread=1 sequence=70 RECID=78 STAMP=1069391841\ninput archived log thread=1 sequence=71 RECID=79 STAMP=1069392032\ninput archived log thread=1 sequence=72 RECID=80 STAMP=1069392053\ninput archived log thread=1 sequence=73 RECID=83 STAMP=1069392224\ninput archived log thread=1 sequence=74 RECID=84 STAMP=1069392226\ninput archived log thread=1 sequence=75 RECID=85 STAMP=1069430460\ninput archived log thread=1 sequence=76 RECID=86 STAMP=1069567218\ninput archived log thread=1 sequence=77 RECID=87 STAMP=1069581356\ninput archived log thread=1 sequence=78 RECID=88 STAMP=1070953640\ninput archived log thread=1 sequence=79 RECID=89 STAMP=1070992854\ninput archived log thread=1 sequence=80 RECID=90 STAMP=1071054025\ninput archived log thread=1 sequence=81 RECID=91 STAMP=1071075652\ninput archived log thread=1 sequence=82 RECID=92 STAMP=1071117108\ninput archived log thread=1 sequence=83 RECID=93 STAMP=1071140420\ninput archived log thread=1 sequence=84 RECID=94 STAMP=1071180017\ninput archived log thread=1 sequence=85 RECID=95 STAMP=1071190844\ninput archived log thread=1 sequence=86 RECID=96 STAMP=1071205211\ninput archived log thread=1 sequence=87 RECID=97 STAMP=1071205218\ninput archived log thread=1 sequence=88 RECID=98 STAMP=1071219611\ninput archived log thread=1 sequence=89 RECID=99 STAMP=1071376111\ninput archived log thread=1 sequence=90 RECID=100 STAMP=1071381640\ninput archived log thread=1 sequence=91 RECID=101 STAMP=1071396592\ninput archived log thread=1 sequence=92 RECID=102 STAMP=1071411059\ninput archived log thread=1 sequence=93 RECID=103 STAMP=1071552261\ninput archived log thread=1 sequence=94 RECID=104 STAMP=1071553535\ninput archived log thread=1 sequence=95 RECID=105 STAMP=1071553599\ninput archived log thread=1 sequence=96 RECID=106 STAMP=1071553824\ninput archived log thread=1 sequence=97 RECID=107 STAMP=1071554229\ninput archived log thread=1 sequence=98 RECID=108 STAMP=1071590436\ninput archived log thread=1 sequence=99 RECID=109 STAMP=1071636084\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:41:25\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:42:30\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/cavtvnjl_1_1 tag=TAG20210504T044124 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:05\nFinished backup at 2021-05-04:04:42:30\n \nStarting Control File and SPFILE Autobackup at 2021-05-04:04:42:30\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071636150_j91yq83r_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-04:04:42:33\n \nRMAN> LIST BACKUP OF ARCHIVELOG ALL;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ -------------------\n315     840.77M    DISK        00:00:16     2021-05-04:04:41:41\n        BP Key: 336   Status: AVAILABLE  Compressed: NO  Tag: TAG20210504T044124\n        Piece Name: \/oracle\/dados\/RMANDB\/BACKUP1\/cavtvnjl_1_1\n \n  List of Archived Logs in backup set 315\n  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time\n  ---- ------- ---------- ------------------- ---------- ---------\n  1    68      2255756    2021-03-28:10:39:58 2262113    2021-04-09:04:43:00\n  1    69      2262113    2021-04-09:04:43:00 2262505    2021-04-09:04:49:50\n  1    70      2262505    2021-04-09:04:49:50 2265296    2021-04-09:05:17:21\n  1    71      2265296    2021-04-09:05:17:21 2265473    2021-04-09:05:20:32\n  1    72      2265473    2021-04-09:05:20:32 2265531    2021-04-09:05:20:53\n  1    73      2265531    2021-04-09:05:20:53 2265643    2021-04-09:05:23:29\n  1    74      2265643    2021-04-09:05:23:29 2265663    2021-04-09:05:23:44\n  1    75      2265663    2021-04-09:05:23:44 2290054    2021-04-09:16:01:00\n  1    76      2290054    2021-04-09:16:01:00 2314554    2021-04-11:06:00:15\n  1    77      2314554    2021-04-11:06:00:15 2328698    2021-04-11:09:55:53\n  1    78      2328698    2021-04-11:09:55:53 2332924    2021-04-27:07:07:17\n  1    79      2332924    2021-04-27:07:07:17 2358174    2021-04-27:18:00:52\n  1    80      2358174    2021-04-27:18:00:52 2381091    2021-04-28:11:00:22\n  1    81      2381091    2021-04-28:11:00:22 2394102    2021-04-28:17:00:49\n  1    82      2394102    2021-04-28:17:00:49 2500292    2021-04-29:04:31:47\n  1    83      2500292    2021-04-29:04:31:47 2519661    2021-04-29:11:00:18\n  1    84      2519661    2021-04-29:11:00:18 2546021    2021-04-29:22:00:14\n  1    85      2546021    2021-04-29:22:00:14 2559326    2021-04-30:01:00:41\n  1    86      2559326    2021-04-30:01:00:41 2570072    2021-04-30:05:00:08\n  1    87      2570072    2021-04-30:05:00:08 2570544    2021-04-30:05:00:15\n  1    88      2570544    2021-04-30:05:00:15 2580734    2021-04-30:09:00:09\n  1    89      2580734    2021-04-30:09:00:09 2607950    2021-05-01:04:28:27\n  1    90      2607950    2021-05-01:04:28:27 2620519    2021-05-01:06:00:37\n  1    91      2620519    2021-05-01:06:00:37 2634806    2021-05-01:10:09:50\n  1    92      2634806    2021-05-01:10:09:50 2648651    2021-05-01:14:10:57\n  1    93      2648651    2021-05-01:14:10:57 2655511    2021-05-03:05:24:19\n  1    94      2655511    2021-05-03:05:24:19 2656517    2021-05-03:05:45:34\n  1    95      2656517    2021-05-03:05:45:34 2656617    2021-05-03:05:46:39\n  1    96      2656617    2021-05-03:05:46:39 2656827    2021-05-03:05:50:24\n  1    97      2656827    2021-05-03:05:50:24 2657118    2021-05-03:05:57:09\n  1    98      2657118    2021-05-03:05:57:09 2679421    2021-05-03:16:00:34\n  1    99      2679421    2021-05-03:16:00:34 2688357    2021-05-04:04:41:23\n<\/pre><\/div>\n\n\n
Simulando o backup da FRA para um diret\u00f3rio diferente. Neste caso, apenas o backup do banco de dados \u00e9 contemplado:<\/p>\n\n\n
\nRMAN> BACKUP RECOVERY AREA TO DESTINATION '\/oracle\/dados\/RMANDB\/BACKUP2';\n \nStarting backup at 2021-05-04:04:45:44\nusing channel ORA_DISK_1\nspecification does not match any datafile copy in the repository\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=69 RECID=77 STAMP=1069390191\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:45:44\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:45:45\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_annnn_TAG20210504T044544_j91yx8h9_.bkp tag=TAG20210504T044544 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: input backup set: count=392, stamp=1071635658, piece=1\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:45:45\nchannel ORA_DISK_1: backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnndf_TAG20210504T043418_j91y7wvo_.bkp\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnnnf__j91yx9kj_.bkp comment=NONE\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:47:20\nchannel ORA_DISK_1: backup piece complete, elapsed time: 00:01:35\nchannel ORA_DISK_1: input backup set: count=393, stamp=1071635773, piece=1\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:47:20\nchannel ORA_DISK_1: backup piece \/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071635773_j91ycg6j_.bkp\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnnnf__j91z08nb_.bkp comment=NONE\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:47:21\nchannel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: input backup set: count=395, stamp=1071636150, piece=1\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:47:21\nchannel ORA_DISK_1: backup piece \/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071636150_j91yq83r_.bkp\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnnnf__j91z09ol_.bkp comment=NONE\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:47:22\nchannel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01\nFinished backup at 2021-05-04:04:47:22\n \nStarting Control File and SPFILE Autobackup at 2021-05-04:04:47:22\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071636442_j91z0ckc_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-04:04:47:25\n<\/pre><\/div>\n\n\n
Tamb\u00e9m podemos realizar o backup dos arquivos que est\u00e3o fora da FRA, que no nosso caso foram os archivelog, vide exemplo abaixo:<\/p>\n\n\n
\n[oracle@oel8 2021_05_04]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 4 04:52:07 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> BACKUP RECOVERY FILES TO DESTINATION '\/oracle\/dados\/RMANDB\/BACKUP2';\n \nStarting backup at 2021-05-04:04:52:12\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=97 device type=DISK\nspecification does not match any datafile copy in the repository\nskipping archived log of thread 1 with sequence 69; already backed up\nskipping archived log of thread 1 with sequence 69; already backed up\nskipping backup set key 313; already backed up 1 time(s)\nskipping backup set key 314; already backed up 1 time(s)\nskipping backup set key 316; already backed up 1 time(s)\nskipping backup set key 317; already backed up 1 time(s)\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=68 RECID=75 STAMP=1069389781\ninput archived log thread=1 sequence=70 RECID=78 STAMP=1069391841\ninput archived log thread=1 sequence=71 RECID=79 STAMP=1069392032\ninput archived log thread=1 sequence=72 RECID=80 STAMP=1069392053\ninput archived log thread=1 sequence=73 RECID=83 STAMP=1069392224\ninput archived log thread=1 sequence=74 RECID=84 STAMP=1069392226\ninput archived log thread=1 sequence=75 RECID=85 STAMP=1069430460\ninput archived log thread=1 sequence=76 RECID=86 STAMP=1069567218\ninput archived log thread=1 sequence=77 RECID=87 STAMP=1069581356\ninput archived log thread=1 sequence=78 RECID=88 STAMP=1070953640\ninput archived log thread=1 sequence=79 RECID=89 STAMP=1070992854\ninput archived log thread=1 sequence=80 RECID=90 STAMP=1071054025\ninput archived log thread=1 sequence=81 RECID=91 STAMP=1071075652\ninput archived log thread=1 sequence=82 RECID=92 STAMP=1071117108\ninput archived log thread=1 sequence=83 RECID=93 STAMP=1071140420\ninput archived log thread=1 sequence=84 RECID=94 STAMP=1071180017\ninput archived log thread=1 sequence=85 RECID=95 STAMP=1071190844\ninput archived log thread=1 sequence=86 RECID=96 STAMP=1071205211\ninput archived log thread=1 sequence=87 RECID=97 STAMP=1071205218\ninput archived log thread=1 sequence=88 RECID=98 STAMP=1071219611\ninput archived log thread=1 sequence=89 RECID=99 STAMP=1071376111\ninput archived log thread=1 sequence=90 RECID=100 STAMP=1071381640\ninput archived log thread=1 sequence=91 RECID=101 STAMP=1071396592\ninput archived log thread=1 sequence=92 RECID=102 STAMP=1071411059\ninput archived log thread=1 sequence=93 RECID=103 STAMP=1071552261\ninput archived log thread=1 sequence=94 RECID=104 STAMP=1071553535\ninput archived log thread=1 sequence=95 RECID=105 STAMP=1071553599\ninput archived log thread=1 sequence=96 RECID=106 STAMP=1071553824\ninput archived log thread=1 sequence=97 RECID=107 STAMP=1071554229\ninput archived log thread=1 sequence=98 RECID=108 STAMP=1071590436\ninput archived log thread=1 sequence=99 RECID=109 STAMP=1071636084\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:52:12\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:52:57\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_annnn_TAG20210504T045212_j91z9dxz_.bkp tag=TAG20210504T045212 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:45\nchannel ORA_DISK_1: input backup set: count=394, stamp=1071636085, piece=1\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:52:57\nchannel ORA_DISK_1: backup piece \/oracle\/dados\/RMANDB\/BACKUP1\/cavtvnjl_1_1\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnnnf__j91zbt25_.bkp comment=NONE\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:53:43\nchannel ORA_DISK_1: backup piece complete, elapsed time: 00:00:46\nchannel ORA_DISK_1: input backup set: count=404, stamp=1071636442, piece=1\nchannel ORA_DISK_1: starting piece 1 at 2021-05-04:04:53:43\nchannel ORA_DISK_1: backup piece \/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071636442_j91z0ckc_.bkp\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/RMANDB\/backupset\/2021_05_04\/o1_mf_nnnnf__j91zd775_.bkp comment=NONE\nchannel ORA_DISK_1: finished piece 1 at 2021-05-04:04:53:44\nchannel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01\nFinished backup at 2021-05-04:04:53:44\n \nStarting Control File and SPFILE Autobackup at 2021-05-04:04:53:44\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_04\/o1_mf_s_1071636824_j91zd933_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-04:04:53:47\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":"
Em um cen\u00e1rio onde n\u00e3o seja adequado executar nossos backups diretamente em fita, temos a op\u00e7\u00e3o dentro do RMAN de realizar o backup da FRA ou dos recovery files que est\u00e3o fora dela para outro diret\u00f3rio ou at\u00e9 mesmo em fita. Isso traz mais flexibilidade ao DBA, uma vez que algumas empresas j\u00e1 possuem um […]<\/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-4321","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\/4321","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=4321"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4321\/revisions"}],"predecessor-version":[{"id":9150,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4321\/revisions\/9150"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}