Archives of the TeradataForum
Message Posted: Mon, 01 Jul 2002 @ 19:24:59 GMT
| Subj: | | Re: Cluster archives vs. database level archives |
| |
| From: | | Raghav Vaidya |
Cluster backups are done on a group of Amps (Cluster) into a set of different files as opposed to a single file in a normal
Archive. The archives run in parallel so the it's much faster.
There are more drawbacks than advantages. You need more tapes, more tapedrives. More important, there is no dictionary archive as
only the table data is archived . You have to archive the dictionary seperately. For a restore from a Cluster backup to be
successful, the dictionary should match else the restore will fail.
It is ideal for archiving tables whose definitions don't change. Also, alrge tables can archived in a fraction of the time taken
by the normal Amp Archive.
Raghav...
| 
