Selective Backup and Restore Rules - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Selective Backup and Restore Rules

When performing a selective backup and restore on a table or database, observe the following rules in order for the operation to be successful.

  • Methods and UDTs are stored in SYSUDTLIB; SYSUDTLIB is only backed up or restored as part of a DBC backup.
  • While an operation may be allowed, there is no guarantee the object will function as desired once the operation is complete.
  • For some copy operations, certain dependencies must be met before the operation can be successful. For example, to copy a database with a journal table — the destination database must be created with a journal table.
  •  

    Table 23: Selective Backup and Restore Rules 

    Type

    Restore to same DBS

    Copy to same DBS

    Copy and Rename to same DBS

    Copy to different DBS

    Copy and Rename to different DBS

    DB Level

    Object Level

    DB Level

    Object Level

    DB Level

    Object Level

    DB Level

    Object Level

    DB Level

    Object Level

    Aggregate Function

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    JAR

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    External Stored Procedures

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Standard Function

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Trigger

    Yes

    Yes

    No

    No

    No

    No

    No

    No

    No

    No

    Instant or Constructor Method

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    Join Index

    Yes

    Yes

    Yes

    Yes

    No

    No

    Yes

    Yes

    No

    No

    System Join Index1

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Macro

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Hash Index

    Yes

    Yes

    Yes

    Yes

    No

    No

    Yes

    Yes

    No

    No

    Stored Procedure

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Queue Table

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Table Function

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Table Function(Operator)

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Table

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    PPI Table

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    NOPI Table

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    Yes

    User-Defined Data Type (UDT)

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    N/A

    View

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Authorization

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Parser Contract Function

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    User Installed File (UIF)

    Yes

    Yes

    Yes

    Yes

    Yes

    No

    Yes

    Yes

    Yes

    No

    Remote Server2

    Yes

    Yes

    Yes

    Yes

    No

    No

    Yes

    Yes

    No

    No


    1
    System Join Indexes (SJIs) can be copied to a different database. The DB name can be changed but the object name can not.

    2
    All dependent objects used by the remote server object must exist prior to the copy.