Changes That Force Full Restore of IR-Enabled Restore Job | Teradata DSA - Changes That Force Full Restore of IR-Enabled Restore Job - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.00
Published
August 2020
Language
English (United States)
Last Update
2020-08-31
dita:mapPath
mas1575933453856.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
Certain changes to the Job Definition require a full backup for an IR enabled backup instead of incremental.These changes include the following:
  • reset_ir_target_system was run on the IR-enabled target system
  • Reset was run from the BAR Setup portlet on the target system:

    DSC Servers > Systems and Nodes > Systems > IR Support > Reset

  • build_restore_objects was run with the -a|allow_write option on the IR-enabled restore job
  • Build restore objects was run from the BAR Operations portlet:

    From an IR-enabled restore job, select "" > Build Restore Objects

  • run_job was executed with the -a|allow_write option on the IR-enabled restore job
  • Run job with allow write option was run from the BAR Operations portlet:

    From an IR-enabled restore job, select "" > Run Job, then select Allow write for objects after restore.

Changes to These Elements Force a Full Restore

XML File BAR Operations Portlet
anything within <objectlist> Objects Tab: Objects
<all_backup_objects> Objects Tab: Objects
<source_media> Target Group
<enable_temperature_override> Advanced Settings: Override Temperature
<temperature_override> Advanced Settings: Override Temperature
<block_level_compression> Advanced Settings: Block Level Compression
<disable_fallback>
  • [Advanced SQL Engine 16.20 Update 1 and later] Fallback cannot be disabled. Entry is ignored.
  • [Prior versions of Advanced SQL Engine / Teradata Database] Disable fallback is not available unless run_as_copy is true.
Job Settings tab: Disable fallback
  • [Advanced SQL Engine 16.20 Update 1 and later] Fallback cannot be disabled. Checkbox is ignored.
  • [Prior versions of Advanced SQL Engine / Teradata Database] Disable fallback is not available unless Run as copy is checked. The icon
    appears when the mouse pointer is hovered over the checkbox.
<query_band> Job Settings Tab: Query Band
<run_as_copy> Job Settings Tab: Run as copy
<skip_stats> Advanced Settings button: Skip statistics
<config_map_name> Advanced Settings button: Destination System Hash Map
<map_to> Advanced Settings button: Map to a different database on destination system
<skip_joinhash_index> Advanced Settings button: Skip join/hash index
XML File BAR Setup Portlet
<target_tdpid> target systems (destination system) DSC Servers > Systems and Nodes > Systems

Changes to These Elements Do Not Affect IR-Enabled Restore

XML File BAR Operations Portlet
<job_description> Description
<auto_retire> Job Settings Tab: Automatically Retire
<retire_value> Job Settings Tab: enter value
<retire_units> Job Settings Tab: DAYS or WEEKS
<dsmain_logging_level> Job Settings Tab: Logging Level
<reblock> Not available in portlet for edit
<skip_archive> Abort On Access Rights Violation checkbox
<concurrent_bld_per_tbl> Advanced Settings: Concurrent Builds Per Table
<streams_softlimit> Advanced Settings: Limit the maximum streams per node for this job
<skip_build_secondary_indexes> Advance Settings: Skip build secondary indexes
Changing between next_incremental_restore and backup_version