Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Oct 2015 @ 21:41:18 GMT


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


Subj:   Restore Error with ABUGUI
 
From:   Bakthavachalam, Roopalini

Hi Forum,

Below restore script fails with error "Stream file name improperly specified.". However I am specifying the right path where the backup streams are present. I tried all combinations of PATHs between STREAMNAME and DESTINATION PATH, however it keeps giving the same error. Any idea what's going wrong with this script?

All the backup streams are present in the path /var/abu_storage/BACKUPS

     JOB Tbackup_RB
     SESSIONS 16
     MULTISTREAM 8
     STREAM SMP001-2
     STREAM SMP001-3
     STREAM SMP001-4
     STREAM SMP001-5
     STREAM SMP001-6
     STREAM SMP001-7
     STREAM SMP002-2
     STREAM SMP002-3
     STREAMNAME DR_TABLE1_54b1cc9b00000174_DSTREAM0001
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0002
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0003
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0004
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0005
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0006
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0007
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0008
     COMMANDLINE
     CATALOG ON
     TDPID local
     USERID abubackupuser
     SOURCEUID 54b1cc9b00000174
     DESTINATIONPATH /var/abu_storage/BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH
/var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/
BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS SCRIPT Restore LOGON $LOGON; SET QUERY_BAND='BLOCKCOMPRESSION=YES;';
     COPY DATA TABLES
             (DB1.TABLE1)(FROM(DB2.TABLE2)),
     RELEASE LOCK,
     FILE=ARCHIVE;

     LOGOFF;
     ENDSCRIPT


     
  <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