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.