Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 10 Feb 2004 @ 14:30:05 GMT

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

Subj:   Re: Restoring cluster dump to a different configuration
From:   Fred W Pluebell

RESTORE only works on a different system if you have restored database DBC (e.g. in a disaster recovery or system migration scenario) so the internal object IDs match. Otherwise you must use COPY. And you must restore or copy the dictionary entries separately, before the first set of cluster data.

Using CLUSTER dump trades off a shorter "backup window" against a more complicated recovery. In normal operations, one tends to ARCHIVE or DUMP many times and seldom, if ever, RESTORE or COPY - so cluster dump is a clear winner for large tables or databases if you have sufficient resources (e.g. multiple backup devices).

  <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: 28 Jun 2020