{"id":4214,"date":"2021-05-01T07:34:55","date_gmt":"2021-05-01T07:34:55","guid":{"rendered":"https:\/\/swiv.com.br\/using-rman-multisection-backups\/"},"modified":"2026-05-27T20:02:32","modified_gmt":"2026-05-27T19:02:32","slug":"using-rman-multisection-backups","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/05\/01\/using-rman-multisection-backups\/","title":{"rendered":"Using RMAN Multisection Backups"},"content":{"rendered":"\n

Em algumas situa\u00e7\u00f5es, podemos nos deparar com a necessidade de realizar um backup RMAN de um arquivo muito grande (proveniente de uma Bigfile Tablespace, que por exemplo na vers\u00e3o 12.1 pode chegar at\u00e9 128TB). No passado, essa opera\u00e7\u00e3o seria muito demorada, pois haveria apenas um processo do RMAN realizando, de forma serializada, o backup. A partir deste cen\u00e1rio, a Oracle disponibilizou o recurso de Multisection Backups, onde podemos “quebrar” estes arquivos em sess\u00f5es\/peda\u00e7os para serem backupeados independentemente, e em paralelo, gerando assim um backup piece para cada sess\u00e3o. Podemos usar esta op\u00e7\u00e3o para backup sets (full ou incrementais) e backups do tipo image copy. Lembrando que \u00e9 importante validarmos se teremos este backup paralelizado rodando em Storage Devices diferentes (como representa o desenho abaixo). Neste artigo vamos explorar sua aplica\u00e7\u00e3o pr\u00e1tica com um exemplo simples.<\/p>\n\n\n\n

\"\"
Fonte: Oracle Database 12C Backup and Recovery \u2013 a course by Ahmed Baraka<\/figcaption><\/figure>\n\n\n\n

Realizando um REPORT SCHEMA para ver o tamanho atual das tablespaces em meu laborat\u00f3rio:<\/p>\n\n\n

\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Sat May 1 04:14:19 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> REPORT SCHEMA;\n \nusing target database control file instead of recovery catalog\nReport of database schema for database with db_unique_name RMANDB\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1    860      SYSTEM               YES     \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n3    680      SYSAUX               NO      \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n4    305      UNDOTBS1             YES     \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n5    200      TS_CORTEX_CATALOG    NO      \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n7    16       USERS                NO      \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace           Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1    32       TEMP                 32767       \/oracle\/dados\/RMANDB\/datafile\/o1_mf_temp_h8nyvt1f_.tmp\n<\/pre><\/div>\n\n\n
Realizando um backup da tablespace SYSTEM, que possui 860MB, sem o recurso de Multisection. O que \u00e9 poss\u00edvel abstrair: O RMAN cria apenas um canal (ORA_DISK_1) que far\u00e1 o backup de forma serializada em apenas um backup piece:<\/p>\n\n\n
\nRMAN> BACKUP TABLESPACE SYSTEM;\n \nStarting backup at 2021-05-01:04:28:42\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=77 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\nchannel ORA_DISK_1: starting piece 1 at 2021-05-01:04:28:43\nchannel ORA_DISK_1: finished piece 1 at 2021-05-01:04:28:58\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp tag=TAG20210501T042843 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\nFinished backup at 2021-05-01:04:28:58\n \nStarting Control File and SPFILE Autobackup at 2021-05-01:04:28:58\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376138_j8t0sv3f_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-01:04:29:01\n \nRMAN> LIST BACKUP OF TABLESPACE SYSTEM;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n275     Full    738.98M    DISK        00:00:03     2021-05-01:04:28:46\n        BP Key: 277   Status: AVAILABLE  Compressed: NO  Tag: TAG20210501T042843\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp\n  List of Datafiles in backup set 275\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2608562    2021-05-01:04:28:43              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n<\/pre><\/div>\n\n\n
Deletando backup:<\/p>\n\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------- ------- --- --- ----------- ----------- ----------\n277     275     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp\n278     276     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376138_j8t0sv3f_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp RECID=277 STAMP=1071376123\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376138_j8t0sv3f_.bkp RECID=278 STAMP=1071376139\nDeleted 2 objects\n<\/pre><\/div>\n\n\n
Realizando o backup da mesma tablespace adicionando a op\u00e7\u00e3o “SECTION SIZE” no comando. Podemos observer que, apesar de criar backup pieces a mais, o RMAN ainda utiliza apenas 1 canal (pois o par\u00e2metro DEVICE TYPE est\u00e1 com paralelismo definido em seu valor padr\u00e3o, que \u00e9 1):<\/p>\n\n\n
\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Sat May 1 04:30:46 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> SHOW DEVICE TYPE;\n \nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default\n \nRMAN> BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;\n \nStarting backup at 2021-05-01:04:30:54\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=57 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\nbacking up blocks 1 through 51200\nchannel ORA_DISK_1: starting piece 1 at 2021-05-01:04:30:55\nchannel ORA_DISK_1: finished piece 1 at 2021-05-01:04:31:02\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp tag=TAG20210501T043055 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07\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\nbacking up blocks 51201 through 102400\nchannel ORA_DISK_1: starting piece 2 at 2021-05-01:04:31:02\nchannel ORA_DISK_1: finished piece 2 at 2021-05-01:04:31:09\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp tag=TAG20210501T043055 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07\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\nbacking up blocks 102401 through 110080\nchannel ORA_DISK_1: starting piece 3 at 2021-05-01:04:31:09\nchannel ORA_DISK_1: finished piece 3 at 2021-05-01:04:31:10\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp tag=TAG20210501T043055 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-05-01:04:31:10\n \nStarting Control File and SPFILE Autobackup at 2021-05-01:04:31:10\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376270_j8t0xyw9_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-01:04:31:11\n \nRMAN> LIST BACKUP OF TABLESPACE SYSTEM;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n277     Full    739.08M    DISK        00:00:14     2021-05-01:04:31:09\n  List of Datafiles in backup set 277\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2608689    2021-05-01:04:30:55              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n \n  Backup Set Copy #1 of backup set 277\n  Device Type Elapsed Time Completion Time     Compressed Tag\n  ----------- ------------ ------------------- ---------- ---\n  DISK        00:00:14     2021-05-01:04:31:09 NO         TAG20210501T043055\n \n    List of Backup Pieces for backup set 277 Copy #1\n    BP Key  Pc# Status      Piece Name\n    ------- --- ----------- ----------\n    279     1   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp\n    280     2   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp\n    281     3   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp\n<\/pre><\/div>\n\n\n
Deletando backup:<\/p>\n\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------- ------- --- --- ----------- ----------- ----------\n279     277     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp\n280     277     2   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp\n281     277     3   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp\n282     278     1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376270_j8t0xyw9_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp RECID=279 STAMP=1071376255\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp RECID=280 STAMP=1071376262\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp RECID=281 STAMP=1071376269\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376270_j8t0xyw9_.bkp RECID=282 STAMP=1071376270\nDeleted 4 objects\n<\/pre><\/div>\n\n\n
Realizando o backup com a mesma op\u00e7\u00e3o de SECTION SIZE, por\u00e9m fazendo a abertura dos canais de forma manual, para que o processo seja feito em paralelo. Lembrando que caso queiramos delegar ao RMAN a abertura de m\u00faltiplos canais conforme a situa\u00e7\u00e3o, basta definirmos o paralelismo no par\u00e2metro DEVICE TYPE:<\/p>\n\n\n
\nRMAN> RUN {\n        ALLOCATE CHANNEL c1 DEVICE TYPE DISK;\n        ALLOCATE CHANNEL c2 DEVICE TYPE DISK;\n        ALLOCATE CHANNEL c3 DEVICE TYPE DISK;\n        BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;\n}2> 3> 4> 5> 6>\n \nusing target database control file instead of recovery catalog\nallocated channel: c1\nchannel c1: SID=77 device type=DISK\n \nallocated channel: c2\nchannel c2: SID=76 device type=DISK\n \nallocated channel: c3\nchannel c3: SID=69 device type=DISK\n \nStarting backup at 2021-05-01:04:33:27\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\nbacking up blocks 1 through 51200\nchannel c1: starting piece 1 at 2021-05-01:04:33:27\nchannel c2: starting full datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 51201 through 102400\nchannel c2: starting piece 2 at 2021-05-01:04:33:27\nchannel c3: starting full datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 102401 through 110080\nchannel c3: starting piece 3 at 2021-05-01:04:33:27\nchannel c1: finished piece 1 at 2021-05-01:04:33:36\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043327_j8t127o9_.bkp tag=TAG20210501T043327 comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:09\nchannel c3: finished piece 3 at 2021-05-01:04:33:36\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043327_j8t1280b_.bkp tag=TAG20210501T043327 comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:09\nchannel c2: finished piece 2 at 2021-05-01:04:33:44\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043327_j8t127xk_.bkp tag=TAG20210501T043327 comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:17\nFinished backup at 2021-05-01:04:33:44\n \nStarting Control File and SPFILE Autobackup at 2021-05-01:04:33:44\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376424_j8t12rsf_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-01:04:33:45\nreleased channel: c1\nreleased channel: c2\nreleased channel: c3\n \nRMAN> LIST BACKUP OF TABLESPACE SYSTEM;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n279     Full    739.08M    DISK        00:00:04     2021-05-01:04:33:31\n  List of Datafiles in backup set 279\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2608837    2021-05-01:04:33:27              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n \n  Backup Set Copy #1 of backup set 279\n  Device Type Elapsed Time Completion Time     Compressed Tag\n  ----------- ------------ ------------------- ---------- ---\n  DISK        00:00:04     2021-05-01:04:33:36 NO         TAG20210501T043327\n \n    List of Backup Pieces for backup set 279 Copy #1\n    BP Key  Pc# Status      Piece Name\n    ------- --- ----------- ----------\n    284     1   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043327_j8t127o9_.bkp\n    285     2   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043327_j8t127xk_.bkp\n    283     3   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnndf_TAG20210501T043327_j8t1280b_.bkp\n<\/pre><\/div>\n\n\n
Dando exemplo do mesmo recurso funcionando em backup incremental:<\/p>\n\n\n
\nRMAN> RUN {\n        ALLOCATE CHANNEL c1 DEVICE TYPE DISK;\n        ALLOCATE CHANNEL c2 DEVICE TYPE DISK;\n        ALLOCATE CHANNEL c3 DEVICE TYPE DISK;\n        BACKUP INCREMENTAL LEVEL 1 SECTION SIZE 400M DATAFILE '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf';\n}2> 3> 4> 5> 6>\n \nusing target database control file instead of recovery catalog\nallocated channel: c1\nchannel c1: SID=58 device type=DISK\n \nallocated channel: c2\nchannel c2: SID=57 device type=DISK\n \nallocated channel: c3\nchannel c3: SID=72 device type=DISK\n \nStarting backup at 2021-05-01:04:37:20\nno parent backup or copy of datafile 1 found\nchannel c1: starting incremental level 1 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\nbacking up blocks 1 through 51200\nchannel c1: starting piece 1 at 2021-05-01:04:37:20\nchannel c2: starting incremental level 1 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 51201 through 102400\nchannel c2: starting piece 2 at 2021-05-01:04:37:20\nchannel c3: starting incremental level 1 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 102401 through 110080\nchannel c3: starting piece 3 at 2021-05-01:04:37:20\nchannel c1: finished piece 1 at 2021-05-01:04:37:28\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnnd1_TAG20210501T043720_j8t19jgq_.bkp tag=TAG20210501T043720 comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:08\nchannel c3: finished piece 3 at 2021-05-01:04:37:28\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnnd1_TAG20210501T043720_j8t19jr1_.bkp tag=TAG20210501T043720 comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:08\nchannel c2: finished piece 2 at 2021-05-01:04:37:28\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnnd1_TAG20210501T043720_j8t19jog_.bkp tag=TAG20210501T043720 comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:08\nFinished backup at 2021-05-01:04:37:28\n \nStarting Control File and SPFILE Autobackup at 2021-05-01:04:37:28\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376648_j8t19sg9_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-01:04:37:31\nreleased channel: c1\nreleased channel: c2\nreleased channel: c3\n \nRMAN> LIST BACKUP OF DATAFILE 1;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n281     Incr 1  723.13M    DISK        00:00:04     2021-05-01:04:37:24\n  List of Datafiles in backup set 281\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1    0  Incr 2609032    2021-05-01:04:37:20              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n \n  Backup Set Copy #1 of backup set 281\n  Device Type Elapsed Time Completion Time     Compressed Tag\n  ----------- ------------ ------------------- ---------- ---\n  DISK        00:00:04     2021-05-01:04:37:28 NO         TAG20210501T043720\n \n    List of Backup Pieces for backup set 281 Copy #1\n    BP Key  Pc# Status      Piece Name\n    ------- --- ----------- ----------\n    288     1   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnnd1_TAG20210501T043720_j8t19jgq_.bkp\n    289     2   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnnd1_TAG20210501T043720_j8t19jog_.bkp\n    287     3   AVAILABLE   \/oracle\/fra\/RMANDB\/backupset\/2021_05_01\/o1_mf_nnnd1_TAG20210501T043720_j8t19jr1_.bkp\n<\/pre><\/div>\n\n\n
Exemplo com Image Copy:<\/p>\n\n\n
\nRMAN> RUN {\n        ALLOCATE CHANNEL c1 DEVICE TYPE DISK;\n        ALLOCATE CHANNEL c2 DEVICE TYPE DISK;\n        ALLOCATE CHANNEL c3 DEVICE TYPE DISK;\n        BACKUP AS COPY SECTION SIZE 400M TABLESPACE SYSTEM;\n}2> 3> 4> 5> 6>\n \nusing target database control file instead of recovery catalog\nallocated channel: c1\nchannel c1: SID=72 device type=DISK\n \nallocated channel: c2\nchannel c2: SID=76 device type=DISK\n \nallocated channel: c3\nchannel c3: SID=77 device type=DISK\n \nStarting backup at 2021-05-01:04:41:06\nchannel c1: starting datafile copy\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 1 through 51200\nchannel c2: starting datafile copy\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 51201 through 102400\nchannel c3: starting datafile copy\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nbacking up blocks 102401 through 110080\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j8t1jl8o_.dbf tag=TAG20210501T044106\nchannel c3: datafile copy complete, elapsed time: 00:00:15\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j8t1jl8o_.dbf tag=TAG20210501T044106\nchannel c1: datafile copy complete, elapsed time: 00:00:26\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j8t1jl8o_.dbf tag=TAG20210501T044106\nchannel c2: datafile copy complete, elapsed time: 00:00:26\nFinished backup at 2021-05-01:04:41:32\n \nStarting Control File and SPFILE Autobackup at 2021-05-01:04:41:32\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_05_01\/o1_mf_s_1071376892_j8t1kf5h_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-05-01:04:41:33\nreleased channel: c1\nreleased channel: c2\nreleased channel: c3\n \nRMAN> LIST BACKUP OF TABLESPACE SYSTEM;\n \nspecification does not match any backup in the repository\n \nRMAN> LIST COPY OF TABLESPACE SYSTEM;\n \nList of Datafile Copies\n=======================\n \nKey     File S Completion Time     Ckp SCN    Ckp Time            Sparse\n------- ---- - ------------------- ---------- ------------------- ------\n43      1    A 2021-05-01:04:41:06 2609223    2021-05-01:04:41:06 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j8t1jl8o_.dbf\n        Tag: TAG20210501T044106\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 algumas situa\u00e7\u00f5es, podemos nos deparar com a necessidade de realizar um backup RMAN de um arquivo muito grande (proveniente de uma Bigfile Tablespace, que por exemplo na vers\u00e3o 12.1 pode chegar at\u00e9 128TB). No passado, essa opera\u00e7\u00e3o seria muito demorada, pois haveria apenas um processo do RMAN realizando, de forma serializada, o backup. A […]<\/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-4214","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\/4214","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=4214"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4214\/revisions"}],"predecessor-version":[{"id":9153,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4214\/revisions\/9153"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}