Archives of the TeradataForum
Message Posted: Thu, 02 Mar 2000 @ 15:10:31 GMT
We are currently using a UNIX asf2 - arcmain - reel librarian - Storagetek 9710 - DLT7000 solution to backup our Teradata warehouse. I am curious if anyone has been able to find a utility/process to duplicate archive volume sets to maintain 2 copies (onsite/offsite) of the same data.
In doing some research I have found 3 or 4 possible methods:
1) ASF2 allows you to specify 2 files in the arcmain script and run each to a separate tape drive..
2) arcmain has a -m option that does "tape mirroring", I have found little documentation on this, but I think it is the same as 1.
My concern with the above stems from the NCR Knowledge Base article ID#: SA10007ADA2 Which states: "The ASF2 mirrored option does not do parallel I/Os to the two tape drives."
3) Run an archive and duplicate the volume set offline. A utility, rbdup, is around which is supposed to duplicate REEL Backup volume sets, but I have been unable to get it to work for arcmain backups.
4) Run two backups back to back on the same db/table back-to-back without releasing locks. This method just seems wasteful and way took customer impacting. (Tables are locked for twice as long as they could/should be)
Ideally, I would like to take an archive of the warehouse, analyze it, and duplicate it offline (no TD involvement), analyze the duplicate, and send the duplicate offsite.
Any ideas on the subject would be greatly appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|