How to restore perticular TABLE from backup location in TERADATA.

Database
Enthusiast

How to restore perticular TABLE from backup location in TERADATA.

Hi,

I am new to TERADATA technology, recently we took backup of our teradata database (which is of 3.6 TB). Now we are trying to restore sample table by using that backup. Later if succeed in one perticular table then we will moving ahead to restore whole database.

Problem which we are facing is, as we are new to this, Can anyone guide us to do the needful, Or anyone share us the scripts which will help us to restore the sample tables ???

Urgent help required.

Regards,

Deepak Dhabade

5 REPLIES
Enthusiast

Re: How to restore perticular TABLE from backup location in TERADATA.

Are you using Tara gui. if so you can generate it using Task>>Restore menu which will ask  for the table that you want to restore and the credentials. One you select that you can ask to build script which builds the scrip . it also asks for the number of sessions. Once you have the script you can make modifications as required and ask Tara to launch it. Fro more information on the commands used please verify the user manual.

Enthusiast

Re: How to restore perticular TABLE from backup location in TERADATA.

Hi,

We are working actually on ABU which is a component of Teradata Tools and Utility. So we need the script to Restore a particular table through ABU. Please provide the script of restoring through TARA Gui in which different credentials are provided already.

Thanks and Regards,

Deepak Dhabade.

Enthusiast

Re: How to restore perticular TABLE from backup location in TERADATA.

Hi All,

Can we try this approach for single table restoration?

1. Backup on Prod

LOGON DBCID/UID,PWD;

ARCHIVE DATA TABLES (DB_Name.Table_Name) ALL,

RELEASE LOCK,

FILEDEF=(tddumps, drive_Location/dump.%UEN%.out);

LOGOFF;

OR

FILEDEF can be setup as a default run-time parameter by using following command:

FILEDEF=(tddumps, drive_Location/dump.%UEN%.out).

And then the script is executed as follows.

LOGON DBCID/UID,PWD;

ARCHIVE DATA TABLES (DB_Name.Table_Name) ALL,

RELEASE LOCK,

FILE=(tddumps);

LOGOFF;

2. Copy the backup file (dump.%UEN%.out) from Source (Prod) to destination (DEV)

3. Restore the table on DEV using following script, table with a new name

LOGON DBCID/UID,PWD;

RESTORE DATA TABLES (DB_Name.Table_Name_New) ALL,

RELEASE LOCK,

FILEDEF=(tddumps,drive_location/dump.%UEN%.out);

LOGOFF;

Thanks in advance.

Regards,

Deepak D

Enthusiast

Re: How to restore perticular TABLE from backup location in TERADATA.

you should be having the ABUGUI which works similar to TARAGUI. You can restore selected objects or all the objects.

Instead of FILEDEF you can also give File=archive. Also you can try the COPY command instead of RESTORE. The sessions, CATALOG, userid,command line character set can be specified before the logon and you need to use script RESTORE if going specifically thru command line

Enthusiast

Re: How to restore perticular TABLE from backup location in TERADATA.

Thanks Krishna for the update.