16 Jul 2015
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/B035_2412_034K/2412title.html
Dieter
21 Jul 2015
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.
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