{"id":2659,"date":"2021-03-15T08:19:54","date_gmt":"2021-03-15T08:19:54","guid":{"rendered":"https:\/\/swiv.com.br\/taking-backup-of-the-oracle-control-file\/"},"modified":"2026-05-27T20:02:51","modified_gmt":"2026-05-27T19:02:51","slug":"taking-backup-of-the-oracle-control-file","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/15\/taking-backup-of-the-oracle-control-file\/","title":{"rendered":"Taking Backup of the Oracle Control File"},"content":{"rendered":"\n<p>Checando o par\u00e2metro persistente do RMAN sobre o controlfile autobackup:<\/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 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Mon Mar 15 04:52:32 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; SHOW CONTROLFILE AUTOBACKUP;\n \nusing target database control file instead of recovery catalog\nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE CONTROLFILE AUTOBACKUP ON; # default\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Esta configura\u00e7\u00e3o permite que o RMAN fa\u00e7a o backup do mesmo, quando uma opera\u00e7\u00e3o de backup for disparada, como no exemplo abaixo:<\/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 USERS;\n \nStarting backup at 2021-03-15:04:55:43\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=91 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=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:04:55:44\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:04:55:45\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_nnndf_TAG20210315T045544_j4y4r0x8_.bkp tag=TAG20210315T045544 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:04:55:45\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:04:55:45\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230546_j4y4r39t_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:04:55:49\n<\/pre><\/div>\n\n\n<p>Consultando detalhes do backup realizado do control file:<\/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 CONTROLFILE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n26      Full    10.20M     DISK        00:00:01     2021-03-15:04:55:47\n        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T045546\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230546_j4y4r39t_.bkp\n  Control File Included: Ckp SCN: 1811359      Ckp time: 2021-03-15:04:55:46\n<\/pre><\/div>\n\n\n<p>Outra maneira de realizar o backup do control file \u00e9, de maneira expl\u00edcita, cit\u00e1-lo no comando, conforme exemplo abaixo:<\/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 USERS INCLUDE CURRENT CONTROLFILE;\n \nStarting backup at 2021-03-15:04:57: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\nincluding current control file in backup set\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:04:57:47\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:04:57:48\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_ncnnf_TAG20210315T045746_j4y4vvo0_.bkp tag=TAG20210315T045746 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\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-15:04:57:48\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:04:57:50\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_nnndf_TAG20210315T045746_j4y4vx8z_.bkp tag=TAG20210315T045746 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\nFinished backup at 2021-03-15:04:57:50\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:04:57:50\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230670_j4y4vytm_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:04:57:53\n<\/pre><\/div>\n\n\n<p>No script abaixo, realizamos o backup do control file e utilizamos o format para especificar o local que ser\u00e1 utilizado para criar o backup piece:<\/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 CURRENT CONTROLFILE FORMAT &#039;\/tmp\/control.bkp&#039;;\n \nStarting backup at 2021-03-15:05:01:24\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=113 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\nincluding current control file in backup set\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:05:01:27\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:05:01:28\npiece handle=\/tmp\/control.bkp tag=TAG20210315T050125 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:05:01:28\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:05:01:28\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230888_j4y52scl_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:05:01:31\n \nRMAN&gt; host &#039;ls \/tmp\/control.bkp&#039;;\n \n\/tmp\/control.bkp\nhost command complete\n<\/pre><\/div>\n\n\n<p>Utilizando a op\u00e7\u00e3o AS COPY, que cria um arquivo de backup exatamente igual ao arquivo e origem (snapshot):<\/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 AS COPY CURRENT CONTROLFILE FORMAT &#039;\/tmp\/control.ctl&#039;;\n \nStarting backup at 2021-03-15:05:05:13\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=64 device type=DISK\nchannel ORA_DISK_1: starting datafile copy\ncopying current control file\noutput file name=\/tmp\/control.ctl tag=TAG20210315T050514 RECID=1 STAMP=1067231115\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nFinished backup at 2021-03-15:05:05:17\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:05:05:17\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067231117_j4y59y8p_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:05:05:18\n \nRMAN&gt; host &#039;ls \/tmp\/control.ctl&#039;;\n \n\/tmp\/control.ctl\nhost command complete\n<\/pre><\/div>\n\n\n<p>Por falar no snapshot do controlfile, esse mecanismo \u00e9 usado pelo Oracle para garantir a consist\u00eancia do control file nas opera\u00e7\u00f5es de backup. Desse modo, podemos checar onde este snapshot est\u00e1 criado com o comando abaixo:<\/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; SHOW SNAPSHOT CONTROLFILE NAME;\n \nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;\/oracle\/18.0.0\/product\/dbs\/snapcf_RMANDB.f&#039;; # default\n<\/pre><\/div>\n\n\n<p>Em ambientes RAC, o ideal seria apontar o snapshot para um disco compartilhado por todas as inst\u00e2ncias, ou Disk Group, utilizando o comando abaixo de exemplo:<\/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; CONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;\/tmp\/snapcf_RMANDB.f&#039;;\n \nnew RMAN configuration parameters:\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;\/tmp\/snapcf_RMANDB.f&#039;;\nnew RMAN configuration parameters are successfully stored\n \nRMAN&gt; SHOW SNAPSHOT CONTROLFILE NAME;\n \nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;\/tmp\/snapcf_RMANDB.f&#039;;\n \nRMAN&gt; CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;\n \nold RMAN configuration parameters:\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;\/tmp\/snapcf_RMANDB.f&#039;;\nRMAN configuration parameters are successfully reset to default value\n \nRMAN&gt; SHOW SNAPSHOT CONTROLFILE NAME;\n \nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;\/oracle\/18.0.0\/product\/dbs\/snapcf_RMANDB.f&#039;; # default\n<\/pre><\/div>\n\n\n<p>Vendo o detalhe de todos os backups de control file (backupset e image copy):<\/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 CONTROLFILE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n26      Full    10.20M     DISK        00:00:01     2021-03-15:04:55:47\n        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T045546\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230546_j4y4r39t_.bkp\n  Control File Included: Ckp SCN: 1811359      Ckp time: 2021-03-15:04:55:46\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n27      Full    10.17M     DISK        00:00:01     2021-03-15:04:57:47\n        BP Key: 27   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T045746\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_ncnnf_TAG20210315T045746_j4y4vvo0_.bkp\n  Control File Included: Ckp SCN: 1811585      Ckp time: 2021-03-15:04:57:46\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n29      Full    10.20M     DISK        00:00:00     2021-03-15:04:57:50\n        BP Key: 29   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T045750\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230670_j4y4vytm_.bkp\n  Control File Included: Ckp SCN: 1811595      Ckp time: 2021-03-15:04:57:50\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n30      Full    10.17M     DISK        00:00:02     2021-03-15:05:01:27\n        BP Key: 30   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T050125\n        Piece Name: \/tmp\/control.bkp\n  Control File Included: Ckp SCN: 1811709      Ckp time: 2021-03-15:05:01:25\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n31      Full    10.20M     DISK        00:00:01     2021-03-15:05:01:29\n        BP Key: 31   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T050128\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230888_j4y52scl_.bkp\n  Control File Included: Ckp SCN: 1811718      Ckp time: 2021-03-15:05:01:28\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n32      Full    10.20M     DISK        00:00:01     2021-03-15:05:05:18\n        BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20210315T050517\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067231117_j4y59y8p_.bkp\n  Control File Included: Ckp SCN: 1811950      Ckp time: 2021-03-15:05:05:17\n \nRMAN&gt; LIST COPY OF CONTROLFILE;\n \nList of Control File Copies\n===========================\n \nKey     S Completion Time     Ckp SCN    Ckp Time\n------- - ------------------- ---------- -------------------\n1       A 2021-03-15:05:05:15 1811941    2021-03-15:05:05:14\n        Name: \/tmp\/control.ctl\n        Tag: TAG20210315T050514\n<\/pre><\/div>\n\n\n<p>Deletando os arquivos de backup:<\/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 OF CONTROLFILE;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n26      26      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230546_j4y4r39t_.bkp\n27      27      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_ncnnf_TAG20210315T045746_j4y4vvo0_.bkp\n29      29      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230670_j4y4vytm_.bkp\n30      30      1   1   AVAILABLE   DISK        \/tmp\/control.bkp\n31      31      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230888_j4y52scl_.bkp\n32      32      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067231117_j4y59y8p_.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\/autobackup\/2021_03_15\/o1_mf_s_1067230546_j4y4r39t_.bkp RECID=26 STAMP=1067230547\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_ncnnf_TAG20210315T045746_j4y4vvo0_.bkp RECID=27 STAMP=1067230667\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230670_j4y4vytm_.bkp RECID=29 STAMP=1067230670\ndeleted backup piece\nbackup piece handle=\/tmp\/control.bkp RECID=30 STAMP=1067230887\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067230888_j4y52scl_.bkp RECID=31 STAMP=1067230889\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067231117_j4y59y8p_.bkp RECID=32 STAMP=1067231118\nDeleted 6 objects\n \n \nRMAN&gt; DELETE COPY OF CONTROLFILE;\n \nreleased channel: ORA_DISK_1\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=64 device type=DISK\nList of Control File Copies\n===========================\n \nKey     S Completion Time     Ckp SCN    Ckp Time\n------- - ------------------- ---------- -------------------\n1       A 2021-03-15:05:05:15 1811941    2021-03-15:05:05:14\n        Name: \/tmp\/control.ctl\n        Tag: TAG20210315T050514\n \n \nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted control file copy\ncontrol file copy file name=\/tmp\/control.ctl RECID=1 STAMP=1067231115\nDeleted 1 objects\n<\/pre><\/div>\n\n\n<p>Uma \u00faltima maneira de se ter condi\u00e7\u00e3o de recuperar um control file, seria ger\u00e1-lo em formato SQL utilizando o comando abaixo:<\/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 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Mon Mar 15 05:17:11 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; ALTER DATABASE BACKUP CONTROLFILE TO TRACE;\n \nDatabase altered.\n<\/pre><\/div>\n\n\n<p>No alert temos a indica\u00e7\u00e3o que um arquivo trace foi gerado:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nALTER DATABASE BACKUP CONTROLFILE TO TRACE\nBackup controlfile written to trace file \/oracle\/18.0.0\/base\/diag\/rdbms\/rmandb\/RMANDB\/trace\/RMANDB_ora_9426.trc\nCompleted: ALTER DATABASE BACKUP CONTROLFILE TO TRACE\n<\/pre><\/div>\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 ~]$ cat \/oracle\/18.0.0\/base\/diag\/rdbms\/rmandb\/RMANDB\/trace\/RMANDB_ora_9426.trc\nTrace file \/oracle\/18.0.0\/base\/diag\/rdbms\/rmandb\/RMANDB\/trace\/RMANDB_ora_9426.trc\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\nBuild label:    RDBMS_18.1.0.0.0_LINUX.X64_180103.1\nORACLE_HOME:    \/oracle\/18.0.0\/product\nSystem name:    Linux\nNode name:      oel8.localdomain\nRelease:        4.18.0-147.el8.x86_64\nVersion:        #1 SMP Tue Nov 12 11:05:49 PST 2019\nMachine:        x86_64\nInstance name: RMANDB\nRedo thread mounted by this instance: 1\nOracle process number: 34\nUnix process pid: 9426, image: oracle@oel8.localdomain (TNS V1-V3)\n \n \n*** 2021-03-15T05:17:26.300266-03:00\n*** SESSION ID:(64.54520) 2021-03-15T05:17:26.300290-03:00\n*** CLIENT ID:() 2021-03-15T05:17:26.300297-03:00\n*** SERVICE NAME:(SYS$USERS) 2021-03-15T05:17:26.300302-03:00\n*** MODULE NAME:(sqlplus@oel8.localdomain (TNS V1-V3)) 2021-03-15T05:17:26.300308-03:00\n*** ACTION NAME:() 2021-03-15T05:17:26.300313-03:00\n*** CLIENT DRIVER:(SQL*PLUS) 2021-03-15T05:17:26.300318-03:00\n \n...\n \nSTARTUP NOMOUNT\nCREATE CONTROLFILE REUSE DATABASE &quot;RMANDB&quot; NORESETLOGS  ARCHIVELOG\n    MAXLOGFILES 16\n    MAXLOGMEMBERS 3\n    MAXDATAFILES 100\n    MAXINSTANCES 8\n    MAXLOGHISTORY 292\nLOGFILE\n  GROUP 1 (\n    &#039;\/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_1_h8nytyh4_.log&#039;,\n    &#039;\/oracle\/fra\/RMANDB\/onlinelog\/o1_mf_1_h8nytznd_.log&#039;\n  ) SIZE 50M BLOCKSIZE 512,\n  GROUP 2 (\n    &#039;\/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_2_h8nytykj_.log&#039;,\n    &#039;\/oracle\/fra\/RMANDB\/onlinelog\/o1_mf_2_h8nytzlh_.log&#039;\n  ) SIZE 50M BLOCKSIZE 512,\n  GROUP 3 (\n    &#039;\/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_3_h8nyv1ok_.log&#039;,\n    &#039;\/oracle\/fra\/RMANDB\/onlinelog\/o1_mf_3_h8nyv1y3_.log&#039;\n  ) SIZE 50M BLOCKSIZE 512\n-- STANDBY LOGFILE\nDATAFILE\n  &#039;\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf&#039;,\n  &#039;\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf&#039;,\n  &#039;\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf&#039;,\n  &#039;\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf&#039;,\n  &#039;\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf&#039;\nCHARACTER SET AL32UTF8\n;\n...\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 o par\u00e2metro persistente do RMAN sobre o controlfile autobackup: Esta configura\u00e7\u00e3o permite que o RMAN fa\u00e7a o backup do mesmo, quando uma opera\u00e7\u00e3o de backup for disparada, como no exemplo abaixo: Consultando detalhes do backup realizado do control file: Outra maneira de realizar o backup do control file \u00e9, de maneira expl\u00edcita, cit\u00e1-lo no [&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-2659","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\/2659","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=2659"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2659\/revisions"}],"predecessor-version":[{"id":9233,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2659\/revisions\/9233"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}