--openmail-part-4e06d55d-00000002
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
;Creation-Date="Wed, 29 Jan 2003 13:24:39 -0600"
Content-Transfer-Encoding: quoted-printable
We are struggling trying to find a best practice for scheduling database=
backups. This email is partially in response to Deb's question about
getting creative and bending wires. We are primarily a Sybase shop
using SQL BackTrack with expanding Oracle and DB2 usage. It was the
intent to keep things similar to the way we used to do backups as we
convert to NBU (maybe that is our downfall=3F). The old way, we had a
common pre/post command script that we passed parameters to (DB
instance, tape or disk, retention period, etc.).
NBU doesn't allow you to pass parameters, but the schedule name gets
passed to the script. Aha, how about if we camouflage our parms in the
name (e.g.SYB26+Marketing+30Day+Tape+Full)=3F So, we created a policy f=
or
a HP-UX 11.11 server, and each database became a schedule. Then come to=
find out that NBU will not run multiple schedules in the same evening.
OK, let's make every instance it's own policy (this would become approx
1,000 policies). The first test night, several backups failed because
we exceeded the number of simultaneous remote connections allowed to the=
database (default value is 20). This became a catch-22, because I could=
control this on the policy level, but that won't run multiple schedules
at a time.
I'm now looking at keeping the 1,000 policies and using Autosys/CRON to
group 10-15 backups/run box. This is really getting ugly. Did we start=
off on the wrong path=3F Is this a pain because of the number of
databases=3F How are you getting around these issues and how are you
bending this wire=3F
TIA !!!
--openmail-part-4e06d55d-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
;Creation-Date="Wed, 29 Jan 2003 13:24:39 -0600"
Content-Transfer-Encoding: base64
e1xydGYxXGFuc2lcZGVmZjB7XGZvbnR0Ymx7XGYwXGZzd2lzc1xmY2hhcnNldDAgQXJpYWw7
fXtcZjFcZnJvbWFuXGZwcnEyXGZjaGFyc2V0MCBUaW1lcyBOZXcgUm9tYW47fX0NCntcY29s
b3J0YmwgO1xyZWQwXGdyZWVuMFxibHVlMjU1O30NClx2aWV3a2luZDRcdWMxXHBhcmRcY2Yx
XGxhbmcxMDMzXGYwXGZzMjBccGFyDQpcY2YwXGYxIFdlIGFyZSBzdHJ1Z2dsaW5nIHRyeWlu
ZyB0byBmaW5kIGEgYmVzdCBwcmFjdGljZSBmb3Igc2NoZWR1bGluZyBkYXRhYmFzZSBiYWNr
dXBzLiAgVGhpcyBlbWFpbCBpcyBwYXJ0aWFsbHkgaW4gcmVzcG9uc2UgdG8gRGViXHJxdW90
ZSBzIHF1ZXN0aW9uIGFib3V0IGdldHRpbmcgY3JlYXRpdmUgYW5kIGJlbmRpbmcgd2lyZXMu
ICBXZSBhcmUgcHJpbWFyaWx5IGEgU3liYXNlIHNob3AgdXNpbmcgU1FMIEJhY2tUcmFjayB3
aXRoIGV4cGFuZGluZyBPcmFjbGUgYW5kIERCMiB1c2FnZS4gIEl0IHdhcyB0aGUgaW50ZW50
IHRvIGtlZXAgdGhpbmdzIHNpbWlsYXIgdG8gdGhlIHdheSB3ZSB1c2VkIHRvIGRvIGJhY2t1
cHMgYXMgd2UgY29udmVydCB0byBOQlUgKG1heWJlIHRoYXQgaXMgb3VyIGRvd25mYWxsPyku
ICBUaGUgb2xkIHdheSwgd2UgaGFkIGEgY29tbW9uIHByZS9wb3N0IGNvbW1hbmQgc2NyaXB0
IHRoYXQgd2UgcGFzc2VkIHBhcmFtZXRlcnMgdG8gKERCIGluc3RhbmNlLCB0YXBlIG9yIGRp
c2ssIHJldGVudGlvbiBwZXJpb2QsIGV0Yy4pLlxwYXINClxwYXINCk5CVSBkb2VzblxycXVv
dGUgdCBhbGxvdyB5b3UgdG8gcGFzcyBwYXJhbWV0ZXJzLCBidXQgdGhlIHNjaGVkdWxlIG5h
bWUgZ2V0cyBwYXNzZWQgdG8gdGhlIHNjcmlwdC4gIEFoYSwgaG93IGFib3V0IGlmIHdlIGNh
bW91ZmxhZ2Ugb3VyIHBhcm1zIGluIHRoZSBuYW1lIChlLmcuU1lCMjYrTWFya2V0aW5nKzMw
RGF5K1RhcGUrRnVsbCk/ICBTbywgd2UgY3JlYXRlZCBhIHBvbGljeSBmb3IgYSBIUC1VWCAx
MS4xMSBzZXJ2ZXIsIGFuZCBlYWNoIGRhdGFiYXNlIGJlY2FtZSBhIHNjaGVkdWxlLiAgVGhl
biBjb21lIHRvIGZpbmQgb3V0IHRoYXQgTkJVIHdpbGwgbm90IHJ1biBtdWx0aXBsZSBzY2hl
ZHVsZXMgaW4gdGhlIHNhbWUgZXZlbmluZy5ccGFyDQpccGFyDQpPSywgbGV0XHJxdW90ZSBz
IG1ha2UgZXZlcnkgaW5zdGFuY2UgaXRccnF1b3RlIHMgb3duIHBvbGljeSAodGhpcyB3b3Vs
ZCBiZWNvbWUgYXBwcm94IDEsMDAwIHBvbGljaWVzKS4gIFRoZSBmaXJzdCB0ZXN0IG5pZ2h0
LCBzZXZlcmFsIGJhY2t1cHMgZmFpbGVkIGJlY2F1c2Ugd2UgZXhjZWVkZWQgdGhlIG51bWJl
ciBvZiBzaW11bHRhbmVvdXMgcmVtb3RlIGNvbm5lY3Rpb25zIGFsbG93ZWQgdG8gdGhlIGRh
dGFiYXNlIChkZWZhdWx0IHZhbHVlIGlzIDIwKS4gIFRoaXMgYmVjYW1lIGEgY2F0Y2gtMjIs
IGJlY2F1c2UgSSBjb3VsZCBjb250cm9sIHRoaXMgb24gdGhlIHBvbGljeSBsZXZlbCwgYnV0
IHRoYXQgd29uXHJxdW90ZSB0IHJ1biBtdWx0aXBsZSBzY2hlZHVsZXMgYXQgYSB0aW1lLlxw
YXINClxwYXINCklccnF1b3RlIG0gbm93IGxvb2tpbmcgYXQga2VlcGluZyB0aGUgMSwwMDAg
cG9saWNpZXMgYW5kIHVzaW5nIEF1dG9zeXMvQ1JPTiB0byBncm91cCAxMC0xNSBiYWNrdXBz
L3J1biBib3guICBUaGlzIGlzIHJlYWxseSBnZXR0aW5nIHVnbHkuICBEaWQgd2Ugc3RhcnQg
b2ZmIG9uIHRoZSB3cm9uZyBwYXRoPyAgSXMgdGhpcyBhIHBhaW4gYmVjYXVzZSBvZiB0aGUg
bnVtYmVyIG9mIGRhdGFiYXNlcz8gIEhvdyBhcmUgeW91IGdldHRpbmcgYXJvdW5kIHRoZXNl
IGlzc3VlcyBhbmQgaG93IGFyZSB5b3UgYmVuZGluZyB0aGlzIHdpcmU/XHBhcg0KXHBhcg0K
VElBICEhIVxwcm90ZWN0XGYwXHBhcg0KfQ0KAA==
--openmail-part-4e06d55d-00000002--
|
