Pessoal, Estou tentando restaurar um database para coleta de evidencia de auditoria e no restore database estou recebendo este erro.
ORA-19870: error reading backup piece ORA_RA_MTZSVMBDOMAX01_MAXPROD_DIARIO_DBF<maxprod_20117:942396155:1>.dbf ORA-19502: write error on file "/d01/oradata/maxprod/maximo_index02.dbf", blockno 969249 (blocksize=8192) ORA-27072: File I/O error Linux-x86_64 Error: 9: Bad file descriptor Additional information: 4 Additional information: 969249 Additional information: 110592 failover to previous backup channel dev_0: starting datafile backupset restore channel dev_0: specifying datafile(s) to restore from backup set restoring datafile 00010 to /d01/oradata/maxprod/maximo_index02.dbf restoring datafile 00014 to /d01/oradata/maxprod/maximo_data05.dbf channel dev_0: reading from backup piece ORA_RA_MTZSVMBDOMAX01_MAXPROD_DIARIO_DBF<maxprod_20101:942361275:1>.dbf O backup é feito via Data Protector e neste momento eles esta tentando restaurar dois datafile de outra fita, estou aguardando a chegada desta fita para dar continuidade no restore. Passei um DBV nestes datafile no banco de produção e não encontrou nada corrompido. $ dbv file=/d01/oradata/maxprod/maximo_index02.dbf blocksize=8192 DBVERIFY: Release 10.2.0.4.0 - Production on Thu Apr 27 10:53:27 2017 Copyright (c) 1982, 2007, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = /d01/oradata/maxprod/maximo_index02.dbf DBVERIFY - Verification complete Total Pages Examined : 1280000 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 1271271 Total Pages Failing (Index): 0 Total Pages Processed (Other): 8408 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 321 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 823288003 (1684.823288003) $ dbv file=/d01/oradata/maxprod/maximo_data05.dbf blocksize=8192 DBVERIFY: Release 10.2.0.4.0 - Production on Thu Apr 27 11:01:23 2017 Copyright (c) 1982, 2007, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = /d01/oradata/maxprod/maximo_data05.dbf DBVERIFY - Verification complete Total Pages Examined : 1025280 Total Pages Processed (Data) : 634560 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 349120 Total Pages Failing (Index): 0 Total Pages Processed (Other): 38757 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 2843 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 828896000 (1684.828896000) SQL> select * from V$DATABASE_BLOCK_CORRUPTION; no rows selected Grato, Ednilson Silva
