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 ...
arcmain SESSIONS=8 CATALOG OUTLOG=ARCALLfinancial.log < /root/premfiles/arcmain/arcdatabase.in
Folliwng is my arcdatabase.in file:
ARCHIVE DATA TABLES (DBC) ALL,
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
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 RESTARTLOG = ARCLOG130714_153102_22400.rlg
07/14/2013 15:31:02 PARAMETERS IN USE:
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 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 DBS LANGUAGE SUPPORT MODE Standard
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 STATEMENT COMPLETED
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
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?
CATALOG has tape positioning information of a table/database.It is useful when you want to restore few tables from one saveset.
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
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.
$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.