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...
| 
