Print
All Forums Tools
tvn 10 posts Joined 05/08
09 May 2008
How to make use of ARCMAIN utility to take DB backup.

I was asked to take database backup using ARCMAIN. But, not sure how to start using this utility. Expecting valuable helps from the group.thanks in advance.

dnoeth 4628 posts Joined 11/04
09 May 2008

There's a manual on ARC:Teradata Archive/Recovery Utility ReferenceDieter

Dieter

tvn 10 posts Joined 05/08
11 May 2008

Thanks Dieter. Let me go through the doc.

PUCHEROS 1 post Joined 06/08
04 Aug 2010

Example for a Backup of tables:
-------------------------------
logon ZZZZ/YYYY,XXXX;

ARCHIVE DATA TABLE

(DATABASENAME.TABLENAME1),
(DATABASENAME.TABLENAME2),
(DATABASENAME.TABLENAME3),

RELEASE LOCK,

FILE=NVDSID1;

Example for a Restore of tables:
--------------------------------
logon ZZZZ/YYYY,XXXX;

COPY DATA TABLES

(DATABASENAME.TABLENAME11) (FROM(DATABASENAME.TABLENAME1)),
(DATABASENAME.TABLENAME12) (FROM(DATABASENAME.TABLENAME2)),
(DATABASENAME.TABLENAME13) (FROM(DATABASENAME.TABLENAME3)),

RELEASE LOCK,

FILE=NVDSID1;

Sincerely...

MAURICIO USUGA
IT Specialist-DBA
IBM

satishjampa 7 posts Joined 04/11
05 Jun 2011

Hi Mauricio,

Thanks for your script and it has been very helpful to to move a bunch of tables without restoring them. I have a question on that. what if the file is on a different directory /temp/data/NVDSID1

FILE=/temp/data/NVDSID1

is this correct?
please advise

Langaliya.Nirav 15 posts Joined 04/11
09 Jun 2011

You can also use DUMP in place of ARCHIVE

-------------------------------
logon ZZZZ/YYYY,XXXX;

DUMP DATA TABLES

(DATABASENAME.TABLENAME1),
(DATABASENAME.TABLENAME2),
(DATABASENAME.TABLENAME3),

USE READ LOCK,
RELEASE LOCK ,

FILE=NVDSID1;
LOGOFF;

and Satish , yes you can use file name FILE=/temp/data/NVDSID1 to store archived data

--Nirav Langaliya

Tanmoy 3 posts Joined 02/15
22 Mar 2015

03/22/2015 04:20:53  .logoffoot/Teradata/financial_custonline.data,

03/22/2015 04:20:53  *** Failure ARC0226:"/root/T contain too many characters.

 

I am getting the above error when i run the below archive script.

 

.logon 127.0.0.1/dbc,dbc;

 

archive data tables (financial.custonline),

release lock,

file="/root/Teradata/NVDSID1",

.logoff

 

Am I missing something ? Also, would I be allowed to change the file-name to any other name?

 

 

Tanmoy 3 posts Joined 02/15
22 Mar 2015

I am trying to run the below Archive script:
 

.logon 127.0.0.1/dbc,dbc;

archive data tables (financial.custonline),
release lock,
file="/root/Teradata/custonline_Data";
.logoff;

Is it possible to change the filename in the archival script ? I need to maintain the data in specific location.
What is the best practice to perform ARC of tables ?

 

dnoeth 4628 posts Joined 11/04
22 Mar 2015

You can't use more than 8 characters for FILE or add a path within the ARC script:

archive data tables (financial.custonline),
release lock,
file=ARCHIVE;

Then you use a runtime parameter to map ARCHIVE to the actual name:

ARCMAIN FILEDEF=(ARCHIVE,/root/Teradata/custonline_Data) < yourscript

 

Dieter

kishorea1505 3 posts Joined 03/16
02 Mar 2016

Hi, 
 
Is it anyway to read the ARCMAIN file output?
We had an old Arcmain file, wondering if there is any way to read it.

Kishore~A

ppatel@c...ital.com 1 post Joined 04/16
12 May 2016

Hello:
Arcmain fails after certain time with below error.
"Failure 8055:Session forced off by PMPC or gtwglobal"
Any idea?

Fred 1096 posts Joined 08/04
14 May 2016

Please start a new topic for new questions.
Someone or some automatedl process (e.g. monitoring "idle" sessions) issued an ABORT. Check DBC.Software_Event_LogV for more detail.
You may need to exempt the ARC job from whatever process is responsible.

You must sign in to leave a comment.