All Forums Database
yiannish 13 posts Joined 06/14
04 Apr 2016
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!!

Fred 1096 posts Joined 08/04
05 Apr 2016

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

yiannish 13 posts Joined 06/14
05 Apr 2016

Thanks a lot. It works!

You must sign in to leave a comment.