Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Mar 2009 @ 10:14:16 GMT


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


Subj:   Restoring cluster backups to smaller system
 
From:   Young, Mark

Hi,

Can anyone advise if it is possible to restore a cluster back from a 200 AMP system to a 160 AMP system? We currently run 10 cluster backup jobs each with 10 clusters or 20 AMPS on a very large table to reduce the time required to archive the table. We need to be able to restore this table to our DR system in event of a disaster and keep getting errors when testing a restore of the cluster backup to the DR system. I thought that I had read that this could be done but that the DR system would end up with 10 tables that would need to be merged together to form the final table, but cannot find this information anymore.

The error we get is

     RESTORE DATA TABLES
      (DB01.TABLE1)
      ,CLUSTERS 0,1,2,3,4,5,6,7,8,9,10

     ,DDNAME=ARCFILE ;
     UTILITY EVENT NUMBER  - 31247
     LOGGED ON   20 SESSIONS
     STARTING TO RESTORE TABLE "DB01"."TABLE1"
     *** Failure ARC1203:DBS reconfigured since ARCHIVE created.
     LOGGED OFF  22 SESSIONS
     ARCMAIN TERMINATED WITH SEVERITY 12

We restore the dictionary first as discussed in the ARC manual.


Cheers,

Mark Young
Data Warehouse Technical Specialist



     
  <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: 27 Dec 2016