|
|
Archives of the TeradataForum
Message Posted: Fri, 09 Oct 2015 @ 21:41:18 GMT
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
| |