Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 09 Sep 1999 @ 14:09:55 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Archiving experiences
From:   Ed DeSousa

We use the NCR products ReelLibrarian, ReelBackup and ASF2 on a ten-slot DLT IV (70G per tape, compressed) jukebox attached to secondary node on a two node Teradata server. Since you can't effectively do incremental backups (i.e., backups of tables that have changed since the previous full backup) using ASF2, we back up DBC (all), roughly about 160G in all, and do this twice a month after the bulk of our updates to the database are completed for the month. It takes us about 6 hours, normally done after hours. We were previously doing our backups on an IBM OS390 mainframe, but each backup went close to 200 3480-cartridges (about 200M per cart). And it took over half a day.

The Fast Path mechanism for ASF2 allows us a comfortable recovery time in case we need to restore or copy. All Archive operations are accomplished as "scheduled tasks" after-hours using ASF2, root privileges and DBC as the userid, but ASF2 can be setup with differing users and permissions. To avoid confusion, I would recommend that you keep as few hands out of the mix as possible. If you have multiple users doing multiple versions of backups, it might be confusing to consolidate the info if you ever have a catastrophe and need to rebuild your warehouse from scratch.

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