Veritas-bu

[Veritas-bu] NBU 4.5 backing up databases, but this applies to 3.4 as well

2002-10-23 10:44:19
Subject: [Veritas-bu] NBU 4.5 backing up databases, but this applies to 3.4 as well
From: briandiven AT northwesternmutual DOT com (briandiven AT northwesternmutual DOT com)
Date: Wed, 23 Oct 2002 09:44:19 -0500
--openmail-part-4874109d-00000002
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
        ;Creation-Date="Wed, 23 Oct 2002 09:44:19 -0500"
Content-Transfer-Encoding: quoted-printable

The NBU policies allow me to call scripts, however I can't pass
parameters which would at least allow me to use a single script. Having
multiple databases per server - the first conclusion is that I would
need 1,000 policies and 1,000 scripts to backup 1,000 DB's. Am I missing=

something obvious here=3F=20


The plot thickens in that the various database teams desire unique
schedules. So maybe I could have NBU call a master script which reads a
list of backup parameters and feeds those to an actual backup script.
But with the various schedules, that could mean more interrogation about=

each day of the week. Pretty soon I'm writing my own scheduling
software.=20


It gets deeper when I find that the desire is to dump the transaction
logs hourly for some DB's during the week. Without going deeper, that
could mean 1,000 jobs get submitted hourly of which only some would
actually submit a backup.=20


This is all "very NOT good." Our databases are mostly on raw partitions,=

so the current structure is to export to a /opt/openv/backup directory,
back this up, and then clean it up using 1 script with parms being
passed using CAM (a backup product from StorageTek that will drop
support at the end of the year). I'm struggling finding a best practice
under NBU so would appreciate ANY and ALL ideas to siphon into my tank
of ideas.=20


We are primarily a Sybase shop with some Oracle and expanding with DB2.




Brian Diven
Enterprise Storage Management
Northwestern Mutual
(414) 665-6123


--openmail-part-4874109d-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
        ;Creation-Date="Wed, 23 Oct 2002 09:44:19 -0500"
Content-Transfer-Encoding: base64

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZGVmZjBcZGVmbGFuZzEwMzN7XGZvbnR0Ymx7XGYw
XGZzd2lzc1xmY2hhcnNldDAgQXJpYWw7fXtcZjFcZnJvbWFuXGZjaGFyc2V0MCBUaW1lcyBO
ZXcgUm9tYW47fXtcZjJcZm5pbFxmY2hhcnNldDAgVGFob21hO319DQpcdmlld2tpbmQ0XHVj
MVxwYXJkXHNiMTAwXHNhMTAwXGYwXGZzMjAgVGhlIE5CVSBwb2xpY2llcyBhbGxvdyBtZSB0
byBjYWxsIHNjcmlwdHMsIGhvd2V2ZXIgSSBjYW4ndCBwYXNzIHBhcmFtZXRlcnMgd2hpY2gg
d291bGQgYXQgbGVhc3QgYWxsb3cgbWUgdG8gdXNlIGEgc2luZ2xlIHNjcmlwdC4gSGF2aW5n
IG11bHRpcGxlIGRhdGFiYXNlcyBwZXIgc2VydmVyIC0gdGhlIGZpcnN0IGNvbmNsdXNpb24g
aXMgdGhhdCBJIHdvdWxkIG5lZWQgMSwwMDAgcG9saWNpZXMgYW5kIDEsMDAwIHNjcmlwdHMg
dG8gYmFja3VwIDEsMDAwIERCJ3MuIEFtIEkgbWlzc2luZyBzb21ldGhpbmcgb2J2aW91cyBo
ZXJlP1xmMVxmczI0ICBccGFyDQpcZjBcZnMyMCBUaGUgcGxvdCB0aGlja2VucyBpbiB0aGF0
IHRoZSB2YXJpb3VzIGRhdGFiYXNlIHRlYW1zIGRlc2lyZSB1bmlxdWUgc2NoZWR1bGVzLiBT
byBtYXliZSBJIGNvdWxkIGhhdmUgTkJVIGNhbGwgYSBtYXN0ZXIgc2NyaXB0IHdoaWNoIHJl
YWRzIGEgbGlzdCBvZiBiYWNrdXAgcGFyYW1ldGVycyBhbmQgZmVlZHMgdGhvc2UgdG8gYW4g
YWN0dWFsIGJhY2t1cCBzY3JpcHQuIEJ1dCB3aXRoIHRoZSB2YXJpb3VzIHNjaGVkdWxlcywg
dGhhdCBjb3VsZCBtZWFuIG1vcmUgaW50ZXJyb2dhdGlvbiBhYm91dCBlYWNoIGRheSBvZiB0
aGUgd2Vlay4gUHJldHR5IHNvb24gSSdtIHdyaXRpbmcgbXkgb3duIHNjaGVkdWxpbmcgc29m
dHdhcmUuXGYxXGZzMjQgIFxwYXINClxmMFxmczIwIEl0IGdldHMgZGVlcGVyIHdoZW4gSSBm
aW5kIHRoYXQgdGhlIGRlc2lyZSBpcyB0byBkdW1wIHRoZSB0cmFuc2FjdGlvbiBsb2dzIGhv
dXJseSBmb3Igc29tZSBEQidzIGR1cmluZyB0aGUgd2Vlay4gV2l0aG91dCBnb2luZyBkZWVw
ZXIsIHRoYXQgY291bGQgbWVhbiAxLDAwMCBqb2JzIGdldCBzdWJtaXR0ZWQgaG91cmx5IG9m
IHdoaWNoIG9ubHkgc29tZSB3b3VsZCBhY3R1YWxseSBzdWJtaXQgYSBiYWNrdXAuXGYxXGZz
MjQgIFxwYXINClxmMFxmczIwIFRoaXMgaXMgYWxsICJ2ZXJ5IE5PVCBnb29kLiIgT3VyIGRh
dGFiYXNlcyBhcmUgbW9zdGx5IG9uIHJhdyBwYXJ0aXRpb25zLCBzbyB0aGUgY3VycmVudCBz
dHJ1Y3R1cmUgaXMgdG8gZXhwb3J0IHRvIGEgL29wdC9vcGVudi9iYWNrdXAgZGlyZWN0b3J5
LCBiYWNrIHRoaXMgdXAsIGFuZCB0aGVuIGNsZWFuIGl0IHVwIHVzaW5nIDEgc2NyaXB0IHdp
dGggcGFybXMgYmVpbmcgcGFzc2VkIHVzaW5nIENBTSAoYSBiYWNrdXAgcHJvZHVjdCBmcm9t
IFN0b3JhZ2VUZWsgdGhhdCB3aWxsIGRyb3Agc3VwcG9ydCBhdCB0aGUgZW5kIG9mIHRoZSB5
ZWFyKS4gSSdtIHN0cnVnZ2xpbmcgZmluZGluZyBhIGJlc3QgcHJhY3RpY2UgdW5kZXIgTkJV
IHNvIHdvdWxkIGFwcHJlY2lhdGUgQU5ZIGFuZCBBTEwgaWRlYXMgdG8gc2lwaG9uIGludG8g
bXkgdGFuayBvZiBpZGVhcy5cZjFcZnMyNCAgXHBhcg0KXGYwXGZzMjAgV2UgYXJlIHByaW1h
cmlseSBhIFN5YmFzZSBzaG9wIHdpdGggc29tZSBPcmFjbGUgYW5kIGV4cGFuZGluZyB3aXRo
IERCMi5cZjFcZnMyNFxwYXINClxwYXJkXGYwXGZzMjBccGFyDQpccGFyDQpcZjJcZnMxNyBC
cmlhbiBEaXZlblxwYXINCkVudGVycHJpc2UgU3RvcmFnZSBNYW5hZ2VtZW50XHBhcg0KTm9y
dGh3ZXN0ZXJuIE11dHVhbFxwYXINCig0MTQpIDY2NS02MTIzXHBhcg0KXGYwXGZzMjBccGFy
DQp9DQoA

--openmail-part-4874109d-00000002--


<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] NBU 4.5 backing up databases, but this applies to 3.4 as well, briandiven AT northwesternmutual DOT com <=