{"id":2598,"date":"2021-03-12T11:47:45","date_gmt":"2021-03-12T11:47:45","guid":{"rendered":"https:\/\/swiv.com.br\/taking-online-oracle-database-tablespace-and-datafile-backups\/"},"modified":"2026-05-27T20:02:51","modified_gmt":"2026-05-27T19:02:51","slug":"taking-online-oracle-database-tablespace-and-datafile-backups","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/12\/taking-online-oracle-database-tablespace-and-datafile-backups\/","title":{"rendered":"Taking Online Oracle Database, tablespace and datafile backups"},"content":{"rendered":"\n<p>Checando se o banco de dados est\u00e1 em ARCHIVELOG MODE:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 oracle]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Fri Mar 12 06:27:27 2021\nVersion 18.3.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.3.0.0.0\n \nSQL&gt; ARCHIVE LOG LIST;\nDatabase log mode              Archive Mode\nAutomatic archival             Enabled\nArchive destination            \/oracle\/archives\nOldest online log sequence     23\nNext log sequence to archive   25\nCurrent log sequence           25\nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Realizando o backup do banco de dados e archives em um mesmo comando:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 BACKUP]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Mar 12 06:34:37 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt; BACKUP DATABASE PLUS ARCHIVELOG;\n \n \nStarting backup at 2021-03-12:06:34:52\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=79 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=12 RECID=1 STAMP=1036965361\ninput archived log thread=1 sequence=13 RECID=2 STAMP=1039373324\ninput archived log thread=1 sequence=14 RECID=3 STAMP=1039385578\ninput archived log thread=1 sequence=15 RECID=4 STAMP=1039730500\ninput archived log thread=1 sequence=16 RECID=5 STAMP=1039730621\ninput archived log thread=1 sequence=17 RECID=6 STAMP=1039730703\ninput archived log thread=1 sequence=18 RECID=7 STAMP=1041720392\ninput archived log thread=1 sequence=19 RECID=8 STAMP=1065592715\ninput archived log thread=1 sequence=20 RECID=9 STAMP=1065710266\ninput archived log thread=1 sequence=21 RECID=10 STAMP=1065714954\ninput archived log thread=1 sequence=22 RECID=11 STAMP=1065717962\ninput archived log thread=1 sequence=23 RECID=12 STAMP=1066831250\ninput archived log thread=1 sequence=24 RECID=13 STAMP=1066972921\ninput archived log thread=1 sequence=25 RECID=14 STAMP=1066977292\nchannel ORA_DISK_1: starting piece 1 at 2021-03-12:06:34:54\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:06:35:01\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_annnn_TAG20210312T063454_j4pffyqo_.bkp tag=TAG20210312T063454 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07\nFinished backup at 2021-03-12:06:35:01\n \nStarting backup at 2021-03-12:06:35:01\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-03-12:06:35:02\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:06:35:17\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T063502_j4pfg728_.bkp tag=TAG20210312T063502 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\nFinished backup at 2021-03-12:06:35:17\n \nStarting backup at 2021-03-12:06:35:17\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=26 RECID=15 STAMP=1066977317\nchannel ORA_DISK_1: starting piece 1 at 2021-03-12:06:35:18\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:06:35:19\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_annnn_TAG20210312T063518_j4pfgp99_.bkp tag=TAG20210312T063518 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-12:06:35:19\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:06:35:19\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066977319_j4pfgrcx_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:06:35:22\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Para o pr\u00f3ximo teste, onde vamos criar um backup em um diret\u00f3rio fora da FRA, vou criar uma pasta na m\u00e1quina que abrigar\u00e1 os backup pieces:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 oracle]$ cd \/oracle\/\n&#x5B;oracle@oel8 oracle]$ mkdir BACKUP\n&#x5B;oracle@oel8 oracle]$ chmod 775 BACKUP\/\n<\/pre><\/div>\n\n\n<p>Utilizando o comando FORMAT:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP DATABASE FORMAT &#039;\/oracle\/BACKUP\/RMANDB%U.bkp&#039;;\n \nStarting backup at 2021-03-12:06:36:46\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-03-12:06:36:47\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:06:37:22\npiece handle=\/oracle\/BACKUP\/RMANDB0cvphi3v_1_1.bkp tag=TAG20210312T063647 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35\nFinished backup at 2021-03-12:06:37:22\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:06:37:22\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066977442_j4pflml8_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:06:37:25\n \nRMAN&gt; host &#039;ls -lthr&#039;;\n \ntotal 1.2G\n-rw-r-----. 1 oracle oinstall 1.2G Mar 12 06:36 RMANDB0cvphi3v_1_1.bkp\nhost command complete\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Realizando backup de uma tablespace espec\u00edfica:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 BACKUP]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Fri Mar 12 06:38:54 2021\nVersion 18.3.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.3.0.0.0\n \nSQL&gt; SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;\n \nTABLESPACE_NAME\n------------------------------\nSYSTEM\nSYSAUX\nUNDOTBS1\nTEMP\nUSERS\nTS_CORTEX_CATALOG\n \n6 rows selected.\n \nSQL&gt; exit\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n&#x5B;oracle@oel8 BACKUP]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Mar 12 06:39:14 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt; BACKUP TABLESPACE TS_CORTEX_CATALOG FORMAT &#039;\/oracle\/BACKUP\/tablespace_U%.bkp&#039;;\n \nStarting backup at 2021-03-12:06:40:32\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=72 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=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-03-12:06:40:34\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:06:40:35\npiece handle=\/oracle\/BACKUP\/tablespace_U%.bkp tag=TAG20210312T064034 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-12:06:40:35\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:06:40:36\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066977636_j4pfro5d_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:06:40:39\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Consultando backupset da tablespace:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUPSET OF TABLESPACE TS_CORTEX_CATALOG;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n8       Full    1.15G      DISK        00:00:10     2021-03-12:06:35:12\n        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20210312T063502\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T063502_j4pfg728_.bkp\n  List of Datafiles in backup set 8\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  5       Full 1805856    2021-03-12:06:35:02              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n11      Full    1.15G      DISK        00:00:04     2021-03-12:06:36:51\n        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20210312T063647\n        Piece Name: \/oracle\/BACKUP\/RMANDB0cvphi3v_1_1.bkp\n  List of Datafiles in backup set 11\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  5       Full 1805937    2021-03-12:06:36:47              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n13      Full    5.73M      DISK        00:00:00     2021-03-12:06:40:34\n        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20210312T064034\n        Piece Name: \/oracle\/BACKUP\/tablespace_U%.bkp\n  List of Datafiles in backup set 13\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  5       Full 1806064    2021-03-12:06:40:34              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Realizando backup de mais de uma tablespace ao mesmo tempo:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP TABLESPACE TS_CORTEX_CATALOG,USERS;\n \nStarting backup at 2021-03-12:06:42: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=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-12:06:42:56\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:06:42:57\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T064256_j4pfx0x1_.bkp tag=TAG20210312T064256 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-12:06:42:57\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:06:42:57\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066977778_j4pfx2od_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:06:42:59\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Realizando backup de um datafile usando o seu n\u00famero:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP DATAFILE 5;\n \nStarting backup at 2021-03-12:08:41:09\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=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-03-12:08:41:09\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:08:41:10\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084109_j4pntow6_.bkp tag=TAG20210312T084109 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-12:08:41:10\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:08:41:11\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066984871_j4pntqx8_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:08:41:12\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Pegando informa\u00e7\u00f5es do backupset:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUP OF DATAFILE 5;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n17      Full    5.73M      DISK        00:00:00     2021-03-12:08:41:09\n        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20210312T084109\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084109_j4pntow6_.bkp\n  List of Datafiles in backup set 17\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  5       Full 1810142    2021-03-12:08:41:09              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Realizando backup do datafile pelo seu nome (com diret\u00f3rio absoluto) e fazendo a consulta do backupset:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP DATAFILE &#039;\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf&#039;;\n \nStarting backup at 2021-03-12:08:44:35\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=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-03-12:08:44:36\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:08:44:37\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084435_j4po149t_.bkp tag=TAG20210312T084435 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-12:08:44:37\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:08:44:37\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066985077_j4po15z4_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:08:44:38\nRMAN&gt; LIST BACKUP OF DATAFILE &#039;\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf&#039;;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n21      Full    1.05M      DISK        00:00:00     2021-03-12:08:44:36\n        BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20210312T084435\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084435_j4po149t_.bkp\n  List of Datafiles in backup set 21\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 1810319    2021-03-12:08:44:36              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n<p>Realizando backup de mais de um datafile ao mesmo tempo:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; BACKUP DATAFILE 5,7;\n \nStarting backup at 2021-03-12:08:46:26\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=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-12:08:46:26\nchannel ORA_DISK_1: finished piece 1 at 2021-03-12:08:46:27\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084626_j4po4lsp_.bkp tag=TAG20210312T084626 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-12:08:46:27\n \nStarting Control File and SPFILE Autobackup at 2021-03-12:08:46:27\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066985188_j4po4nns_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-12:08:46:29\n<\/pre><\/div>\n\n\n<p>Deletando todos os backupsets:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; DELETE BACKUPSET;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n21      21      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084435_j4po149t_.bkp\n22      22      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066985077_j4po15z4_.bkp\n23      23      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084626_j4po4lsp_.bkp\n24      24      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066985188_j4po4nns_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084435_j4po149t_.bkp RECID=21 STAMP=1066985076\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066985077_j4po15z4_.bkp RECID=22 STAMP=1066985077\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_12\/o1_mf_nnndf_TAG20210312T084626_j4po4lsp_.bkp RECID=23 STAMP=1066985186\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_12\/o1_mf_s_1066985188_j4po4nns_.bkp RECID=24 STAMP=1066985188\nDeleted 4 objects\n<\/pre><\/div>\n\n\n<p>Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Checando se o banco de dados est\u00e1 em ARCHIVELOG MODE: Realizando o backup do banco de dados e archives em um mesmo comando: Para o pr\u00f3ximo teste, onde vamos criar um backup em um diret\u00f3rio fora da FRA, vou criar uma pasta na m\u00e1quina que abrigar\u00e1 os backup pieces: Utilizando o comando FORMAT: Realizando backup [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2598","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\/2598","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=2598"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2598\/revisions"}],"predecessor-version":[{"id":9236,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2598\/revisions\/9236"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}