Vamos imaginar um cen\u00e1rio onde o backup do seu banco de dados precisa ser destinado para uma \u00e1rea que possui reten\u00e7\u00e3o de 1 m\u00eas, e por quest\u00f5es legais, tamb\u00e9m precisaria estar em outra \u00e1rea com reten\u00e7\u00e3o de 1 ano. Em vez de rodarmos 2 processos de backup distintos, podemos utilizar o recurso de Duplexed Backup Sets fornecido pelo RMAN, onde com apenas uma execu\u00e7\u00e3o, podemos criar backups totalmente iguais em diferentes locais. As m\u00eddias suportadas s\u00e3o disco e fita, por\u00e9m n\u00e3o podemos duplicar o backupset para disco e fita simultaneamente. O par\u00e2metro FORMAT \u00e9 usado para definir os destinos dos arquivos de backup. Lembrando que este recurso n\u00e3o existe para backup do tipo image copy, al\u00e9m de n\u00e3o podermos ter duplexi\u00e7\u00e3o na FRA (Fast Recovery Area). Neste artigo vamos explorar algumas maneiras de implementar este recurso.<\/p>\n\n\n\n
Simulando processo no n\u00edvel das configura\u00e7\u00f5es do RMAN, utilizando o seguinte modelo:<\/p>\n\n\n
\nCONFIGURE [DATAFILE | ARCHIVELOG] BACKUP COPIES FOR DEVICE TYPE [ DISK | SBT] TO n;\n<\/pre><\/div>\n\n\nAnalisando o valor default do par\u00e2metro acima:<\/p>\n\n\n
\nRMAN> SHOW DATAFILE BACKUP COPIES;\n \nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\n<\/pre><\/div>\n\n\nCom a configura\u00e7\u00e3o acima, mesmo emitindo o backup com 2 destinos diferentes, o RMAN far\u00e1 o backup apenas em 1:<\/p>\n\n\n
\nRMAN> BACKUP DEVICE TYPE DISK DATABASE FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U', '\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nStarting backup at 2021-05-03:05:01:16\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=74 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-03:05:01:16\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:05:01:41\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/bdvtt4cs_1_1 tag=TAG20210503T050116 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25\nFinished backup at 2021-05-03:05:01:41\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:01:41\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071550901_j8zch6ch_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:01:42\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------- ---- -- ---------- ----------- ------------ -------------------\n286 Full 1.28G DISK 00:00:02 2021-05-03:05:01:18\n BP Key: 294 Status: AVAILABLE Compressed: NO Tag: TAG20210503T050116\n Piece Name: \/oracle\/dados\/RMANDB\/BACKUP1\/bdvtt4cs_1_1\n List of Datafiles in backup set 286\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- ------------------- ----------- ------ ----\n 1 Full 2653633 2021-05-03:05:01:16 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n 3 Full 2653633 2021-05-03:05:01:16 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n 4 Full 2653633 2021-05-03:05:01:16 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n 5 Full 2653633 2021-05-03:05:01:16 NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n 7 Full 2653633 2021-05-03:05:01:16 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nRMAN> host 'ls -lthr \/oracle\/dados\/RMANDB\/BACKUP2\/';\n \ntotal 0\nhost command complete\n<\/pre><\/div>\n\n\nAp\u00f3s remover o backupset (para as evid\u00eancias expostas no artigo n\u00e3o ficarem polu\u00eddas), alteramos o par\u00e2metro do RMAN para que aceite 2 c\u00f3pias simult\u00e2neas:<\/p>\n\n\n
\nRMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;\n \nnew RMAN configuration parameters:\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;\nnew RMAN configuration parameters are successfully stored\n<\/pre><\/div>\n\n\nAo executar o mesmo backup, podemos notar que \u00e9 criado um Backup Key diferente para cada destino:<\/p>\n\n\n
\nRMAN> BACKUP DEVICE TYPE DISK DATABASE FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U', '\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nStarting backup at 2021-05-03:05:04:44\nusing channel ORA_DISK_1\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-03:05:04:44\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:05:06:29 with 2 copies and tag TAG20210503T050444\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/bfvtt4jc_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/bfvtt4jc_1_2 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:45\nFinished backup at 2021-05-03:05:06:29\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:06:29\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071551190_j8zcr6l1_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:06:31\n \nRMAN> LIST BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size\n------- ---- -- ----------\n288 Full 1.28G\n List of Datafiles in backup set 288\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- ------------------- ----------- ------ ----\n 1 Full 2654605 2021-05-03:05:04:44 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n 3 Full 2654605 2021-05-03:05:04:44 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n 4 Full 2654605 2021-05-03:05:04:44 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n 5 Full 2654605 2021-05-03:05:04:44 NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n 7 Full 2654605 2021-05-03:05:04:44 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \n Backup Set Copy #1 of backup set 288\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:52 2021-05-03:05:06:25 NO TAG20210503T050444\n \n List of Backup Pieces for backup set 288 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 296 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/bfvtt4jc_1_1\n \n Backup Set Copy #2 of backup set 288\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:52 2021-05-03:05:06:25 NO TAG20210503T050444\n \n List of Backup Pieces for backup set 288 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 297 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/bfvtt4jc_1_2\n<\/pre><\/div>\n\n\nImportante salientar que \u00e9 poss\u00edvel executar at\u00e9 4 backups duplexados por vez, como \u00e9 exposto no limite abaixo:<\/p>\n\n\n
\nRMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 100;\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of configure command at 05\/03\/2021 05:08:01\nRMAN-06411: backup copies setting out of range (1-4): 100\n<\/pre><\/div>\n\n\nAlterando par\u00e2metro para seu valor m\u00e1ximo e mantendo no comando apenas 2 destinos (para verificar o seu comportamento):<\/p>\n\n\n
\nRMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 4;\n \nold RMAN configuration parameters:\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;\nnew RMAN configuration parameters:\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 4;\nnew RMAN configuration parameters are successfully stored\n<\/pre><\/div>\n\n\nO resultado foi que mesmo definindo 2 destinos, o RMAN quadruplicou os backups, criando backupsets distintos:<\/p>\n\n\n
\nRMAN> BACKUP DEVICE TYPE DISK DATABASE FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U', '\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nStarting backup at 2021-05-03:05:09:56\nusing channel ORA_DISK_1\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-03:05:09:56\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:05:11:42 with 4 copies and tag TAG20210503T050956\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/bhvtt4t4_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/bhvtt4t4_1_2 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/bhvtt4t4_1_3 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/bhvtt4t4_1_4 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:46\nFinished backup at 2021-05-03:05:11:42\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:11:42\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071551502_j8zd1yz6_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:11:43\n \nRMAN> LIST BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size\n------- ---- -- ----------\n290 Full 1.28G\n List of Datafiles in backup set 290\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- ------------------- ----------- ------ ----\n 1 Full 2654858 2021-05-03:05:09:56 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n 3 Full 2654858 2021-05-03:05:09:56 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n 4 Full 2654858 2021-05-03:05:09:56 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n 5 Full 2654858 2021-05-03:05:09:56 NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n 7 Full 2654858 2021-05-03:05:09:56 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \n Backup Set Copy #1 of backup set 290\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:01:15 2021-05-03:05:11:37 NO TAG20210503T050956\n \n List of Backup Pieces for backup set 290 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 299 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/bhvtt4t4_1_1\n \n Backup Set Copy #2 of backup set 290\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:01:15 2021-05-03:05:11:37 NO TAG20210503T050956\n \n List of Backup Pieces for backup set 290 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 300 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/bhvtt4t4_1_2\n \n Backup Set Copy #3 of backup set 290\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:01:15 2021-05-03:05:11:37 NO TAG20210503T050956\n \n List of Backup Pieces for backup set 290 Copy #3\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 301 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/bhvtt4t4_1_3\n \n Backup Set Copy #4 of backup set 290\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:01:15 2021-05-03:05:11:37 NO TAG20210503T050956\n \n List of Backup Pieces for backup set 290 Copy #4\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 302 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/bhvtt4t4_1_4\n \nRMAN> host 'ls -lthr \/oracle\/dados\/RMANDB\/BACKUP1';\n \ntotal 2.6G\n-rw-r-----. 1 oracle oinstall 1.3G May 3 05:11 bhvtt4t4_1_1\n-rw-r-----. 1 oracle oinstall 1.3G May 3 05:11 bhvtt4t4_1_3\nhost command complete\n \nRMAN> host 'ls -lthr \/oracle\/dados\/RMANDB\/BACKUP2';\n \ntotal 2.6G\n-rw-r-----. 1 oracle oinstall 1.3G May 3 05:11 bhvtt4t4_1_2\n-rw-r-----. 1 oracle oinstall 1.3G May 3 05:11 bhvtt4t4_1_4\nhost command complete\n<\/pre><\/div>\n\n\nVoltando o par\u00e2metro RMAN ao seu valor padr\u00e3o:<\/p>\n\n\n
\nRMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;\n \nold RMAN configuration parameters:\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;\nRMAN configuration parameters are successfully reset to default value\n<\/pre><\/div>\n\n\nTodas essas etapas realizadas com os datafiles tamb\u00e9m podem ser aplicadas com os ARCHIVELOGs. Mostrando apenas um dos exemplos, j\u00e1 que a ideia \u00e9 a mesma:<\/p>\n\n\n
\nRMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;\n \nnew RMAN configuration parameters:\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;\nnew RMAN configuration parameters are successfully stored\n<\/pre><\/div>\n\n\nO backup duplicado \u00e9 realizado com sucesso:<\/p>\n\n\n
\nRMAN> BACKUP DEVICE TYPE DISK ARCHIVELOG ALL FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U', '\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nStarting backup at 2021-05-03:05:24:19\ncurrent log archived\nusing channel ORA_DISK_1\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\nchannel ORA_DISK_1: starting piece 1 at 2021-05-03:05:24:22\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:05:24:57 with 2 copies and tag TAG20210503T052421\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/blvtt5o6_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/blvtt5o6_1_2 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35\nFinished backup at 2021-05-03:05:24:57\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:24:57\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071552297_j8zdtt6s_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:24:58\n \nRMAN> LIST BACKUP OF ARCHIVELOG ALL;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Size\n------- ----------\n294 782.24M\n \n List of Archived Logs in backup set 294\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 \n Backup Set Copy #1 of backup set 294\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:17 2021-05-03:05:24:53 NO TAG20210503T052421\n \n List of Backup Pieces for backup set 294 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 308 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/blvtt5o6_1_1\n \n Backup Set Copy #2 of backup set 294\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:17 2021-05-03:05:24:53 NO TAG20210503T052421\n \n List of Backup Pieces for backup set 294 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 309 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/blvtt5o6_1_2\n<\/pre><\/div>\n\n\nVoltando par\u00e2metro para seu valor padr\u00e3o:<\/p>\n\n\n
\nRMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;\n \nold RMAN configuration parameters:\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;\nRMAN configuration parameters are successfully reset to default value\n<\/pre><\/div>\n\n\nRUN block level<\/h2>\n\n\n\n
Podemos utilizar o mesmo recurso diretamente do bloco RUN do RMAN. Observe que deixamos os par\u00e2metros persistentes do RMAN no seu valor padr\u00e3o (1 c\u00f3pia para datafile e archivelogs). Disparando backup e validando seu comportamento:<\/p>\n\n\n
\nRMAN> run {\n ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U','\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n SET BACKUP COPIES 2;\n BACKUP DATABASE;\n}2> 3> 4> 5>\n \nreleased channel: ORA_DISK_1\nallocated channel: C1\nchannel C1: SID=74 device type=DISK\n \nexecuting command: SET BACKUP COPIES\n \nStarting backup at 2021-05-03:05:42:43\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-05-03:05:42:43\nchannel C1: finished piece 1 at 2021-05-03:05:43:18 with 2 copies and tag TAG20210503T054243\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/bqvtt6qj_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/bqvtt6qj_1_2 comment=NONE\nchannel C1: backup set complete, elapsed time: 00:00:35\nFinished backup at 2021-05-03:05:43:18\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:43:18\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071553398_j8zfx6x9_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:43:21\nreleased channel: C1\n \nRMAN> LIST BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size\n------- ---- -- ----------\n299 Full 1.27G\n List of Datafiles in backup set 299\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- ------------------- ----------- ------ ----\n 1 Full 2656368 2021-05-03:05:42:43 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n 3 Full 2656368 2021-05-03:05:42:43 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n 4 Full 2656368 2021-05-03:05:42:43 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n 5 Full 2656368 2021-05-03:05:42:43 NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n 7 Full 2656368 2021-05-03:05:42:43 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \n Backup Set Copy #1 of backup set 299\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:16 2021-05-03:05:43:11 NO TAG20210503T054243\n \n List of Backup Pieces for backup set 299 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 316 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/bqvtt6qj_1_1\n \n Backup Set Copy #2 of backup set 299\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:16 2021-05-03:05:43:11 NO TAG20210503T054243\n \n List of Backup Pieces for backup set 299 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 317 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/bqvtt6qj_1_2\n \nRMAN> host 'ls -lthr \/oracle\/dados\/RMANDB\/BACKUP1\/';\n \ntotal 1.3G\n-rw-r-----. 1 oracle oinstall 1.3G May 3 05:42 bqvtt6qj_1_1\nhost command complete\n \nRMAN> host 'ls -lthr \/oracle\/dados\/RMANDB\/BACKUP2\/';\n \ntotal 1.3G\n-rw-r-----. 1 oracle oinstall 1.3G May 3 05:43 bqvtt6qj_1_2\nhost command complete\n<\/pre><\/div>\n\n\nBackup command level<\/h2>\n\n\n\n
Realizando processo diretamente pelo comando de backup, conforme modelo abaixo:<\/p>\n\n\n
\nBACKUP AS BACKUPSET COPIES n ... FORMAT <dest1>,<dest2>;\n<\/pre><\/div>\n\n\nSimulando backup do banco:<\/p>\n\n\n
\nRMAN> BACKUP AS BACKUPSET COPIES 2 DATABASE FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U','\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nStarting backup at 2021-05-03:05:55:24\nusing channel ORA_DISK_1\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-03:05:55:24\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:05:55:59 with 2 copies and tag TAG20210503T055524\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/c2vtt7ic_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/c2vtt7ic_1_2 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35\nFinished backup at 2021-05-03:05:55:59\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:55:59\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071554159_j8zgo078_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:56:00\n \nRMAN> LIST BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size\n------- ---- -- ----------\n307 Full 1.27G\n List of Datafiles in backup set 307\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- ------------------- ----------- ------ ----\n 1 Full 2657016 2021-05-03:05:55:24 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n 3 Full 2657016 2021-05-03:05:55:24 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n 4 Full 2657016 2021-05-03:05:55:24 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n 5 Full 2657016 2021-05-03:05:55:24 NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n 7 Full 2657016 2021-05-03:05:55:24 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \n Backup Set Copy #1 of backup set 307\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:16 2021-05-03:05:55:54 NO TAG20210503T055524\n \n List of Backup Pieces for backup set 307 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 325 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/c2vtt7ic_1_1\n \n Backup Set Copy #2 of backup set 307\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:16 2021-05-03:05:55:54 NO TAG20210503T055524\n \n List of Backup Pieces for backup set 307 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 326 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/c2vtt7ic_1_2\n<\/pre><\/div>\n\n\nSimulando backup dos archivelogs:<\/p>\n\n\n
\nRMAN> BACKUP AS BACKUPSET COPIES 2 ARCHIVELOG ALL FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U','\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nStarting backup at 2021-05-03:05:57:09\ncurrent log archived\nusing channel ORA_DISK_1\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\nchannel ORA_DISK_1: starting piece 1 at 2021-05-03:05:57:09\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:05:57:34 with 2 copies and tag TAG20210503T055709\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/c4vtt7ll_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/c4vtt7ll_1_2 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25\nFinished backup at 2021-05-03:05:57:34\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:05:57:35\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071554255_j8zgqzl1_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:05:57:36\n \nRMAN> LIST BACKUP OF ARCHIVELOG ALL;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Size\n------- ----------\n309 782.54M\n \n List of Archived Logs in backup set 309\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 \n Backup Set Copy #1 of backup set 309\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:06 2021-05-03:05:57:27 NO TAG20210503T055709\n \n List of Backup Pieces for backup set 309 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 328 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/c4vtt7ll_1_1\n \n Backup Set Copy #2 of backup set 309\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:06 2021-05-03:05:57:27 NO TAG20210503T055709\n \n List of Backup Pieces for backup set 309 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 329 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/c4vtt7ll_1_2\n<\/pre><\/div>\n\n\n\u00c9 poss\u00edvel utilizar este m\u00e9todo sem a necessidade de informar os locais de destino caso o par\u00e2metro do RMAN abaixo esteja configurado:<\/p>\n\n\n
\nRMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U','\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\n \nnew RMAN configuration parameters:\nCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\/oracle\/dados\/RMANDB\/BACKUP1\/%U', '\/oracle\/dados\/RMANDB\/BACKUP2\/%U';\nnew RMAN configuration parameters are successfully stored\nreleased channel: ORA_DISK_1\n<\/pre><\/div>\n\n\nResultado dos backups duplicados:<\/p>\n\n\n
\nRMAN> BACKUP AS BACKUPSET COPIES 2 DATABASE;\n \nStarting backup at 2021-05-03:06:07:55\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=74 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-03:06:07:55\nchannel ORA_DISK_1: finished piece 1 at 2021-05-03:06:08:30 with 2 copies and tag TAG20210503T060755\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP1\/c6vtt89r_1_1 comment=NONE\npiece handle=\/oracle\/dados\/RMANDB\/BACKUP2\/c6vtt89r_1_2 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35\nFinished backup at 2021-05-03:06:08:30\n \nStarting Control File and SPFILE Autobackup at 2021-05-03:06:08:30\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_03\/o1_mf_s_1071554910_j8zhdh62_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-03:06:08:31\n \nRMAN> LIST BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size\n------- ---- -- ----------\n311 Full 1.28G\n List of Datafiles in backup set 311\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- ------------------- ----------- ------ ----\n 1 Full 2658085 2021-05-03:06:07:55 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n 3 Full 2658085 2021-05-03:06:07:55 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n 4 Full 2658085 2021-05-03:06:07:55 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n 5 Full 2658085 2021-05-03:06:07:55 NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n 7 Full 2658085 2021-05-03:06:07:55 NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \n Backup Set Copy #1 of backup set 311\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:16 2021-05-03:06:08:25 NO TAG20210503T060755\n \n List of Backup Pieces for backup set 311 Copy #1\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 331 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP1\/c6vtt89r_1_1\n \n Backup Set Copy #2 of backup set 311\n Device Type Elapsed Time Completion Time Compressed Tag\n ----------- ------------ ------------------- ---------- ---\n DISK 00:00:16 2021-05-03:06:08:25 NO TAG20210503T060755\n \n List of Backup Pieces for backup set 311 Copy #2\n BP Key Pc# Status Piece Name\n ------- --- ----------- ----------\n 332 1 AVAILABLE \/oracle\/dados\/RMANDB\/BACKUP2\/c6vtt89r_1_2\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":"
Vamos imaginar um cen\u00e1rio onde o backup do seu banco de dados precisa ser destinado para uma \u00e1rea que possui reten\u00e7\u00e3o de 1 m\u00eas, e por quest\u00f5es legais, tamb\u00e9m precisaria estar em outra \u00e1rea com reten\u00e7\u00e3o de 1 ano. Em vez de rodarmos 2 processos de backup distintos, podemos utilizar o recurso de Duplexed Backup […]<\/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-4294","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\/4294","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=4294"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4294\/revisions"}],"predecessor-version":[{"id":9151,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4294\/revisions\/9151"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}