Exclude databases from TARA job backup

Database
Enthusiast

Exclude databases from TARA job backup

I have a TARA job which backs up everything under dbc excluding dbc. The following is part of the arc script which works

.

.

.


ARCHIVE DATA TABLES ("DBC") ALL,

EXCLUDE ("DBC"),

RELEASE LOCK,

.

.

.


I want to exclude specific system databases that do not need to backed up such as ALL,PUBLIC,DEFAULT. I have edited the original script as shown below

.

.

.

ARCHIVE DATA TABLES ("DBC") ALL,

EXCLUDE ("DBC","ALL","PUBLIC","DEFAULT"),

RELEASE LOCK,

FILE=ARCHIVE;

.

.

.

But i get the error shown below that the syntax is correct. 

04/04/2016 18:47:47  ARCHIVE DATA TABLES ("DBC") ALL,

04/04/2016 18:47:47  EXCLUDE ("DBC","ALL","PUBLIC","DEFAULT"),

04/04/2016 18:47:47  *** Failure ARC0202:, was not expected.

04/04/2016 18:47:47  LOGGED OFF   3 SESSIONS

04/04/2016 18:47:47  ARCMAIN TERMINATED WITH SEVERITY 12

I can't seem to find any other example in this forum or google which describes how to exlude multiple databases from archiving.

Please help!!

Tags (4)
2 REPLIES
Teradata Employee

Re: Exclude databases from TARA job backup

EXCLUDE ("DBC"),("ALL"),("PUBLIC"),("DEFAULT"),

Enthusiast

Re: Exclude databases from TARA job backup

Thanks a lot. It works!