{"id":4646,"date":"2021-05-15T07:57:28","date_gmt":"2021-05-15T07:57:28","guid":{"rendered":"https:\/\/swiv.com.br\/performing-rman-recovery-from-system-cdbroot-datafile-loss\/"},"modified":"2026-05-27T20:02:32","modified_gmt":"2026-05-27T19:02:32","slug":"performing-rman-recovery-from-system-cdbroot-datafile-loss","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/05\/15\/performing-rman-recovery-from-system-cdbroot-datafile-loss\/","title":{"rendered":"PERFORMING RMAN RECOVERY FROM SYSTEM CDB$ROOT DATAFILE LOSS"},"content":{"rendered":"\n<p>Coletando informa\u00e7\u00f5es do ambiente:<\/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@quiasma ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Sat May 15 04:35:41 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL&gt; SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE;\n \nNAME      OPEN_MODE            CDB\n--------- -------------------- ---\nASWAN     READ WRITE           YES\n \nSQL&gt; SELECT NAME,OPEN_MODE FROM V$PDBS;\n \nNAME\n--------------------------------------------------------------------------------\nOPEN_MODE\n----------\nPDB$SEED\nREAD ONLY\n \nHIPOFISE1\nMOUNTED\n \n \nSQL&gt; SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME=&#039;SYSTEM&#039;;\n \nFILE_NAME\n--------------------------------------------------------------------------------\n\/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wbzgc1_.dbf\n<\/pre><\/div>\n\n\n<p>Realizando backup do banco de dados:<\/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@quiasma ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Sat May 15 04:36:51 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: ASWAN (DBID=1340416544)\n \nRMAN&gt; BACKUP DATABASE PLUS ARCHIVELOG;\n \n \nStarting backup at 15-MAY-21\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=109 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=6 RECID=1 STAMP=1072501770\ninput archived log thread=1 sequence=7 RECID=2 STAMP=1072501809\ninput archived log thread=1 sequence=8 RECID=3 STAMP=1072503370\ninput archived log thread=1 sequence=9 RECID=4 STAMP=1072503403\ninput archived log thread=1 sequence=10 RECID=5 STAMP=1072586228\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_annnn_TAG20210515T043708_j9yyk4yg_.bkp tag=TAG20210515T043708 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 15-MAY-21\n \nStarting backup at 15-MAY-21\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\/ASWAN\/datafile\/o1_mf_system_j9wbzgc1_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc1bk9_.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_users_j9wc1clt_.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T043712_j9yyk87t_.bkp tag=TAG20210515T043712 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\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\/ASWAN\/datafile\/o1_mf_system_j9wc9px6_.dbf\ninput datafile file number=00006 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc9px1_.dbf\ninput datafile file number=00008 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc9px7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C2469670772D160AE0536A00A8C00FFA\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T043712_j9yykqb9_.bkp tag=TAG20210515T043712 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00009 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_system_j9wcyoh3_.dbf\ninput datafile file number=00010 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf\ninput datafile file number=00011 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_undotbs1_j9wcyoh8_.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T043712_j9yyktfp_.bkp tag=TAG20210515T043712 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07\nFinished backup at 15-MAY-21\n \nStarting backup at 15-MAY-21\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=11 RECID=6 STAMP=1072586257\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_annnn_TAG20210515T043737_j9yyl1n1_.bkp tag=TAG20210515T043737 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 15-MAY-21\n \nStarting Control File and SPFILE Autobackup at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/autobackup\/2021_05_15\/o1_mf_s_1072586258_j9yyl2vn_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 15-MAY-21\n<\/pre><\/div>\n\n\n<p>Removendo o datafile relacionado com a tablespace SYSTEM:<\/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@quiasma ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Sat May 15 04:38:29 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL&gt; ! rm \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wbzgc1_.dbf\n \nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Tentando realizar alguma opera\u00e7\u00e3o no banco, e percebendo que o mesmo j\u00e1 identifica o problema:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; DESC DBA_DATA_FILES\nERROR:\nORA-00604: error occurred at recursive SQL level 1\nORA-01116: error in opening database file 1\nORA-01110: data file 1:\n&#039;\/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wbzgc1_.dbf&#039;\nORA-27041: unable to open file\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\n<\/pre><\/div>\n\n\n<p>Baixando inst\u00e2ncia e montando o banco de dados:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SHU ABORT;\nORACLE instance shut down.\nSQL&gt; STARTUP MOUNT;\nORACLE instance started.\n \nTotal System Global Area 2466249080 bytes\nFixed Size                  8898936 bytes\nVariable Size             671088640 bytes\nDatabase Buffers         1778384896 bytes\nRedo Buffers                7876608 bytes\nDatabase mounted.\n<\/pre><\/div>\n\n\n<p>Neste momento, vou simular o restore do banco todo do CDB$ROOT:<\/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; RESTORE DATABASE &quot;CDB$ROOT&quot;;\n \nStarting restore at 15-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=45 device type=DISK\n \nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00001 to \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wbzgc1_.dbf\nchannel ORA_DISK_1: restoring datafile 00003 to \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\nchannel ORA_DISK_1: restoring datafile 00004 to \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc1bk9_.dbf\nchannel ORA_DISK_1: restoring datafile 00007 to \/oracle\/dados\/ASWAN\/datafile\/o1_mf_users_j9wc1clt_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T043712_j9yyk87t_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T043712_j9yyk87t_.bkp tag=TAG20210515T043712\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:07\nFinished restore at 15-MAY-21\n<\/pre><\/div>\n\n\n<p>Fazendo o Recover do banco. A palavra &#8220;ROOT&#8221; tamb\u00e9m pode ser usada, no lugar de &#8220;CDB$ROOT&#8221;:<\/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; RECOVER DATABASE ROOT;\n \nStarting recover at 15-MAY-21\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n \nFinished recover at 15-MAY-21\n<\/pre><\/div>\n\n\n<p>Banco aberto:<\/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; ALTER DATABASE OPEN;\n \nStatement processed\n<\/pre><\/div>\n\n\n<p>Validando o CDB$ROOT e abrindo os seus PDBs:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE;\n \nNAME      OPEN_MODE            CDB\n--------- -------------------- ---\nASWAN     READ WRITE           YES\n \nSQL&gt; SELECT NAME,OPEN_MODE FROM V$PDBS;\n \nNAME\n--------------------------------------------------------------------------------\nOPEN_MODE\n----------\nPDB$SEED\nREAD ONLY\n \nHIPOFISE1\nMOUNTED\n \n \nSQL&gt; ALTER PLUGGABLE DATABASE ALL OPEN;\n \nPluggable database altered.\n \nSQL&gt; ALTER PLUGGABLE DATABASE ALL SAVE STATE;\n \nPluggable database altered.\n \nSQL&gt; SELECT NAME,OPEN_MODE FROM V$PDBS;\n \nNAME\n--------------------------------------------------------------------------------\nOPEN_MODE\n----------\nPDB$SEED\nREAD ONLY\n \nHIPOFISE1\nREAD WRITE\n<\/pre><\/div>\n\n\n<p>Outra maneira de nos recupermos de uma situa\u00e7\u00e3o dessa \u00e9 fazer o restore\/recover apenas da tablespace SYSTEM, que foi a tablespace afetada nesse exemplo do artigo. Vamos simular, realizando um novo backup e removendo o datafile:<\/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 PLUS ARCHIVELOG;\n \n \nStarting backup at 15-MAY-21\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=6 RECID=1 STAMP=1072501770\ninput archived log thread=1 sequence=7 RECID=2 STAMP=1072501809\ninput archived log thread=1 sequence=8 RECID=3 STAMP=1072503370\ninput archived log thread=1 sequence=9 RECID=4 STAMP=1072503403\ninput archived log thread=1 sequence=10 RECID=5 STAMP=1072586228\ninput archived log thread=1 sequence=11 RECID=6 STAMP=1072586257\ninput archived log thread=1 sequence=12 RECID=7 STAMP=1072586635\ninput archived log thread=1 sequence=13 RECID=8 STAMP=1072586846\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_annnn_TAG20210515T044726_j9yz4gwv_.bkp tag=TAG20210515T044726 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 15-MAY-21\n \nStarting backup at 15-MAY-21\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\/ASWAN\/datafile\/o1_mf_system_j9yytdmq_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc1bk9_.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_users_j9wc1clt_.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T044728_j9yz4j6r_.bkp tag=TAG20210515T044728 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=00009 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_system_j9wcyoh3_.dbf\ninput datafile file number=00010 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf\ninput datafile file number=00011 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_undotbs1_j9wcyoh8_.dbf\ninput datafile file number=00012 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_users_j9yz06wp_.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T044728_j9yz4qdd_.bkp tag=TAG20210515T044728 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\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\/ASWAN\/datafile\/o1_mf_system_j9wc9px6_.dbf\ninput datafile file number=00006 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc9px1_.dbf\ninput datafile file number=00008 name=\/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc9px7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C2469670772D160AE0536A00A8C00FFA\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T044728_j9yz4tbv_.bkp tag=TAG20210515T044728 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 15-MAY-21\n \nStarting backup at 15-MAY-21\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=14 RECID=9 STAMP=1072586861\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_annnn_TAG20210515T044741_j9yz4xl0_.bkp tag=TAG20210515T044741 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 15-MAY-21\n \nStarting Control File and SPFILE Autobackup at 15-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/autobackup\/2021_05_15\/o1_mf_s_1072586862_j9yz4yrt_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 15-MAY-21\n<\/pre><\/div>\n\n\n<p>Removendo datafile:<\/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; SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME=&#039;SYSTEM&#039;;\n \n \n \nFILE_NAME\n--------------------------------------------------------------------------------\n \n\/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yytdmq_.dbf\n \n \nRMAN&gt; host &#039;rm \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yytdmq_.dbf&#039;;\n \nhost command complete\n \nRMAN&gt; REPORT SCHEMA;\n \nusing target database control file instead of recovery catalog\nReport of database schema for database with db_unique_name ASWAN\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of report command at 05\/15\/2021 04:52:18\nORA-01116: error in opening database file 1\nORA-01110: data file 1: &#039;\/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yytdmq_.dbf&#039;\nORA-27041: unable to open file\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SHU ABORT;\nORACLE instance shut down.\nSQL&gt; STARTUP MOUNT;\nORACLE instance started.\n \nTotal System Global Area 2466249080 bytes\nFixed Size                  8898936 bytes\nVariable Size             671088640 bytes\nDatabase Buffers         1778384896 bytes\nRedo Buffers                7876608 bytes\nDatabase mounted.\n<\/pre><\/div>\n\n\n<p>Restaurando apenas a tablespace SYSTEM:<\/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; RESTORE TABLESPACE ROOT:SYSTEM;\n \nStarting restore at 15-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=46 device type=DISK\n \nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00001 to \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yytdmq_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T044728_j9yz4j6r_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_15\/o1_mf_nnndf_TAG20210515T044728_j9yz4j6r_.bkp tag=TAG20210515T044728\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:07\nFinished restore at 15-MAY-21\n<\/pre><\/div>\n\n\n<p>Recover:<\/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; RECOVER TABLESPACE &quot;CDB$ROOT&quot;:SYSTEM;\n \nStarting recover at 15-MAY-21\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n \nFinished recover at 15-MAY-21\n<\/pre><\/div>\n\n\n<p>Abrindo o banco:<\/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; ALTER DATABASE OPEN;\n \nStatement processed\n<\/pre><\/div>\n\n\n<p>Validando ambiente:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE;\n \nNAME      OPEN_MODE            CDB\n--------- -------------------- ---\nASWAN     READ WRITE           YES\n \nSQL&gt; ALTER SYSTEM CHECKPOINT;\n \nSystem altered.\n \nSQL&gt; SELECT NAME,OPEN_MODE FROM V$PDBS;\n \nNAME\n--------------------------------------------------------------------------------\nOPEN_MODE\n----------\nPDB$SEED\nREAD ONLY\n \nHIPOFISE1\nREAD WRITE\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>Coletando informa\u00e7\u00f5es do ambiente: Realizando backup do banco de dados: Removendo o datafile relacionado com a tablespace SYSTEM: Tentando realizar alguma opera\u00e7\u00e3o no banco, e percebendo que o mesmo j\u00e1 identifica o problema: Baixando inst\u00e2ncia e montando o banco de dados: Neste momento, vou simular o restore do banco todo do CDB$ROOT: Fazendo o Recover [&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,8],"tags":[],"class_list":["post-4646","post","type-post","status-publish","format-standard","hentry","category-backup-recovery","category-multitenant"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4646","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=4646"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4646\/revisions"}],"predecessor-version":[{"id":9136,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4646\/revisions\/9136"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}