How to backup single table using ABU

Database

How to backup single table using ABU

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

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

1 REPLY

Re: How to backup single table using ABU

Solved , table can be restored if using COPY command instead of RESTORE