Neste artigo, vamos simular uma situa\u00e7\u00e3o de recupera\u00e7\u00e3o de perda de datafile (non-system) na arquitetura Multitenant, especificamente no CDB$ROOT. Veremos que os comandos envolvidos e o mecanismo \u00e9 basicamente o mesmo para bancos non-cdb, o que \u00e9 muito bom pois preserva o conhecimento adquirado na arquitetura mais antiga.<\/p>\n\n\n\n
Conectando em nosso CDB$ROOT e coletando o datafile da tablespace SYSAUX:<\/p>\n\n\n
\n[oracle@quiasma ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Fri May 14 05:08:49 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> SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE;\n \nNAME OPEN_MODE CDB\n--------- -------------------- ---\nASWAN READ WRITE YES\n \nSQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='SYSAUX';\n \nFILE_NAME\n--------------------------------------------------------------------------------\n\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf\n<\/pre><\/div>\n\n\nRealizando um backup do banco de dados e seus archives:<\/p>\n\n\n
\n[oracle@quiasma ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri May 14 05:09:17 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> BACKUP DATABASE PLUS ARCHIVELOG;\n \n \nStarting backup at 14-MAY-21\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=67 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\nchannel ORA_DISK_1: starting piece 1 at 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_annnn_TAG20210514T050931_j9wd1vh1_.bkp tag=TAG20210514T050931 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 14-MAY-21\n \nStarting backup at 14-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_j9wc0kfz_.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 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T050932_j9wd1wpo_.bkp tag=TAG20210514T050932 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 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C2469670772D160AE0536A00A8C00FFA\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T050932_j9wd2cs7_.bkp tag=TAG20210514T050932 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\nchannel ORA_DISK_1: starting piece 1 at 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T050932_j9wd2lxq_.bkp tag=TAG20210514T050932 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\nFinished backup at 14-MAY-21\n \nStarting backup at 14-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=7 RECID=2 STAMP=1072501809\nchannel ORA_DISK_1: starting piece 1 at 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_annnn_TAG20210514T051010_j9wd323h_.bkp tag=TAG20210514T051010 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 14-MAY-21\n \nStarting Control File and SPFILE Autobackup at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/autobackup\/2021_05_14\/o1_mf_s_1072501811_j9wd33nj_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 14-MAY-21\n<\/pre><\/div>\n\n\nDeletando o datafile no Sistema Operacional:<\/p>\n\n\n
\nSQL> ! rm \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf\n \nSQL>\n<\/pre><\/div>\n\n\nUtilizando o RMAN, vamos tentar visualizar a falha. De in\u00edcio, o RMAN n\u00e3o a identifica, mas utilizando o comando validate datafile, prontamente a falha \u00e9 identificada:<\/p>\n\n\n
\n[oracle@quiasma ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri May 14 05:11:31 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> LIST FAILURE;\n \nusing target database control file instead of recovery catalog\nDatabase Role: PRIMARY\n \nno failures found that match specification\n \nRMAN> VALIDATE DATAFILE '\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf';\n \nStarting validate at 14-MAY-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=7 device type=DISK\nRMAN-06169: could not read file header for datafile 3 error reason 5\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of validate command at 05\/14\/2021 05:12:07\nRMAN-06056: could not access datafile 3\n \nRMAN> LIST FAILURE;\n \nDatabase Role: PRIMARY\n \nList of Database Failures\n=========================\n \nFailure ID Priority Status Time Detected Summary\n---------- -------- --------- ------------- -------\n122 HIGH OPEN 14-MAY-21 One or more non-system datafiles are missing\n \nRMAN> LIST FAILURE DETAIL;\n \nDatabase Role: PRIMARY\n \nList of Database Failures\n=========================\n \nFailure ID Priority Status Time Detected Summary\n---------- -------- --------- ------------- -------\n122 HIGH OPEN 14-MAY-21 One or more non-system datafiles are missing\n Impact: See impact for individual child failures\n List of child failures for parent failure ID 122\n Failure ID Priority Status Time Detected Summary\n ---------- -------- --------- ------------- -------\n 125 HIGH OPEN 14-MAY-21 Datafile 3: '\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf' is missing\n Impact: Some objects in tablespace SYSAUX might be unavailable\n<\/pre><\/div>\n\n\nAo tentar visualizar a sugest\u00e3o dada pelo Data Recovery Advisor, um erro interno \u00e9 reportado. Como estou com o \u00faltimo PSU j\u00e1 aplicado (18.13), n\u00e3o consegui identificar algum Oracle Note com workaround ou patch espec\u00edfico para o caso. Assim, continuarei a recupera\u00e7\u00e3o do ambiente na forma tradicional: manualmente.<\/p>\n\n\n
\nRMAN> ADVISE FAILURE;\n \nDatabase Role: PRIMARY\n \nList of Database Failures\n=========================\n \nFailure ID Priority Status Time Detected Summary\n---------- -------- --------- ------------- -------\n122 HIGH OPEN 14-MAY-21 One or more non-system datafiles are missing\n Impact: See impact for individual child failures\n List of child failures for parent failure ID 122\n Failure ID Priority Status Time Detected Summary\n ---------- -------- --------- ------------- -------\n 125 HIGH OPEN 14-MAY-21 Datafile 3: '\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf' is missing\n Impact: Some objects in tablespace SYSAUX might be unavailable\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-00601: fatal error in recovery manager\nRMAN-03012: fatal error during compilation of command\nRMAN-03028: fatal error code for command advise : 600\nRMAN-00600: internal error, arguments [15077] [TEXTNOD] [588] [] []\n<\/pre><\/div>\n\n\nDeixando o datafile offline:<\/p>\n\n\n
\nRMAN> ALTER DATABASE DATAFILE '\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf' OFFLINE;\n \nusing target database control file instead of recovery catalog\nStatement processed\n<\/pre><\/div>\n\n\nRealizando o seu restore e recover:<\/p>\n\n\n
\nRMAN> RESTORE DATAFILE '\/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf';\n \nStarting restore at 14-MAY-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=82 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 00003 to \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc0kfz_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T050932_j9wd1wpo_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T050932_j9wd1wpo_.bkp tag=TAG20210514T050932\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:07\nFinished restore at 14-MAY-21\n \nRMAN> RECOVER DATAFILE 3;\n \nStarting recover at 14-MAY-21\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n \nFinished recover at 14-MAY-21\n<\/pre><\/div>\n\n\nDeixando o datafile online novamente:<\/p>\n\n\n
\nRMAN> ALTER DATABASE DATAFILE 3 ONLINE;\n \nusing target database control file instead of recovery catalog\nStatement processed\n<\/pre><\/div>\n\n\nValidando o banco de dados todo:<\/p>\n\n\n
\nRMAN> VALIDATE DATABASE;\n \nStarting validate at 14-MAY-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=68 device type=DISK\nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\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: validation complete, elapsed time: 00:00:03\nList of Datafiles\n=================\nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n1 OK 0 17473 124160 1694613\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wbzgc1_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 71640\n Index 0 12906\n Other 0 22141\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n3 OK 0 18739 69130 1695121\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 5724\n Index 0 2927\n Other 0 41730\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n4 OK 0 532 51840 1695121\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc1bk9_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 0\n Index 0 0\n Other 0 51308\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n7 OK 0 1 641 29088\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_users_j9wc1clt_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 0\n Index 0 0\n Other 0 639\n \nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\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: validation complete, elapsed time: 00:00:01\nList of Datafiles\n=================\nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n5 OK 0 6337 49920 1692303\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wc9px6_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 16430\n Index 0 8508\n Other 0 18645\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n6 OK 0 10021 46080 1691710\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc9px1_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 3799\n Index 0 2091\n Other 0 30169\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n8 OK 0 1879 12800 1692301\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc9px7_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 0\n Index 0 0\n Other 0 10921\n \nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\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: validation complete, elapsed time: 00:00:01\nList of Datafiles\n=================\nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n9 OK 0 6337 49920 1693687\n File Name: \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_system_j9wcyoh3_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 16430\n Index 0 8508\n Other 0 18645\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n10 OK 0 10021 46080 1691710\n File Name: \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 3799\n Index 0 2091\n Other 0 30169\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n11 OK 0 1879 12800 1692301\n File Name: \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_undotbs1_j9wcyoh8_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 0\n Index 0 0\n Other 0 10921\n \nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\nincluding current control file for validation\nincluding current SPFILE in backup set\nchannel ORA_DISK_1: validation complete, elapsed time: 00:00:01\nList of Control File and SPFILE\n===============================\nFile Type Status Blocks Failing Blocks Examined\n------------ ------ -------------- ---------------\nSPFILE OK 0 2\nControl File OK 0 1142\nFinished validate at 14-MAY-21\n<\/pre><\/div>\n\n\nNenhuma falha \u00e9 reportada no RMAN, e j\u00e1 podemos realizar um backup full do banco (esse \u00e9 o procedimento indicado para ambientes corporativos que tenham sofrido restore\/recover):<\/p>\n\n\n
\nRMAN> LIST FAILURE;\n \nDatabase Role: PRIMARY\n \nno failures found that match specification\n \nRMAN> BACKUP DATABASE PLUS ARCHIVELOG;\n \n \nStarting backup at 14-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\nchannel ORA_DISK_1: starting piece 1 at 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_annnn_TAG20210514T053610_j9wfmtq8_.bkp tag=TAG20210514T053610 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 14-MAY-21\n \nStarting backup at 14-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 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T053613_j9wfmxxo_.bkp tag=TAG20210514T053613 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=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 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C2469670772D160AE0536A00A8C00FFA\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T053613_j9wfn525_.bkp tag=TAG20210514T053613 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\nchannel ORA_DISK_1: starting piece 1 at 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_14\/o1_mf_nnndf_TAG20210514T053613_j9wfnd60_.bkp tag=TAG20210514T053613 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\nFinished backup at 14-MAY-21\n \nStarting backup at 14-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=9 RECID=4 STAMP=1072503403\nchannel ORA_DISK_1: starting piece 1 at 14-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_14\/o1_mf_annnn_TAG20210514T053643_j9wfnvd0_.bkp tag=TAG20210514T053643 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 14-MAY-21\n \nStarting Control File and SPFILE Autobackup at 14-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/autobackup\/2021_05_14\/o1_mf_s_1072503404_j9wfnwmn_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 14-MAY-21\n<\/pre><\/div>\n\n\nObs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"
Neste artigo, vamos simular uma situa\u00e7\u00e3o de recupera\u00e7\u00e3o de perda de datafile (non-system) na arquitetura Multitenant, especificamente no CDB$ROOT. Veremos que os comandos envolvidos e o mecanismo \u00e9 basicamente o mesmo para bancos non-cdb, o que \u00e9 muito bom pois preserva o conhecimento adquirado na arquitetura mais antiga. Conectando em nosso CDB$ROOT e coletando o […]<\/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-4585","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\/4585","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=4585"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4585\/revisions"}],"predecessor-version":[{"id":9138,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4585\/revisions\/9138"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}