WE got the following Message at halfway of restoring. One of the Backup Piece on Tape is showing a Corruption.
channel t4: reading from backup piece TPRP5_195_1_600973281_rman.bk
ORA-19870: error reading backup piece TPRP5_198_1_600973281_rman.bk
ORA-19599: block number 702316 is corrupt in backup piece TPRP5_198_1_600973281_rman.bk
We were unable to restored a database last week using TSM (we lost the entire week trying to restore it using TSM). We needed two days of manual copying (over the weekend) to be able to complete the restore. Clearly, this is not what we want to do when restoring a database. Unfortunately, restoring databases is one activity that we do often an we expect to complete it within hours (not days). As our User batch process and the new CTW refresh testing become more active we will need the TSM restore to work. Please advise on how this problem can be fixed. Thanks - RCM
channel t4: reading from backup piece TPRP5_195_1_600973281_rman.bk
ORA-19870: error reading backup piece TPRP5_198_1_600973281_rman.bk
ORA-19599: block number 702316 is corrupt in backup piece TPRP5_198_1_600973281_rman.bk
We were unable to restored a database last week using TSM (we lost the entire week trying to restore it using TSM). We needed two days of manual copying (over the weekend) to be able to complete the restore. Clearly, this is not what we want to do when restoring a database. Unfortunately, restoring databases is one activity that we do often an we expect to complete it within hours (not days). As our User batch process and the new CTW refresh testing become more active we will need the TSM restore to work. Please advise on how this problem can be fixed. Thanks - RCM