Basics of Archiving Data | Teradata Vantage - Basics of Archiving Data - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database Node Software Migration Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
ydx1628095838609.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-5942
Product Category
Teradata Vantage

Archive Mechanisms

Starting in release 17.00, DSA is the only supported backup and restore mechanism.

Database DBC

Two archive operations are required for a full system archive. First is a DBC All archive, followed by a DBC Only archive.

Databases to Exclude

Some databases that are created by DIP scripts or replaced on a newer release should not be archived. DSA automatically excludes these databases:
  • TD_SYSFNLIB
  • SYSBAR
  • SYSUIF
  • TD_SYSGPL

The CRASHDUMPS database contains system- and release-specific crash information that will not be relevant to the destination system, so it should also be excluded from the migration.

SYSLIB database contains the GetTimeZoneDisplacement and algorithmic compression UDFs that may be referenced during the restoration process. SYSLIB is archived as part of the DBC All archive but needs to be restored immediately after the DBC Only restore and before the rest of the DBC All restore. After all other user data is restored, the DIP scripts ensure that the SYSLIB database is current.

The SYSSPATIAL database contains information about the geospatial data types.
  • If you were using non-Teradata geospatial data types on the source system, and want to keep using those data types on the destination system, you should archive and restore this database.
  • If you were using non-Teradata geospatial data types on the source system, but want to use Teradata geospatial versions of the geospatial data types on the upgraded destination system, exclude SYSSPATIAL from the migration. The SYSSPATIAL database will be automatically created on the new system, and will contain definitions for the Teradata geospatial data types.

Secure Zones

The Secure Zones feature allows creation of one or more separate and exclusive database hierarchies, called zones, within a single Analytics Database system. Access and administration for each zone is handled separately from the Analytics Database system and from other zones.

Only the owner of a Secure Zone can archive or restore databases within that zone, and that owner cannot be DBC. Each Secure Zone owner must create archive and restore jobs for the databases in their respective zones in order to perform a full-system migration. For more information, see Teradata Vantageā„¢ - Analytics Database Security Administration, B035-1100.

Source Data Preservation

As a precaution, keep the source system operational with the original data until you are certain that the destination system is running correctly with the migrated data.