Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 Jul 2002 @ 19:24:59 GMT


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


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



     
  <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