ABU 14.10 table restoring error

Tools

ABU 14.10 table restoring error

Hi, 

I have installed ABU14.10.

-- To backup a table for testing by option "Backup Selected Objects" , tried to backup particular table for testing.

Steps :

1. Select option "Backup Selected Objects" for backup testing table test123

2. Drop the table test123.

3. Restore the backup table and error shown : *** Error 3807:Object 'DEV_ETL.test123' does not exist.  (It can restore data if table already exist)

09/22/2014 18:15:48  ARCHIVE MAPPED TO

                     //var/abu_storage/backup/test123_541ff0d800000001_DSTREAM000

                     1.

09/22/2014 18:15:48  STARTING TO RESTORE TABLE "DEV_ETL"."test123"

09/22/2014 18:15:48  *** Error 3807:Object 'DEV_ETL.test123' does not exist.

Any got the idea ??? Thanks a lot.

-- below is the ARC backup script generated 

==================================

JOB test123

SESSIONS 2

MULTISTREAM 1

STREAM localhost

COMMANDLINE CSNAME=UTF8 

CATALOG ON

TDPID local

USERID dbc

OTB Disk 

DESTINATIONPATH /var/abu_storage/backup

SCRIPT Archive

LOGON $LOGON;

ARCHIVE DATA TABLES

      ("DEV_ETL"."test123"), 

RELEASE LOCK,

FILE=ARCHIVE;

LOGOFF;

ENDSCRIPT

========================================

==Below is restoring script generated =============================

JOB r_test123

SESSIONS 2

MULTISTREAM 1

STREAM localhost

COMMANDLINE CSNAME=UTF8 

CATALOG ON

TDPID local

USERID dbc

SOURCEUID 541ff0d800000001

DESTINATIONPATH 

SCRIPT Restore

LOGON $LOGON;

RESTORE DATA TABLES

      ("DEV_ETL") , 

RELEASE LOCK,

FILE=ARCHIVE;

LOGOFF;

ENDSCRIPT

===============================================


2 REPLIES

Re: ABU 14.10 table restoring error

Tested and table can be restored if using COPY command instead of RESTORE

N/A

Re: ABU 14.10 table restoring error

Where can I find the COPY utility. I can't seem to find in on my TDExpress15 install or figure out where to download it.