Datafile con sectores dañados
Hola tengo un problema con mi base de datos lo que paso es que intente clonarla y me genero una carpeta con los datafiles pero luego los borre y cuando ejecuto el siguiente comando me salta lo siguiente:
dbv file=C:\ORACLE\DATOS\SERVERORACLE\SYSAUX01.DBF feedback=10000 blocksize=8192
Page 63823 is influx – most likely media corrupt
Corrupt block relative dba: 0x0080f94f (file 2, block 63823)
Fractured block found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x0080f94f
last change scn: 0x0000.007552a3 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xcb4b0601
check value in block header: 0x51ac
computed block checksum: 0x99e8
Page 63831 is influx – most likely media corrupt
Corrupt block relative dba: 0x0080f957 (file 2, block 63831)
Fractured block found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x0080f957
last change scn: 0x0000.00782940 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x3e480601
check value in block header: 0xc3a
computed block checksum: 0x970c
y un largo etc.
Luego intento ejecutar blockrecover datafile 2 block 72819;
RMAN> blockrecover datafile 2 block 72819;
Starting recover at 14-JAN-14
using channel ORA_DISK_1
channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00002
channel ORA_DISK_1: reading from backup piece D:\ZONA_INTERMEDIA\SERVERORACLE_42
\DATAFILE_BACKUP_2
channel ORA_DISK_1: ORA-19870: error while restoring backup piece D:\ZONA_INTERM
EDIA\SERVERORACLE_42\DATAFILE_BACKUP_2
ORA-19505: failed to identify file «D:\ZONA_INTERMEDIA\SERVERORACLE_42\DATAFILE_
BACKUP_2»
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) El sistema no puede encontrar la ruta especificada.
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/14/2014 11:48:41
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN>
Y asi con todos los bloques, como podria correguir este problema.
por que obviamente no tengo dicha carpeta que exige