Manage DBC and User Data in the BAR Portlets | Teradata DSA - Managing DBC and User Data in the BAR Portlets - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.10
Published
April 2022
Language
English (United States)
Last Update
2022-04-08
dita:mapPath
het1611950545663.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
The DBC database contains critical system tables that define the user databases in Advanced SQL Engine / Teradata Database. The system tables, views, and macros in the DBC database cannot be selectively backed up and must be backed up in their entirety. The BAR Operations portlet does not allow any of the DBC system objects to be selected for backup.
Full user access privileges are required for archiving or restoring DBC.

To back up and restore the DBC database and all user databases, you must create a separate backup job for the DBC database, then a separate backup job for the other databases. After the backup jobs have successfully completed, you must create a separate restore job for each of the backup jobs.

When restoring the DBC backup, the DBC password of the system that was backed up is required.
  1. Back up the DBC and user data in BAR Operations.
  2. Restore the DBC and user data in BAR Operations.