ARCserve 9 VLDB Database Maintenance Script 1

[vulpine]

Looking for a script that I can run to perform all the VLDB voodoo on my remote site's backup servers. All I can find here are links to CA support pages that are no longer available through CA's website (Support for v.9 dropped on 3/31/04) bummer. Many many thanks to the gracious geek who replies.

 

[davidmichel]

1) support.ca.com is gone, you have to register and login at esupport.ca.com or supportconnect.ca.com
2) Support for ARCserve 2000 = 7.0 was dropped but what that means is they are not writting new fixes for it. However point in fact there are customers with contacts so on behalf of those clients they are still updating it.
3) Here is what I have, it's not complete and depending on the version parameters may have to be changed.

rem This will check all of the databases for errors
dbcheck -a -L casdb;admin;secret asjob
dbcheck -a -L casdb;admin;secret asmedia
dbcheck -a -L casdb;admin;secret asobject
dbcheck -a -L casdb;admin;secret asrhost
dbcheck -a -L casdb;admin;secret astape
dbcheck -a -L casdb;admin;secret astpdrv
dbcheck -a -L casdb;admin;secret astpsdat

rem This section will repair each database as needed
rem dbfix -a -L casdb;admin;secret asjob
rem dbfix -a -L casdb;admin;secret asmedia
rem dbfix -a -L casdb;admin;secret asobject
rem dbfix -a -L casdb;admin;secret asrhost
rem dbfix -a -L casdb;admin;secret astape
rem dbfix -a -L casdb;admin;secret astpdrv
rem dbfix -a -L casdb;admin;secret astpsdat
rem This section will remove deleted records from the database
rem dbdefrag -a -L casdb;admin;secret asjob
rem dbdefrag -a -L casdb;admin;secret asmedia
rem dbdefrag -a -L casdb;admin;secret asobject
rem dbdefrag -a -L casdb;admin;secret asrhost
rem dbdefrag -a -L casdb;admin;secret astape
rem dbdefrag -a -L casdb;admin;secret astpdrv
rem dbdefrag -a -L casdb;admin;secret astpsdat
rem This section will repair high-level key problems, and should only be run in
rem conjunction DBDEFRAG.
rem keybuild -k -L casdb;admin;secret asjob
rem keybuild -k -L casdb;admin;secret asmedia
rem keybuild -k -L casdb;admin;secret asobject
rem keybuild -k -L casdb;admin;secret asrhost
rem keybuild -k -L casdb;admin;secret astape
rem keybuild -k -L casdb;admin;secret astpdrv
rem keybuild -k -L casdb;admin;secret astpsdat

 

[vulpine]

I thought it was maybe more elegant than that with condition statements or something. Thanks for your help David.

 

[TonyRoyston]

Hi all,

In connection with the above scripts (thanks, davidmichel), can anyone give me an idea of how long the scripts might take to run, and whether they will max out the processor?!!!

Thanks.

 

[vulpine]

It depends on how large your db is. All of them take only a second except for astpsdat. That is the monster that in the past has taken me over 24 hours just to check. But my database was huge ( > 30GB). I've since changed my database retention time to get around this.

Like others have suggested - if you want to just see how long it will take: copy the entire DATABASE folder over to another box and run them.