Performing RMAN Recovery from non-SYSTEM PDB Datafile Loss

Backup & Recovery, Multitenant / 13/07/2022

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.

Leave a Comment

Your email address will not be published.

pt Portuguese
en Englishpt Portuguesees Spanish