How can i recover a Datafile corrupt data?

Question

Hello all, i expose the issue i have with an Oracle server recover: I use the rman to recover a Datafile into my oracle server and i start getting messages that some data can`t be read, then starts failoving in older backups searching for good versions of that data, but it seems that in all backups are the same corrupt data, and the recover fails. So the question is how can i backup all the Datafile including the corrupt data? Thanks.

atremols · Answer

I would investigate what is giving errors at NMO level before assuming that the data is corrupted,

Is this a directed recovery? recovering from a computer different to the one that did the backup?

Do you see tape errors on daemon.log or daemon.raw during the recover?

Are you able to scan the tape that contain the datafile without errors? That would tell you there is no physical corruption

HTH
Abdon

DavidHampson · Answer

I would echo Abdon's response here. NMO is notoriously prone to failure if the slightest thing is not correct. There is an off-chance that one backup may be corrupt but all backups being corrupt points to another issue. Examine the logs and look for error messages then search Powerlink to see if the issue has occurred before is a good start...

NetWorker

Was this post helpful?