Vamos simular aqui um problema com um datafile de “non-system” do PDB, recuper\u00e1-lo e normalizar o ambiente. Fazendo um backup dos bancos:<\/p>\n\n\n
\n[oracle@quiasma ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Mon May 17 04:31:01 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 17-MAY-21\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=85 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\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\ninput archived log thread=1 sequence=14 RECID=9 STAMP=1072586861\ninput archived log thread=1 sequence=15 RECID=10 STAMP=1072587344\ninput archived log thread=1 sequence=16 RECID=11 STAMP=1072756615\ninput archived log thread=1 sequence=17 RECID=12 STAMP=1072756632\ninput archived log thread=1 sequence=18 RECID=13 STAMP=1072757472\ninput archived log thread=1 sequence=19 RECID=14 STAMP=1072757489\ninput archived log thread=1 sequence=20 RECID=15 STAMP=1072758669\nchannel ORA_DISK_1: starting piece 1 at 17-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 17-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_17\/o1_mf_annnn_TAG20210517T043109_jb46xxm4_.bkp tag=TAG20210517T043109 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 17-MAY-21\n \nStarting backup at 17-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_j9yzl519_.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 17-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 17-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T043110_jb46xyrc_.bkp tag=TAG20210517T043110 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_jb463o46_.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 17-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 17-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T043110_jb46y5vl_.bkp tag=TAG20210517T043110 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 17-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 17-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/C2469670772D160AE0536A00A8C00FFA\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T043110_jb46y910_.bkp tag=TAG20210517T043110 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 17-MAY-21\n \nStarting backup at 17-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=21 RECID=16 STAMP=1072758684\nchannel ORA_DISK_1: starting piece 1 at 17-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 17-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/backupset\/2021_05_17\/o1_mf_annnn_TAG20210517T043124_jb46yd6o_.bkp tag=TAG20210517T043124 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 17-MAY-21\n \nStarting Control File and SPFILE Autobackup at 17-MAY-21\npiece handle=\/oracle\/fra\/ASWAN\/autobackup\/2021_05_17\/o1_mf_s_1072758685_jb46yfdo_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 17-MAY-21\n<\/pre><\/div>\n\n\nColetando informa\u00e7\u00f5es sobre o datafile:<\/p>\n\n\n
\n[oracle@quiasma ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Mon May 17 04:32:00 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 NAME,OPEN_MODE FROM V$PDBS;\n \nNAME\n--------------------------------------------------------------------------------\nOPEN_MODE\n----------\nPDB$SEED\nREAD ONLY\n \nHIPOFISE1\nREAD WRITE\n \n \nSQL> ALTER SESSION SET CONTAINER=HIPOFISE1;\n \nSession altered.\n \nSQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='SYSAUX';\n \nFILE_NAME\n--------------------------------------------------------------------------------\n\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcy\noh7_.dbf\n<\/pre><\/div>\n\n\nRemovendo o datafile:<\/p>\n\n\n
\nSQL> ! rm \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf;\n<\/pre><\/div>\n\n\nAp\u00f3s realizar um REPORT SCHEMA no RMAN, o Alert j\u00e1 come\u00e7a a reportar a falta do arquivo:<\/p>\n\n\n
\n2021-05-17 04:36:32.328000 -03:00\nErrors in file \/oracle\/18.0.0\/base\/diag\/rdbms\/aswan\/ASWAN\/trace\/ASWAN_mz00_3952.trc:\nORA-01110: data file 10: '\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf'\nORA-01565: error in identifying file '\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\n<\/pre><\/div>\n\n\nDeixando o datafile Offline:<\/p>\n\n\n
\nSQL> ALTER SESSION SET CONTAINER=HIPOFISE1;\n \nSession altered.\n \nSQL> ALTER PLUGGABLE DATABASE HIPOFISE1 DATAFILE 10 OFFLINE;\n \nPluggable database altered.\n<\/pre><\/div>\n\n\nFazendo seu restore e recover:<\/p>\n\n\n
\nRMAN> RESTORE DATAFILE 10;\n \nStarting restore at 17-MAY-21\nusing channel ORA_DISK_1\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 00010 to \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_j9wcyoh7_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T043110_jb46y5vl_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T043110_jb46y5vl_.bkp tag=TAG20210517T043110\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\nFinished restore at 17-MAY-21\n \nRMAN> RECOVER DATAFILE 10;\n \nStarting recover at 17-MAY-21\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:01\n \nFinished recover at 17-MAY-21\n<\/pre><\/div>\n\n\nDeixando o datafile online:<\/p>\n\n\n
\nSQL> ALTER SESSION SET CONTAINER=HIPOFISE1;\n \nSession altered.\n \nSQL> ALTER PLUGGABLE DATABASE DATAFILE 10 ONLINE;\n \nPluggable database altered.\n<\/pre><\/div>\n\n\nValidado:<\/p>\n\n\n
\nRMAN> 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---- -------- -------------------- ------- ------------------------\n1 970 SYSTEM YES \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yzl519_.dbf\n3 580 SYSAUX NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\n4 405 UNDOTBS1 YES \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc1bk9_.dbf\n5 390 PDB$SEED:SYSTEM NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wc9px6_.dbf\n6 360 PDB$SEED:SYSAUX NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc9px1_.dbf\n7 5 USERS NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_users_j9wc1clt_.dbf\n8 100 PDB$SEED:UNDOTBS1 NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc9px7_.dbf\n9 400 HIPOFISE1:SYSTEM YES \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_system_jb463o46_.dbf\n10 380 HIPOFISE1:SYSAUX NO \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47kxg9_.dbf\n11 100 HIPOFISE1:UNDOTBS1 YES \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_undotbs1_j9wcyoh8_.dbf\n12 100 HIPOFISE1:USERS NO \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_users_j9yz06wp_.dbf\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1 48 TEMP 32767 \/oracle\/dados\/ASWAN\/datafile\/o1_mf_temp_j9wc34wj_.tmp\n2 62 PDB$SEED:TEMP 32767 \/oracle\/dados\/ASWAN\/datafile\/temp012021-05-14_04-56-56-028-AM.dbf\n3 62 HIPOFISE1:TEMP 32767 \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_temp_j9wcyoh8_.dbf\n<\/pre><\/div>\n\n\nTamb\u00e9m podemos fazer essa recupera\u00e7\u00e3o pela tablespace, e n\u00e3o s\u00f3 pelo datafile. Realizei um novo backup do ambiente, e vou deletar novamente um datafile:<\/p>\n\n\n
\nSQL> ALTER SESSION SET CONTAINER=HIPOFISE1;\n \nSession altered.\n \nSQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='SYSAUX';\n \nFILE_NAME\n--------------------------------------------------------------------------------\n\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47k\nxg9_.dbf\n \n \nSQL> ! rm \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47kxg9_.dbf\n<\/pre><\/div>\n\n\nIdentifica\u00e7\u00e3o da situa\u00e7\u00e3o:<\/p>\n\n\n
\n2021-05-17 04:46:31.985000 -03:00\nErrors in file \/oracle\/18.0.0\/base\/diag\/rdbms\/aswan\/ASWAN\/trace\/ASWAN_mz00_4176.trc:\nORA-01110: data file 10: '\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47kxg9_.dbf'\nORA-01565: error in identifying file '\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47kxg9_.dbf'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\nChecker run found 1 new persistent data failures\n<\/pre><\/div>\n\n\nDeixando datafile offline:<\/p>\n\n\n
\nSQL> ALTER SESSION SET CONTAINER=HIPOFISE1;\n \nSession altered.\n \nSQL> ALTER TABLESPACE SYSAUX OFFLINE;\nALTER TABLESPACE SYSAUX OFFLINE\n*\nERROR at line 1:\nORA-01116: error in opening database file 10\nORA-01110: data file 10:\n'\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47\nkxg9_.dbf'\nORA-27041: unable to open file\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\n \n \nSQL> ALTER DATABASE HIPOFISE1 DATAFILE 10 OFFLINE;\n \nDatabase altered.\n<\/pre><\/div>\n\n\nFazendo restore\/recover:<\/p>\n\n\n
\nRMAN> RESTORE TABLESPACE HIPOFISE1:SYSAUX;\n \nStarting restore at 17-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=86 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 00010 to \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb47kxg9_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T044449_jb47qr9n_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/backupset\/2021_05_17\/o1_mf_nnndf_TAG20210517T044449_jb47qr9n_.bkp tag=TAG20210517T044449\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\nFinished restore at 17-MAY-21\n \nRMAN> RECOVER TABLESPACE HIPOFISE1:SYSAUX;\n \nStarting recover at 17-MAY-21\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n \nFinished recover at 17-MAY-21\n<\/pre><\/div>\n\n\nDeixando tablespace online:<\/p>\n\n\n
\nSQL> ALTER SESSION SET CONTAINER=HIPOFISE1;\n \nSession altered.\n \nSQL> ALTER TABLESPACE SYSAUX ONLINE;\n \nTablespace altered.\n<\/pre><\/div>\n\n\nValidando ambiente:<\/p>\n\n\n
\nRMAN> 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---- -------- -------------------- ------- ------------------------\n1 970 SYSTEM YES \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yzl519_.dbf\n3 580 SYSAUX NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\n4 405 UNDOTBS1 YES \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc1bk9_.dbf\n5 390 PDB$SEED:SYSTEM NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9wc9px6_.dbf\n6 360 PDB$SEED:SYSAUX NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wc9px1_.dbf\n7 5 USERS NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_users_j9wc1clt_.dbf\n8 100 PDB$SEED:UNDOTBS1 NO \/oracle\/dados\/ASWAN\/datafile\/o1_mf_undotbs1_j9wc9px7_.dbf\n9 400 HIPOFISE1:SYSTEM YES \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_system_jb463o46_.dbf\n10 380 HIPOFISE1:SYSAUX NO \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb487ow0_.dbf\n11 100 HIPOFISE1:UNDOTBS1 YES \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_undotbs1_j9wcyoh8_.dbf\n12 100 HIPOFISE1:USERS NO \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_users_j9yz06wp_.dbf\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1 48 TEMP 32767 \/oracle\/dados\/ASWAN\/datafile\/o1_mf_temp_j9wc34wj_.tmp\n2 62 PDB$SEED:TEMP 32767 \/oracle\/dados\/ASWAN\/datafile\/temp012021-05-14_04-56-56-028-AM.dbf\n3 62 HIPOFISE1:TEMP 32767 \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_temp_j9wcyoh8_.dbf\n \nRMAN> VALIDATE DATABASE;\n \nStarting validate at 17-MAY-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=73 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_j9yzl519_.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 16433 124161 2113115\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_system_j9yzl519_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 71652\n Index 0 12910\n Other 0 23165\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n3 OK 0 19387 74253 2113413\n File Name: \/oracle\/dados\/ASWAN\/datafile\/o1_mf_sysaux_j9wdsb2f_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 6391\n Index 0 3183\n Other 0 45279\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n4 OK 0 148 51840 2113413\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 51692\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_jb463o46_.dbf\ninput datafile file number=00010 name=\/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb487ow0_.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: 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 6419 51201 2113479\n File Name: \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_system_jb463o46_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 16435\n Index 0 8528\n Other 0 19818\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n10 OK 0 9815 48641 2113480\n File Name: \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_sysaux_jb487ow0_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 3852\n Index 0 2101\n Other 0 32872\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n11 OK 0 730 12801 2113480\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 12070\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n12 OK 0 1 12801 1897890\n File Name: \/oracle\/dados\/ASWAN\/C246BD61C42A1E80E0536A00A8C076F1\/datafile\/o1_mf_users_j9yz06wp_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 0\n Index 0 0\n Other 0 12799\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 17-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":"
Vamos simular aqui um problema com um datafile de “non-system” do PDB, recuper\u00e1-lo e normalizar o ambiente. Fazendo um backup dos bancos: Coletando informa\u00e7\u00f5es sobre o datafile: Removendo o datafile: Ap\u00f3s realizar um REPORT SCHEMA no RMAN, o Alert j\u00e1 come\u00e7a a reportar a falta do arquivo: Deixando o datafile Offline: Fazendo seu restore e […]<\/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-4680","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\/4680","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=4680"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4680\/revisions"}],"predecessor-version":[{"id":9134,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4680\/revisions\/9134"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}