Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 02 Mar 2000 @ 15:10:31 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Making 2 copies of a backup.
From:   Steve Thill


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.


Steve Thill

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020