Vamos simular aqui um problema com um datafile de “non-system” do PDB, recuperá-lo e normalizar o ambiente. Fazendo um backup dos bancos:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 | [oracle@quiasma ~]$ rman target / Recovery Manager: Release 18.0.0.0.0 - Production on Mon May 17 04:31:01 2021 Version 18.13.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. connected to target database: ASWAN (DBID=1340416544) RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Starting backup at 17-MAY-21 current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=85 device type=DISK channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=6 RECID=1 STAMP=1072501770 input archived log thread=1 sequence=7 RECID=2 STAMP=1072501809 input archived log thread=1 sequence=8 RECID=3 STAMP=1072503370 input archived log thread=1 sequence=9 RECID=4 STAMP=1072503403 input archived log thread=1 sequence=10 RECID=5 STAMP=1072586228 input archived log thread=1 sequence=11 RECID=6 STAMP=1072586257 input archived log thread=1 sequence=12 RECID=7 STAMP=1072586635 input archived log thread=1 sequence=13 RECID=8 STAMP=1072586846 input archived log thread=1 sequence=14 RECID=9 STAMP=1072586861 input archived log thread=1 sequence=15 RECID=10 STAMP=1072587344 input archived log thread=1 sequence=16 RECID=11 STAMP=1072756615 input archived log thread=1 sequence=17 RECID=12 STAMP=1072756632 input archived log thread=1 sequence=18 RECID=13 STAMP=1072757472 input archived log thread=1 sequence=19 RECID=14 STAMP=1072757489 input archived log thread=1 sequence=20 RECID=15 STAMP=1072758669 channel ORA_DISK_1: starting piece 1 at 17-MAY-21 channel ORA_DISK_1: finished piece 1 at 17-MAY-21 piece handle=/oracle/fra/ASWAN/backupset/2021_05_17/o1_mf_annnn_TAG20210517T043109_jb46xxm4_.bkp tag=TAG20210517T043109 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 17-MAY-21 Starting backup at 17-MAY-21 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/oracle/dados/ASWAN/datafile/o1_mf_system_j9yzl519_.dbf input datafile file number=00003 name=/oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wdsb2f_.dbf input datafile file number=00004 name=/oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc1bk9_.dbf input datafile file number=00007 name=/oracle/dados/ASWAN/datafile/o1_mf_users_j9wc1clt_.dbf channel ORA_DISK_1: starting piece 1 at 17-MAY-21 channel ORA_DISK_1: finished piece 1 at 17-MAY-21 piece handle=/oracle/fra/ASWAN/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T043110_jb46xyrc_.bkp tag=TAG20210517T043110 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_system_jb463o46_.dbf input datafile file number=00010 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_j9wcyoh7_.dbf input datafile file number=00011 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_undotbs1_j9wcyoh8_.dbf input datafile file number=00012 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_users_j9yz06wp_.dbf channel ORA_DISK_1: starting piece 1 at 17-MAY-21 channel ORA_DISK_1: finished piece 1 at 17-MAY-21 piece handle=/oracle/fra/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T043110_jb46y5vl_.bkp tag=TAG20210517T043110 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/oracle/dados/ASWAN/datafile/o1_mf_system_j9wc9px6_.dbf input datafile file number=00006 name=/oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wc9px1_.dbf input datafile file number=00008 name=/oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc9px7_.dbf channel ORA_DISK_1: starting piece 1 at 17-MAY-21 channel ORA_DISK_1: finished piece 1 at 17-MAY-21 piece handle=/oracle/fra/ASWAN/C2469670772D160AE0536A00A8C00FFA/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T043110_jb46y910_.bkp tag=TAG20210517T043110 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 17-MAY-21 Starting backup at 17-MAY-21 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=21 RECID=16 STAMP=1072758684 channel ORA_DISK_1: starting piece 1 at 17-MAY-21 channel ORA_DISK_1: finished piece 1 at 17-MAY-21 piece handle=/oracle/fra/ASWAN/backupset/2021_05_17/o1_mf_annnn_TAG20210517T043124_jb46yd6o_.bkp tag=TAG20210517T043124 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 17-MAY-21 Starting Control File and SPFILE Autobackup at 17-MAY-21 piece handle=/oracle/fra/ASWAN/autobackup/2021_05_17/o1_mf_s_1072758685_jb46yfdo_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 17-MAY-21 |
Coletando informações sobre o datafile:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | [oracle@quiasma ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 - Production on Mon May 17 04:32:00 2021 Version 18.13.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.13.0.0.0 SQL> SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE; NAME OPEN_MODE CDB --------- -------------------- --- ASWAN READ WRITE YES SQL> SELECT NAME,OPEN_MODE FROM V$PDBS; NAME -------------------------------------------------------------------------------- OPEN_MODE ---------- PDB$SEED READ ONLY HIPOFISE1 READ WRITE SQL> ALTER SESSION SET CONTAINER=HIPOFISE1; Session altered. SQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='SYSAUX'; FILE_NAME -------------------------------------------------------------------------------- /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_j9wcy oh7_.dbf |
Removendo o datafile:
1 | SQL> ! rm /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_j9wcyoh7_.dbf; |
Após realizar um REPORT SCHEMA no RMAN, o Alert já começa a reportar a falta do arquivo:
1 2 3 4 5 6 7 | 2021-05-17 04:36:32.328000 -03:00 Errors in file /oracle/18.0.0/base/diag/rdbms/aswan/ASWAN/trace/ASWAN_mz00_3952.trc: ORA-01110: data file 10: '/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_j9wcyoh7_.dbf' ORA-01565: error in identifying file '/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_j9wcyoh7_.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 |
Deixando o datafile Offline:
1 2 3 4 5 6 7 | SQL> ALTER SESSION SET CONTAINER=HIPOFISE1; Session altered. SQL> ALTER PLUGGABLE DATABASE HIPOFISE1 DATAFILE 10 OFFLINE; Pluggable database altered. |
Fazendo seu restore e recover:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | RMAN> RESTORE DATAFILE 10; Starting restore at 17-MAY-21 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00010 to /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_j9wcyoh7_.dbf channel ORA_DISK_1: reading from backup piece /oracle/fra/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T043110_jb46y5vl_.bkp channel ORA_DISK_1: piece handle=/oracle/fra/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T043110_jb46y5vl_.bkp tag=TAG20210517T043110 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Finished restore at 17-MAY-21 RMAN> RECOVER DATAFILE 10; Starting recover at 17-MAY-21 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:01 Finished recover at 17-MAY-21 |
Deixando o datafile online:
1 2 3 4 5 6 7 | SQL> ALTER SESSION SET CONTAINER=HIPOFISE1; Session altered. SQL> ALTER PLUGGABLE DATABASE DATAFILE 10 ONLINE; Pluggable database altered. |
Validado:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | RMAN> REPORT SCHEMA; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name ASWAN List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 970 SYSTEM YES /oracle/dados/ASWAN/datafile/o1_mf_system_j9yzl519_.dbf 3 580 SYSAUX NO /oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wdsb2f_.dbf 4 405 UNDOTBS1 YES /oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc1bk9_.dbf 5 390 PDB$SEED:SYSTEM NO /oracle/dados/ASWAN/datafile/o1_mf_system_j9wc9px6_.dbf 6 360 PDB$SEED:SYSAUX NO /oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wc9px1_.dbf 7 5 USERS NO /oracle/dados/ASWAN/datafile/o1_mf_users_j9wc1clt_.dbf 8 100 PDB$SEED:UNDOTBS1 NO /oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc9px7_.dbf 9 400 HIPOFISE1:SYSTEM YES /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_system_jb463o46_.dbf 10 380 HIPOFISE1:SYSAUX NO /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47kxg9_.dbf 11 100 HIPOFISE1:UNDOTBS1 YES /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_undotbs1_j9wcyoh8_.dbf 12 100 HIPOFISE1:USERS NO /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_users_j9yz06wp_.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 48 TEMP 32767 /oracle/dados/ASWAN/datafile/o1_mf_temp_j9wc34wj_.tmp 2 62 PDB$SEED:TEMP 32767 /oracle/dados/ASWAN/datafile/temp012021-05-14_04-56-56-028-AM.dbf 3 62 HIPOFISE1:TEMP 32767 /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_temp_j9wcyoh8_.dbf |
Também podemos fazer essa recuperação pela tablespace, e não só pelo datafile. Realizei um novo backup do ambiente, e vou deletar novamente um datafile:
1 2 3 4 5 6 7 8 9 10 11 12 13 | SQL> ALTER SESSION SET CONTAINER=HIPOFISE1; Session altered. SQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='SYSAUX'; FILE_NAME -------------------------------------------------------------------------------- /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47k xg9_.dbf SQL> ! rm /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47kxg9_.dbf |
Identificação da situação:
1 2 3 4 5 6 7 8 | 2021-05-17 04:46:31.985000 -03:00 Errors in file /oracle/18.0.0/base/diag/rdbms/aswan/ASWAN/trace/ASWAN_mz00_4176.trc: ORA-01110: data file 10: '/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47kxg9_.dbf' ORA-01565: error in identifying file '/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47kxg9_.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 Checker run found 1 new persistent data failures |
Deixando datafile offline:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | SQL> ALTER SESSION SET CONTAINER=HIPOFISE1; Session altered. SQL> ALTER TABLESPACE SYSAUX OFFLINE; ALTER TABLESPACE SYSAUX OFFLINE * ERROR at line 1: ORA-01116: error in opening database file 10 ORA-01110: data file 10: '/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47 kxg9_.dbf' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL> ALTER DATABASE HIPOFISE1 DATAFILE 10 OFFLINE; Database altered. |
Fazendo restore/recover:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | RMAN> RESTORE TABLESPACE HIPOFISE1:SYSAUX; Starting restore at 17-MAY-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=86 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00010 to /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb47kxg9_.dbf channel ORA_DISK_1: reading from backup piece /oracle/fra/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T044449_jb47qr9n_.bkp channel ORA_DISK_1: piece handle=/oracle/fra/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/backupset/2021_05_17/o1_mf_nnndf_TAG20210517T044449_jb47qr9n_.bkp tag=TAG20210517T044449 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 17-MAY-21 RMAN> RECOVER TABLESPACE HIPOFISE1:SYSAUX; Starting recover at 17-MAY-21 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:00 Finished recover at 17-MAY-21 |
Deixando tablespace online:
1 2 3 4 5 6 7 | SQL> ALTER SESSION SET CONTAINER=HIPOFISE1; Session altered. SQL> ALTER TABLESPACE SYSAUX ONLINE; Tablespace altered. |
Validando ambiente:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 | RMAN> REPORT SCHEMA; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name ASWAN List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 970 SYSTEM YES /oracle/dados/ASWAN/datafile/o1_mf_system_j9yzl519_.dbf 3 580 SYSAUX NO /oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wdsb2f_.dbf 4 405 UNDOTBS1 YES /oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc1bk9_.dbf 5 390 PDB$SEED:SYSTEM NO /oracle/dados/ASWAN/datafile/o1_mf_system_j9wc9px6_.dbf 6 360 PDB$SEED:SYSAUX NO /oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wc9px1_.dbf 7 5 USERS NO /oracle/dados/ASWAN/datafile/o1_mf_users_j9wc1clt_.dbf 8 100 PDB$SEED:UNDOTBS1 NO /oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc9px7_.dbf 9 400 HIPOFISE1:SYSTEM YES /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_system_jb463o46_.dbf 10 380 HIPOFISE1:SYSAUX NO /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb487ow0_.dbf 11 100 HIPOFISE1:UNDOTBS1 YES /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_undotbs1_j9wcyoh8_.dbf 12 100 HIPOFISE1:USERS NO /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_users_j9yz06wp_.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 48 TEMP 32767 /oracle/dados/ASWAN/datafile/o1_mf_temp_j9wc34wj_.tmp 2 62 PDB$SEED:TEMP 32767 /oracle/dados/ASWAN/datafile/temp012021-05-14_04-56-56-028-AM.dbf 3 62 HIPOFISE1:TEMP 32767 /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_temp_j9wcyoh8_.dbf RMAN> VALIDATE DATABASE; Starting validate at 17-MAY-21 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=73 device type=DISK channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00001 name=/oracle/dados/ASWAN/datafile/o1_mf_system_j9yzl519_.dbf input datafile file number=00003 name=/oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wdsb2f_.dbf input datafile file number=00004 name=/oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc1bk9_.dbf input datafile file number=00007 name=/oracle/dados/ASWAN/datafile/o1_mf_users_j9wc1clt_.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:03 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 1 OK 0 16433 124161 2113115 File Name: /oracle/dados/ASWAN/datafile/o1_mf_system_j9yzl519_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 71652 Index 0 12910 Other 0 23165 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 3 OK 0 19387 74253 2113413 File Name: /oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wdsb2f_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 6391 Index 0 3183 Other 0 45279 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 4 OK 0 148 51840 2113413 File Name: /oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc1bk9_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 51692 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 7 OK 0 1 641 29088 File Name: /oracle/dados/ASWAN/datafile/o1_mf_users_j9wc1clt_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 639 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00005 name=/oracle/dados/ASWAN/datafile/o1_mf_system_j9wc9px6_.dbf input datafile file number=00006 name=/oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wc9px1_.dbf input datafile file number=00008 name=/oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc9px7_.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 5 OK 0 6337 49920 1692303 File Name: /oracle/dados/ASWAN/datafile/o1_mf_system_j9wc9px6_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 16430 Index 0 8508 Other 0 18645 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 6 OK 0 10021 46080 1691710 File Name: /oracle/dados/ASWAN/datafile/o1_mf_sysaux_j9wc9px1_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 3799 Index 0 2091 Other 0 30169 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 8 OK 0 1879 12800 1692301 File Name: /oracle/dados/ASWAN/datafile/o1_mf_undotbs1_j9wc9px7_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 10921 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00009 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_system_jb463o46_.dbf input datafile file number=00010 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb487ow0_.dbf input datafile file number=00011 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_undotbs1_j9wcyoh8_.dbf input datafile file number=00012 name=/oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_users_j9yz06wp_.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 9 OK 0 6419 51201 2113479 File Name: /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_system_jb463o46_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 16435 Index 0 8528 Other 0 19818 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 10 OK 0 9815 48641 2113480 File Name: /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_sysaux_jb487ow0_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 3852 Index 0 2101 Other 0 32872 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 11 OK 0 730 12801 2113480 File Name: /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_undotbs1_j9wcyoh8_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 12070 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 12 OK 0 1 12801 1897890 File Name: /oracle/dados/ASWAN/C246BD61C42A1E80E0536A00A8C076F1/datafile/o1_mf_users_j9yz06wp_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 12799 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation including current control file for validation including current SPFILE in backup set channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Control File and SPFILE =============================== File Type Status Blocks Failing Blocks Examined ------------ ------ -------------- --------------- SPFILE OK 0 2 Control File OK 0 1142 Finished validate at 17-MAY-21 |
Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laboratório pessoal para fins de aprendizado.