 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Sep 1999 @ 14:09:55 GMT
| 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.
| |
