如何进行Teradata数据库构建

Question

我在Teradata Database Express 14.0 中工作

现在，我想构建一个特定的数据库（备份所有对象，如表、sp、视图、udf、索引、触发器等）。

我试过这种方法，但我得到了错误：

TDExpress14.10.03_Sles11:~ # bteq
Enter your logon or BTEQ command:
.logon localhost/xyz
Password:xxx
BTEQ -- Enter your SQL request or BTEQ command:
ARCHIVE DATA TABLES (xyz)ALL,
RELEASE LOCK,
FILEDEF=(tddumps,/var/tddumps/dump.%UEN%.out);

错误：

ARCHIVE DATA TABLES(MENTISAGENT)ALL,
         $
*** Failure 3706 Syntax error: expected something between the beginning of
the request and the word 'ARCHIVE'.
            Statement# 2, Info =10
*** Total elapsed time was 1 second.

有人能帮我解决这个错误吗？并指导我如何备份Teradata数据库

Answer 1

根据您的脚本，您尝试在bteq中使用ARCHIVE语法，但要备份数据库，您必须使用Teradata的备份实用程序ARCMAIN

Answer 2

1）访问权限："DBC"上的GRANT DUMP到"xyz"，带有GRANT OPTION（可能是可选的）

2） 在环境（Linux）中执行以下命令：

TDExpress14.10.03_Sles11:~ # pwd
/root
TDExpress14.10.03_Sles11:~ # cd Documents/
TDExpress14.10.03_Sles11:~/Documents #  
    **TDExpress14.10.03_Sles11:~/Documents #   arcmain**
    04/28/2016 03:39:55   Copyright 1989-2013, TeradataCorporation.
    04/28/2016 03:39:55   All Rights Reserved.
    04/28/2016 03:39:55
    04/28/2016 03:39:55     ***   ****    ****
    04/28/2016 03:39:55    *   *  *   *  *        PROGRAM: ARCMAIN
    04/28/2016 03:39:55    *****  ****   *        RELEASE: 14.10.00.05
    04/28/2016 03:39:55    *   *  *  *   *        BUILD:120212eLX (Aug  5 2014)
    04/28/2016 03:39:55    *   *  *   *   ****
    04/28/2016 03:39:55
    04/28/2016 03:39:55  RESTARTLOG = ARCLOG160428_033954565_7353.rlg
    04/28/2016 03:39:55
    04/28/2016 03:39:55  PARAMETERS IN USE:
    04/28/2016 03:39:55
    04/28/2016 03:39:55
    04/28/2016 03:39:55
    04/28/2016 03:39:55  CHARACTER SET IN USE: ASCII                                                                                                                        
    **.logon localhost/xyz,xxx;**
    04/28/2016 03:40:25  .LOGON LOCALHOST/xyz,;
    04/28/2016 03:40:25  LOGGED ON 2 SESSIONS
    04/28/2016 03:40:25
    04/28/2016 03:40:25  DBS LANGUAGE SUPPORT MODE Standard
    04/28/2016 03:40:25  DBS RELEASE 14.10.03.02
    04/28/2016 03:40:25  DBS VERSION 14.10.03.02
    04/28/2016 03:40:25
    04/28/2016 03:40:25  STATEMENT COMPLETED
    04/28/2016 03:40:25
    **archive data tables(xyz)all,release lock,file=test;**
    04/28/2016 03:42:37  archive data tables(xyz),release lock,file=test;
    04/28/2016 03:42:37
    04/28/2016 03:42:37  ARC HAS REQUESTED 4 SESSIONS, TASM HAS GRANTED IT 4 SESSIONS
    04/28/2016 03:42:37
    04/28/2016 03:42:37  UTILITY EVENT NUMBER  - 45
    04/28/2016 03:42:38  LOGGED ON    4 SESSIONS
    04/28/2016 03:42:38
    04/28/2016 03:42:38  ARCHIVING DATABASE "xyz"
    04/28/2016 03:42:40  FUNCTION "XYZZ" - 686 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:40  FUNCTION "ZZ" - 694 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:40  TABLE "ZZ1" - 608 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:40  TABLE "SB" - 478 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:40  FUNCTION "DBMSSBR_RANDOM_STRING" - 694 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:40  TABLE "SGR" -   5,280,782 BYTES, 220,000 ROWS ARCHIVED
    04/28/2016 03:42:40  TABLE "emp4" -  33,666 BYTES, 1,000 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "SBRSB" - 530 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  PROCEDURE "TSHSRHTR" -  21,766 BYTES, 1 ROWS
                         ARCHIVED
    04/28/2016 03:42:41  TABLE "HRHHW" - 864 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "RJSRERJ" - 520 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "SJR6J" - 732 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "SJJR" -   1,056 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "SHTHH" -   1,122 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "ATDHDHDT" - 622 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "HTAHR" - 528 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  TABLE "AHTHARHR" - 530 BYTES, 0 ROWS ARCHIVED
    04/28/2016 03:42:41  PROCEDURE "AHTAH" -  12,563 BYTES, 1 ROWS ARCHIVED
    04/28/2016 03:42:41  "xyz" - LOCK RELEASED
    04/28/2016 03:42:41  DUMP COMPLETED
    04/28/2016 03:42:41  STATEMENT COMPLETED
    04/28/2016 03:42:41
    **ARCMAIN TERMINATED WITH SEVERITY 0**
    04/28/2016 03:43:04  ARCMAIN TERMINATED WITH SEVERITY 0
    04/28/2016 03:43:04  *** Failure ARC0202:TERMINATED was not expected.
    04/28/2016 03:43:09  LOGGED OFF   6 SESSIONS
    04/28/2016 03:43:09  ARCMAIN TERMINATED WITH SEVERITY 12

3） 之后，转到/root/Documents/文件夹，您可以看到名为TEXT的文件。

4） 备份已完成。

供参考：Teradata数据库备份