Script for Complete Teradata database system backup

Database

Script for Complete Teradata database system backup

Hi,

I am trying to take the complete teradata development system backup through ABU. But I am getting "Failure ARC0202:Reserve was not expected" error. Kindly let me know whether I can exclude the spool reserve database from backup script. May I know the script for Full Development teradata database backup script ??? If I exclude the spool reserve database from backup script then will it be full backup ?????

Regards,

Mahendra.

1 REPLY
Teradata Employee

Re: Script for Complete Teradata database system backup

sounds more like a syntax error

the generic ARC single stream backup scripts to backup the complete Teradata RDBMS are

i. backup of DBC database

ARCHIVE DATA TABLES (DBC),

ii. backup of everything else

ARCHIVE DATA TABLES (DBC) ALL,
EXCLUDE (DBC),

There are various exceptions which rely on only system generated objects being in the target databases eg. systemfe and crashdumps.  The guideline would be if you don't need it for the restore you don't need to back it up, noting there are various other system databases that you may want/need to backup eg. TDWM

ta'