Teradata backup of a database

Database
Enthusiast

Teradata backup of a database

HI,

I am very new to teradata. recently I have installed teradata 15 on my machine & trying to work with it. Created few procedures & functions. Now My problem is I have to take the backup of one database on my terdata machine. 

I don't find any proper links to get this backup done:

1)How can i backup complete teradata database from the CLI.

As I dont have any tools like BAR,TARA etc. I think those are paid versions, which I can't effort as I am learning with freewares.

So i request the experts to kindly provide me the steps how can i get a backup of teradata database from the CLI.

 

Thanks in advance

 

 

3 REPLIES
Senior Apprentice

Re: Teradata backup of a database

Create a file like this:

LOGON ....
ARCHIVE DATA TABLES (mydb) ALL,
RELEASE LOCK,
FILE=myfile;
LOGOFF;

And then run that using arcmain < this_file from the linux terminal (the backup tools simply provide GUIs for that).

Check the manuals for details: http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/Database_Administration_Tools/B03...

Enthusiast

Re: Teradata backup of a database

Thanks for the information. Now I can able to get the backup of my database. I m having a question regarding this 

here we are archiveing only the tables it seems. what about the procedures, functions etc. Everything will be with the myfile itself.I mean can I use this backup directly on the other machine.

Re: Teradata backup of a database

Every object other than Database and Users are trated as Tables in Teradata.the above backup script includes tables, views, macros, SPs, triggers,UDFs.

BTW both database and user are basically databases in Teradata.