ARCMAIN giving Error 3802:Database '$ARC' does not exist.

Database
Enthusiast

ARCMAIN giving Error 3802:Database '$ARC' does not exist.

I have installed free version of Teradata Express 14.0x few weeks ago. I am trying to run arcmain to archive some database and then eventually restore it to a difrrent database.

I am getting error 3802 when running rachive command, no clue why? I am on SUSE Linux ...

#!/bin/ksh

arcmain SESSIONS=8 CATALOG OUTLOG=ARCALLfinancial.log < /root/premfiles/arcmain/arcdatabase.in

Folliwng is my arcdatabase.in file:

.LOGON dbccop1/DBC,DBC;

ARCHIVE DATA TABLES (DBC) ALL,

RELEASE LOCK,

FILE=financil;

.LOGOFF;

2. I have also tried:

ARCHIVE DATA TABLES (DBC), RELEASE LOCk

3.  I have also tried:

ARCHIVE DATA TABLES (financial), RELEASE LOCk

where financial is name of the database

4. I have also tried:

ARCHIVE DATA TABLES (financial.accts), RELEASE LOCk

where financial is name of the databaseand accts is tablename

All sceraios 1 to 4 give me the same error

ARCMAIN giving Error 3802:Database '$ARC' does not exist.

ANy idea why? There is something not setup or missing in my .in file, Do not know what??

Following is log file:

010/14/2013 15:31:02  RUNNING ARCMAIN RELEASE 14.00.00.01 BUILD 1102-07e (Dec 14

                     2011)

07/14/2013 15:31:02     ***   ****    ****

07/14/2013 15:31:02    *   *  *   *  *        PROGRAM: ARCMAIN

07/14/2013 15:31:02    *****  ****   *        RELEASE: 14.00.00.01

07/14/2013 15:31:02    *   *  *  *   *        BUILD:   110207eLX (Dec 14 2011)

07/14/2013 15:31:02    *   *  *   *   ****

07/14/2013 15:31:02

07/14/2013 15:31:02  RESTARTLOG = ARCLOG130714_153102_22400.rlg

07/14/2013 15:31:02

07/14/2013 15:31:02  PARAMETERS IN USE:

07/14/2013 15:31:02

07/14/2013 15:31:02  SESSIONS 8

07/14/2013 15:31:02  CATALOG ENABLED FOR OBJECTS AND ALL TABLES

07/14/2013 15:31:02  OUTPUT LOGGED TO ARCALLfinancial.log

07/14/2013 15:31:02

07/14/2013 15:31:02

07/14/2013 15:31:02  CHARACTER SET IN USE: ASCII

07/14/2013 15:31:02  .LOGON DBCCOP1/DBC,;

07/14/2013 15:31:03  LOGGED ON 3 SESSIONS

07/14/2013 15:31:03

07/14/2013 15:31:03  DBS LANGUAGE SUPPORT MODE Standard

                                                              1,1           Top

07/14/2013 15:31:03  DBS RELEASE 14.00.00.01

07/14/2013 15:31:03  DBS VERSION 14.00.00.01

07/14/2013 15:31:03

07/14/2013 15:31:03  STATEMENT COMPLETED

07/14/2013 15:31:03

07/14/2013 15:31:03  ARCHIVE DATA TABLES (DBC) ALL,

07/14/2013 15:31:03  RELEASE LOCK,

07/14/2013 15:31:03  FILE=financil;

07/14/2013 15:31:03  UTILITY EVENT NUMBER  - 29

07/14/2013 15:31:06  LOGGED ON    8 SESSIONS

07/14/2013 15:31:06  *** Error 3802:Database '$ARC' does not exist.

07/14/2013 15:31:06  *** Failure ARC0100:Unable to create catalog table.

07/14/2013 15:31:06  LOGGED OFF  11 SESSIONS

07/14/2013 15:31:06  ARCMAIN TERMINATED WITH SEVERITY 12

5 REPLIES
Enthusiast

Re: ARCMAIN giving Error 3802:Database '$ARC' does not exist.

Oh well, I changed CATALOG to NOCATALOG

arcmain SESSIONS=8 NOCATALOG OUTLOG=ARCALLfinancial.log < /root/premfiles/arcmain/arcdatabase.in

Do not know the purpose of CATALOG?

Junior Supporter

Re: ARCMAIN giving Error 3802:Database '$ARC' does not exist.

CATALOG has tape positioning information of a table/database.It is useful when you want to restore few tables from one saveset.


Abhishek Jadhav
Teradata Employee

Re: ARCMAIN giving Error 3802:Database '$ARC' does not exist.

I'm unable to find my archived file in my system can anyone please help me how to locate the file

following is the script 

LOGON IP/dbc,dbc;

ARCHIVE DATA TABLES (UT_TAB.ACCOUNT_FEATURE),(UT_TAB.ACCOUNT_STATUS_HIST),(UT_TA

B.ACCOUNT_RATE_HIST), RELEASE LOCK, FILE=ACCTARC;

Enthusiast

Re: ARCMAIN giving Error 3802:Database '$ARC' does not exist.

Hi Divine786,

The dump file should be in the working directory where you invoked the script using ARC if you are running a standalone ARC utility.

If you have submitted the job through TARA(Netbackup), you should check the policy on the netbackup server.

If you submitted the job using FILEDEF parameter in a stand-alone manner, you should check the external name in the FILEDEF parameter for the file.

If you submitted a NPARC job then there will be a named pipe(FIFO) which is a system ipc that gives a buffer in kernel to transfer data between two processes. In this case, ARC will not store any sort of data once the job gets completed.

Regards

Enthusiast

Re: ARCMAIN giving Error 3802:Database '$ARC' does not exist.

Hello zigzagdna,

$ARC is basically a database to keep track of catalog information in the table named as CATALOG by default. If $ARC database is not available and you supplied CATALOG runtime parameter, the job will terminate, that you are currently experiencing.

CATALOG is a feature added in arc to perform a tape repositioning. It is very helpful in cases where you want to restore objects that reside in the middle or the end in huge dump file. The CATALOG table basically store the reposition information of each object along with timestamp and other info about the objects that you are archiving.

Regards,