Forum Post: Question concerning scripting a progress restore - getting CRC error (1147)

Status
Not open for further replies.
S

sseney

Guest
We're running OE 10.2b04 on SuSe Linux - enterprise DB lic - char only. I created a script that will run from cron - to restore selected DBs to a "testing" location after the nightly full progress backup. I was testing the script and all was running good until it got to one of the DB backup files. it started to throw the CRC error 1147. I know what that means, but the odd thing is for the date of that backup file - the prorest -vm and prorest -vf showed NO issues. [2014/06/17@13:11:29.161-0400] P-24485 T-2092578560 I : (12854) Restoring database from /marcs/clsbi/marccls.db. [2014/06/17@13:11:41.905-0400] P-24485 T-2092578560 I : (1147) CRC check error reading backup block 2707 [2014/06/17@13:11:41.907-0400] P-24485 T-2092578560 I : (1147) CRC check error reading backup block 2708 [2014/06/17@13:11:41.912-0400] P-24485 T-2092578560 I : (1147) CRC check error reading backup block 2709 First - the backup file of this DB is 5 days old. Below is the output showing that it appears to have completed cleanly: ******** BACKUP of marccls started Thu Jun 12 01:59:38 EDT 2014 289159 active blocks out of 485913 blocks in /marcs/clsbi/marccls will be dumped. (6686) 0 BI blocks will be dumped. (6688) The blocksize is 8192. (6994) Backup requires an estimated 878.5 MBytes of media. (9285) Restore would require an estimated 289159 db blocks using 2.2 GBytes of media. (9286) Backed up 289170 db blocks in 00:00:17 Wrote a total of 3310 backup blocks using 879.2 MBytes of media. (13625) Backup complete. (3740) This is a full backup of /marcs/clsbi/marccls.db. (6759) This backup was taken Thu Jun 12 01:59:39 2014. (6760) The blocksize is 8192. (6994) Partial verification successfully read backup volume. (6765) Verify pass started. (3751) Verified 289170 db blocks in 04:43:44 Backup for /marcs/clsbi/marccls.db verified ok. (6758) This is a full backup of /marcs/clsbi/marccls.db. (6759) This backup was taken Thu Jun 12 01:59:39 2014. (6760) The blocksize is 8192. (6994) It will require a minimum of 485913 blocks to restore. (6763) Full verify pass started. (3752) Verified 289170 db blocks in 00:00:07 Full verify successful. (3758) BACKUP of marccls completed Thu Jun 12 06:44:43 EDT 2014 OpenEdge Release 10.2B04 as of Thu Mar 3 19:15:28 EST 2011 On 6/12/14 we had an issue with the VM disk space filling up, stalling all our processes - including the progress backups Once our SA allocated more disk space - the VM backups continued on and the system was available again. I don't fully understand why if the check of the backup on the day of the backup was clean, that it would now throw CRC errors. We will be backing up our DBs again tonight as full backups - so I expect that this issue will resolve itself. If anyone might have some thoughts on why this would/could happen, that would be helpful.

Continue reading...
 
Status
Not open for further replies.
Top