目的
Teradata ARCユーティリティであるarcmainを利用してバックアップを取得する。
コマンド
内容 | コマンド | 実行例 |
---|---|---|
arcmainの実行 | arcmain | |
DBにログオン | (arcmainコマンド) logon [接続先]/[ユーザ名],[パスワード]; |
logon 127.0.0.1/dbc,dbc; |
表のバックアップ | (arcmainコマンド) archive data tables ([表名]), file=[ファイル名] |
archive data tables (sysdba.t1), file=t1arc; |
ログオフ | (arcmainコマンド) logoff; |
実行例1:表のアーカイブ
arcmainを利用してSYSDBAユーザのt1表のアーカイブを取得します。
arcmainの起動
TDExpress1620_Sles11:~ # arcmain
09/12/2020 09:09:43 Copyright 1989-2018, Teradata Corporation.
09/12/2020 09:09:43 All Rights Reserved.
09/12/2020 09:09:43
09/12/2020 09:09:43 *** **** ****
09/12/2020 09:09:43 * * * * * PROGRAM: ARCMAIN
09/12/2020 09:09:43 ***** **** * RELEASE: 16.20.00.07
09/12/2020 09:09:43 * * * * * BUILD: 162020eLX64 (Oct 24 2018)
09/12/2020 09:09:43 * * * * ****
09/12/2020 09:09:43
09/12/2020 09:09:43 RESTARTLOG = ARCLOG200912_090943_23483.rlg
09/12/2020 09:09:43
09/12/2020 09:09:43 PARAMETERS IN USE:
09/12/2020 09:09:43
09/12/2020 09:09:43
09/12/2020 09:09:43
09/12/2020 09:09:43 ACCESS MODULE IN USE: NONE
09/12/2020 09:09:43
09/12/2020 09:09:43 CHARACTER SET IN USE: ASCII
###DBにログイン
logon 127.0.0.1/dbc,dbc;
09/12/2020 09:11:10 ;
09/12/2020 09:11:10 LOGON 127.0.0.1/dbc,;
09/12/2020 09:11:12 LOGGED ON 3 SESSIONS
09/12/2020 09:11:13
09/12/2020 09:11:13 DBS LANGUAGE SUPPORT MODE Standard
09/12/2020 09:11:13 DBS RELEASE 16.20.32.23
09/12/2020 09:11:13 DBS VERSION 16.20.32.23
09/12/2020 09:11:13
09/12/2020 09:11:13 STATEMENT COMPLETED
09/12/2020 09:11:13
sysdbaユーザのt1表をアーカイブ(ファイル名はt1arc)
archive data tables (sysdba.t1), file=t1arc;
09/12/2020 09:17:43 archive data tables (sysdba.t1), file=t1arc;
09/12/2020 09:17:43
09/12/2020 09:17:43 ARC HAS REQUESTED 4 SESSIONS, TASM HAS GRANTED IT 2 SESSIONS
09/12/2020 09:17:43
09/12/2020 09:17:43 UTILITY EVENT NUMBER - 36
09/12/2020 09:17:44 LOGGED ON 2 SESSIONS
09/12/2020 09:17:44
09/12/2020 09:17:44 ARCHIVING DATABASE "SYSDBA"
09/12/2020 09:17:51 "SYSDBA"."t1" - STAT COLLECTION ARCHIVED
09/12/2020 09:18:10 TABLE "t1" - 213,910,723 BYTES, 4,194,309 ROWS ARCHIVED
09/12/2020 09:18:10 DUMP COMPLETED
09/12/2020 09:18:10 STATEMENT COMPLETED
09/12/2020 09:18:10
HUTロックの解放
release lock (sysdba);
09/27/2020 12:43:32 release lock (sysdba);
09/27/2020 12:43:32 "SYSDBA" - LOCK RELEASED
09/27/2020 12:43:32 STATEMENT COMPLETED
09/27/2020 12:43:32
ログオフ
logoff;
09/12/2020 09:18:35 logoff;
09/12/2020 09:18:36 LOGGED OFF 5 SESSIONS
09/12/2020 09:18:36 STATEMENT COMPLETED
09/12/2020 09:18:36
09/12/2020 09:18:36
09/12/2020 09:18:36 ARCMAIN TERMINATED WITH SEVERITY 0
参考
ARCMAINとは • Teradata Archive/Recovery Utilityリファレンス • リーダー • Teradataドキュメント