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:

[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:

[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:

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:

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:

SQL> ALTER SESSION SET CONTAINER=HIPOFISE1;
 
Session altered.
 
SQL> ALTER PLUGGABLE DATABASE HIPOFISE1 DATAFILE 10 OFFLINE;
 
Pluggable database altered.

Fazendo seu restore e recover:

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:

SQL> ALTER SESSION SET CONTAINER=HIPOFISE1;
 
Session altered.
 
SQL> ALTER PLUGGABLE DATABASE DATAFILE 10 ONLINE;
 
Pluggable database altered.

Validado:

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:

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:

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:

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:

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:

SQL> ALTER SESSION SET CONTAINER=HIPOFISE1;
 
Session altered.
 
SQL> ALTER TABLESPACE SYSAUX ONLINE;
 
Tablespace altered.

Validando ambiente:

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