Veritas-bu

[Veritas-bu] Catalogue Corruption Cleanup Script

2005-02-04 01:58:52
Subject: [Veritas-bu] Catalogue Corruption Cleanup Script
From: Tim.Uidam AT rabobank DOT com (Uidam, T (Tim))
Date: Fri, 4 Feb 2005 17:58:52 +1100
This is a multi-part message in MIME format.

------_=_NextPart_001_01C50A86.FC898B8E
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Guys,
I've bashed together a little windows script to automatically search
(and optionally destroy) any invalid or corrupt images or "files files"
if your catalogue gets corrupt for any reason. (A common reason is
running out of disk space on the NBU Catalogue drive!)

First up, you'll need to find a copy of GNU Grep (I've used v2.0b from
http://www.interlog.com/~tcharron/grep.html).

Save the attached txt file to any folder and rename to *.bat. Copy
grep.exe to the same folder.

There are a couple of lines in the script that you need to change to
suit your local environment.
Line 19, change the path to the folder where you extracted the attached
zip file.
Line 21, change to the correct Drive letter holding the NBU Catalogue.
Line 33, change to the correct path for BPDBM.exe

Change these lines to alter the behaviour of the script.
Line 45, rem it out to work from the existing Catalogue extract file, or
leave it in to run a new extract.
Line 98, rem it out to auto-delete any bad images that are found, or
leave the rem in to skip the deletion. The default is to just report the
bad images to a text file.

Feel free to use the script as you see fit, it's now public domain.
However, the standard disclaimer applies: Although this script has been
tested in my environment, I bear no responsibility for any damage caused
to your system(s) by use of this script or instructions. THIS SCRIPT CAN
BE DESTRUCTIVE! You use this script and instructions at your own risk.
You're a data administrator for crying-out-loud, use some common-sense!
:)

Am happy to take feedback or bug-fixes.
Have a great weekend.
Tim.






_____________________________________________________________

This email, including any attachments, may be confidential or privileged,=
=20and is sent for the personal attention of the intended recipient.  If =
you have received this email in error, please delete it immediately.  The=
=20views expressed are not necessarily those of the Rabobank Group.  The =
Group is not liable for the effects of any virus which may be contained i=
n this email.
_____________________________________________________________

------_=_NextPart_001_01C50A86.FC898B8E
Content-Type: text/plain;
        name="CleanImages.txt"
Content-Transfer-Encoding: base64
Content-Description: CleanImages.txt
Content-Disposition: attachment;
        filename="CleanImages.txt"

QGVjaG8gb2ZmDQo6Oj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQo6Og0KOjogTkFNRTogPENsZWFuSW1hZ2Vz
LmJhdD4NCjo6DQo6OiBBVVRIT1I6IFRpbSBVaWRhbSwgUmFib2JhbmsgT0MNCjo6DQo6OiBDcmVh
dGVkOiBNaWQgMjAwNA0KOjogTGFzdCBNb2QgRGF0ZTogMjAvMDEvMjAwNQ0KOjoNCjo6IENoYW5n
ZSBMb2c6DQo6OiB2MS4wOyA/Py8/Py8yMDA0OwlUaW0gVWlkYW07CVNjcmlwdCBzdGFydGVkICYg
cGFydGlhbGx5IHRlc3RlZA0KOjogdjIuMDsgMDcvMDEvMjAwNTsJVGltIFVpZGFtOwlTY3JpcHQg
ZmluaXNoZWQgJiB0ZXN0ZWQgaW4gcHJvZA0KOjogdjIuMC4xOyAyMC8wMS8yMDA1OwlUaW0gVWlk
YW07CUFkZGVkIGNvbW1lbnRzICYgc2NyaXB0IGhlYWRlcg0KOjoNCjo6PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT0NCg0KY2xzDQpTZXQgV29ya2luZ0Rpcj1EOlxDbGVhbkltYWdlcw0KOjogTmV0YmFja3VwIERh
dGFiYXNlIERyaXZlDQpTRVQgTkJVREJEcnY9RToNCg0KU2V0IFJ1bm5pbmdMb2c9JVdPUktJTkdE
SVIlXFJ1bm5pbmcubG9nDQpTZXQgU3VjY2Vzc0xvZz0lV09SS0lOR0RJUiVcU3VjY2Vzcy5sb2cN
ClNldCBGYWlsdXJlTG9nPSVXT1JLSU5HRElSJVxGYWlsdXJlLmxvZw0KU2V0IE9mZkxvZz0lV09S
S0lOR0RJUiVcT2ZmLmxvZw0KU2V0IENhdENvbnNMb2c9JVdPUktJTkdESVIlXENhdENvbnNpc3Rl
bmN5LmxvZw0KU2V0IFRlbXBfQmFkSW1hZ2VzX3J1bm5pbmc9JVdPUktJTkdESVIlXFRlbXBfQmFk
SW1hZ2VzX3J1bm5pbmcubG9nDQpARUNITy4gPiVXT1JLSU5HRElSJVxDbGVhbl9CYWRIZWFkZXJz
LnR4dA0KQEVDSE8uID4lV09SS0lOR0RJUiVcQ2xlYW5fTm9uSW1hZ2VzLnR4dA0KDQo6OiBQbGVh
c2UgY2hlY2sgdGhpcyBsb2NhdGlvbiBpcyBjb3JyZWN0LCBhbmQgYW1tZW5kIGhlcmUgYXMgYXBw
cm9wcmlhdGUuDQpzZXQgYnBkYm09RTpcVkVSSVRBU1xOZXRCYWNrdXBcYmluXGJwZGJtLmV4ZQ0K
c2V0IEdyZXA9JVdPUktJTkdESVIlXEdyZXAuZXhlDQoNCjo6IFJ1biBDYXRhbG9ndWUgQ29uc2lz
dGVuY3kgQ2hlY2sgdG8gZmluZCBiYWQgaW1hZ2VzLg0KQEVjaG8uDQpARUNITyBSdW5uaW5nIENh
dGFsb2d1ZSBDb25zaXN0ZW5jeSBDaGVjay4NCkBFQ0hPIFBsZWFzZSB3YWl0LCB0aGlzIHdpbGwg
dGFrZSBhdCBsZWFzdCAzMG1pbnMuDQpARUNITyBZb3UgY2FuIHZpZXcgdGhlIHByb2dyZXNzIGJ5
IGxvb2tpbmcgaW4gdGhlDQpARUNITyBbJUNhdENvbnNMb2clXSBmaWxlLg0KQEVjaG8uDQolYnBk
Ym0lIC1jb25zaXN0ZW5jeSAyID4lQ2F0Q29uc0xvZyUNCg0KQEVDSE8gQ29uc2lzdGVuY3kgY2hl
Y2sgQ29tcGxldGUuDQoNCjo6LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLQ0KDQo6OiBNYW5pcHVsYXRlIENvbnNpc3RlbmN5IGxvZyB0byBJRCBi
YWQgaW1hZ2VzLg0KQEVDSE8uDQpARUNITyBNYW5pcHVsYXRpbmcgQ29uc2lzdGVuY3kgbG9nIHRv
IElEIGJhZCBpbWFnZXMuDQoNCiVncmVwJSAtaSAiQmFkIGltYWdlIGhlYWRlciIgJUNhdENvbnNM
b2clID4lV09SS0lOR0RJUiVccnVubmluZ19CYWRJbWFnZXMubG9nDQoNCiVncmVwJSAtaSAiPiBk
b2VzIG5vdCBleGlzdCIgJUNhdENvbnNMb2clID4lV09SS0lOR0RJUiVccnVubmluZ19JbWFnZU5v
dEV4aXN0LmxvZw0KDQo6Oi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0NCg0KOjogVGlkeSBCYWQgaW1hZ2VzIGxpc3QNCkBFQ0hPLg0KQEVDSE8g
KioqKkJhZCBJbWFnZSBIZWFkZXJzKioqKg0KRm9yIC9mICJ0b2tlbnM9KiIgJSVBIGluICglV09S
S0lOR0RJUiVccnVubmluZ19CYWRJbWFnZXMubG9nKSBkbyBjYWxsIDpUaWR5SW1hZ2VzQSAlJUEN
CmZvciAvZiAidG9rZW5zPSoiICUlQSBpbiAoJ2ZpbmQgL2kgL2MgIl8iIENsZWFuX0JhZEhlYWRl
cnMudHh0JykgRG8gU2V0IEJhZEhlYWRlcl9MaW5lcz0lJUENCnNldCBCYWRIZWFkZXJfTGluZXM9
JUJhZEhlYWRlcl9MaW5lczp+MzMsNiUNCkBFQ0hPIFRvdGFsIEJhZCBIZWFkZXJzOiBbJUJhZEhl
YWRlcl9MaW5lcyVdDQoNCkBFQ0hPLg0KQEVDSE8gKioqKk5vbi1leGlzdGVudCBJbWFnZXMqKioq
DQpGb3IgL2YgJSVCIGluICglV09SS0lOR0RJUiVcUnVubmluZ19JbWFnZU5vdEV4aXN0LmxvZykg
ZG8gY2FsbCA6VGlkeUltYWdlc0IgJSVBICUlQiAlJUMNCmZvciAvZiAidG9rZW5zPSoiICUlQSBp
biAoJ2ZpbmQgL2kgL2MgIl8iIENsZWFuX05vbkltYWdlcy50eHQnKSBEbyBTZXQgTm9uSW1hZ2Vz
X0xpbmVzPSUlQQ0Kc2V0IE5vbkltYWdlc19MaW5lcz0lTm9uSW1hZ2VzX0xpbmVzOn4zMiw2JQ0K
QEVDSE8gVG90YWwgTm9uIEltYWdlczogWyVOb25JbWFnZXNfTGluZXMlXQ0KDQoNCmdvdG8gTmV4
dA0KDQo6VGlkeUltYWdlc0ENClNldCBJbWFnZU5hbWU9JTQNCkVDSE8gJUltYWdlTmFtZSUgPj4l
V09SS0lOR0RJUiVcQ2xlYW5fQmFkSGVhZGVycy50eHQNClNFVCBJbWFnZU5hbWU9DQpnb3RvIDpl
b2YNCg0KOlRpZHlJbWFnZXNCDQpTZXQgSW1hZ2VOYW1lPSUxDQpTZXQgSW1hZ2VOYW1lPSVOQlVE
QkRydiUlSW1hZ2VOYW1lOn4wLC0yJQ0KRUNITyAlSW1hZ2VOYW1lJSA+PiVXT1JLSU5HRElSJVxD
bGVhbl9Ob25JbWFnZXMudHh0DQpTRVQgSW1hZ2VOYW1lPQ0KZ290byA6ZW9mDQoNCjo6LS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQo6TmV4
dA0KQEVDSE8uDQpARUNITyBTa2lwcGluZyBkZWxldGlvbiwganVzdCBpbiBjYXNlLg0KOjogUmVt
IHRoaXMgOmVvZiBsaW5lIHRvIGF1dG8gZGVsZXRlIGFueSBiYWQgaW1hZ2VzIGZvdW5kLg0KZ290
byA6ZW9mDQoNCkVDSE8gQ2xlYW5pbmcgQmFkIEltYWdlcyBGcm9tIENhdGFsb2d1ZQ0KRUNITyBD
bGVhbmluZyBCYWQgSW1hZ2VzIEZyb20gQ2F0YWxvZ3VlID4lUnVubmluZ2xvZyUNCkVDSE8gVGhp
cyBpcyBhIGxvZyBvZiBhbGwgU3VjY2Vzc2Z1bCBjbGVhbnMgPiVTVUNDRVNTTE9HJQ0KRUNITyBU
aGlzIGlzIGEgbG9nIG9mIGFsbCBGYWlsZWQgY2xlYW5zID4lRkFJTFVSRUxPRyUNCg0KU2V0IFN0
YXR1cz0wDQpmb3IgL2YgJSVBIGluICglV09SS0lOR0RJUiVcQ2xlYW5fQmFkSGVhZGVycy50eHQp
IGRvIGNhbGwgOmNsZWFuX2hlYWRlcnMgJSVBDQpARUNITyAqKipCYWQgSGVhZGVyIENsZWFuIEZJ
TklTSEVEKioqDQoNCkBFQ0hPLg0KU2V0IFN0YXR1cz0wDQpmb3IgL2YgJSVBIGluICglV09SS0lO
R0RJUiVcQ2xlYW5fTm9uSW1hZ2VzLnR4dCkgZG8gY2FsbCA6Y2xlYW5fbm9uaW1hZ2VzICUlQQ0K
QEVDSE8gKioqTm9uIEltYWdlIENsZWFuIEZJTklTSEVEKioqDQpARUNITy4NCkdPVE8gOmVvZg0K
DQo6Q2xlYW5faGVhZGVycw0Kc2V0IE5BTUU9JTENCnNldCAvQSBzdGF0dXM9JVN0YXR1cyUrMQ0K
ZWNobyBDbGVhbmluZyBCYWQgSW1hZ2UgSGVhZGVycywgJVN0YXR1cyUgb2YgJUJhZEhlYWRlcl9M
aW5lcyUNCkRFTCAiJW5hbWUlLioiID4+JVJ1bm5pbmdMb2clIDI+PiVGQUlMVVJFTE9HJQ0KZ290
byA6ZW9mDQoNCjpDbGVhbl9Ob25JbWFnZXMNCnNldCBOQU1FPSUxDQpzZXQgL0Egc3RhdHVzPSVT
dGF0dXMlKzENCmVjaG8gQ2xlYW5pbmcgTm9uIEltYWdlcywgJVN0YXR1cyUgb2YgJU5vbkltYWdl
c19MaW5lcyUNCkRFTCAiJW5hbWUlLioiID4+JVJ1bm5pbmdMb2clIDI+PiVGQUlMVVJFTE9HJQ0K
Z290byA6ZW9m

------_=_NextPart_001_01C50A86.FC898B8E--

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] Catalogue Corruption Cleanup Script, Uidam, T (Tim) <=