I am new to Teradata. I understand that there are 2 types of backups required. One for DBC data dictionary and the reste for other databases.
I believe that ARCUSER1 can handle the backup of other databases. But DBC backups can be taken only by DBC ? If so I would have to give the password to the operations team responsible for backups. I am not comfortable with that. Is there anyway we can create an user that can handle all the backups including DBC ?
You normally have a user that is used for backup purposes.
When using Arcmain to perform a backup it is true that you take two backups. I am including two examples, one for DBC and another for something else.
This first example will backup just the metadata for the root database DBC and excludes other databases.
ARCHIVE DATA TABLES (DBC) ALL, EXCLUDE (APPL_G1) ALL, (APPL_G2) ALL, (APPL_G3) ALL, (APPL_G4) ALL, (APPL_G5) ALL, (APPL_G6) ALL, (APPL_G7) ALL, (APPL_G8) ALL, (APPL_G9) ALL, (APPL_G10) ALL, (APPL_G11) ALL, (APPL_GB) ALL, (APPL_GF) ALL, (APPL_GJ) ALL, RELEASE LOCK, NONEMPTY DATABASES, FILE = X; LOGOFF;
This second example performs an all amps dump of the database systemfe.
LOGON $LOGON; ARCHIVE DATA TABLES (SystemFe) ALL, RELEASE LOCK, FILE = X; LOGOFF;
Hope this helps explain things and good luck with Teradata.