Full System Restore Using the Command Line | Teradata DSA - Full System Restore Using the Command Line - BAR - Data Stream Architecture

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-11-30
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities
Prerequisite
When restoring an archive made on a source system with hardware block-level compression, you must install the hardware compression driver package (teradata-expressdx) on all TPA nodes of the destination system. The installation requires a reboot of these nodes. Because it allows the destination system to read the compressed archive, this requirement applies even if the destination system is not set up for hardware compression.
The teradata-expressdx driver package is provided with systems that are equipped with compression hardware.
For additional information, see the Teradata Vantage™ - Advanced SQL Engine Node Software Migration Guide or Teradata® Database Node Software Migration Guide specific to your database version.
These steps wipe the system. Use these steps for a full system restore.

Before you create a restore job, a backup job must have completed either successfully or with a warning.

You must create four restore jobs, one for DBC only and three from the all DBC user data backup (SYSLIB, TD_Server_Database, and all other data).

  1. On the destination system, run SYSINIT with options appropriate to your system.
  2. On the destination system, check the Time Zone setting status, and disable the setting if it is enabled.
  3. On the destination system, start the DBS Database Initializing Program (DIP) and run the DIPMIG script.
  4. If you disabled the Time Zone setting on the destination system, enable it.
  5. Check the activation status of the destination system using the dsc list_components command, dsc list_components -t system, and do one of the following:
    • If the destination system is configured and enabled, run a config_systems command with the skip parameter set to selector, dsc config_systems -f configsystem.xml -s selector.
    • If the destination system is not configured, add the system using the config_systems command, dsc config_systems -f configsystem.xml. See the following sample configsystem.xml file.
      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      
                <!--****This command must be on one line.****-->
      <dscConfigSystems xmlns="http://schemas.teradata.com/v2012/DSC"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="DSC.xsd">
      
      <system> 
      <!-- 'system_name' - Required, max 32 characters -->
      <system_name>system7</system_name> 
      
      <!-- 'tdpid' - Required (unless skipped by option)-->
      <tdpid>system7</tdpid> 
      
      <!-- 'database_query_method' - Required, accepted values: BASE_VIEW/EXTENDED_VIEW -->
      <database_query_method>BASE_VIEW</database_query_method> 
      
      <!-- 'streams_softlimit' - Required, number of streams per node per job -->
      <streams_softlimit>20</streams_softlimit> 
      
      <!-- 'streams_hardlimit' - Required, max number of streams per node-->
      <streams_hardlimit>20</streams_hardlimit> 
      
      <!-- 'reset_node_limit' - Optional, accepted values: true/false -->
      <reset_node_limit>false</reset_node_limit>  
      
      <!-- 'skip_force_full' - Optional, accepted values: true/false -->
      <skip_force_full>false</skip_force_full> 
      </system> 
      </dscConfigSystems>
  6. On the destination system, start DSMain from the Database Window (DBW) console supervisor screen by entering:
    start bardsmain -d DSCName, where DSCName is the unique name of your DSC server
  7. Enable logons for the DBC user only.
    On the destination system, enter the following from the DBW console supervisor screen:
    enable dbc logons
  8. Create a DBC-Only restore job, excluding all children of DBC, for example:
    dsc create_job -n Restore-DBC-Only -f RestoreDBCOnlyJob.xml

    Sample RestoreDBCOnlyJob.xml file:

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC">
      <job_instance>
        <job_name>Restore-DBC-Only</job_name>   
        <job_description>Restore DBC only and exclude all child objects</job_description>
        <job_type>RESTORE</job_type>
        <job_state>ACTIVE</job_state>
        <auto_retire>false</auto_retire>
        <backup_name>DBC-Only</backup_name>
        <backup_version>0</backup_version>
        <all_backup_objects>true</all_backup_objects>
      </job_instance>
      <source_media>1_5_drives </source_media>
      <target_tdpid>systemname</target_tdpid>
      <job_options>
        <enable_temperature_override>false</enable_temperature_override>
        <temperature_override>DEFAULT</temperature_override>
        <block_level_compression>DEFAULT</block_level_compression>
        <disable_fallback>false</disable_fallback>
        <query_band></query_band>
        <dsmain_logging_level>Debug</dsmain_logging_level>
        <reblock>false</reblock>
        <run_as_copy>false</run_as_copy>
      </job_options>
    </dscCreateJob>
    
  9. When prompted, enter logon credentials:
    Option Description
    Target username Current DBC user for the target DBS.
    Target password Current DBC password for the target DBS.
    Is this Restore job a DBC restore? y
    Password for the backup DBC password of the source system at the time the backup save set was generated.
  10. Run the job.
    dsc run_job -n Restore-DBC-Only
    After the DBC restore job is complete, the DBC password is set to the DBC password of the source system. The DBC database must restore successfully before you can restore user data.
  11. Create a restore job for SYSLIB only:
    dsc create_job -n Restore-SYSLIB -f R-Syslib.xml
    Important: all_backup_objects must be false when processing individual object restore or copy. If all_backup_objects is false and an objectlist is not provided, the job cannot be created.
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC">
        <job_instance>
            <job_name>R-Syslib</job_name>
            <job_description></job_description>
            <job_type>RESTORE</job_type>
            <job_state>ACTIVE</job_state>
            <auto_retire>false</auto_retire>
            <objectlist>
                <objectinfo>
                    <object_name>SYSLIB</object_name>
                    <object_type>DATABASE</object_type>
                    <parent_name>DBC</parent_name>
                    <parent_type>USER</parent_type>
                    <object_attribute_list>
                        <includeAll>false</includeAll>
                    </object_attribute_list>
                </objectinfo>
            </objectlist>
            <backup_name>DBC-ALL</backup_name>
            <backup_version>0</backup_version>
            <all_backup_objects>false</all_backup_objects>
        </job_instance>
        <source_media>target1</source_media>
        <target_tdpid>sdt12687</target_tdpid>
        <job_options>
            <enable_temperature_override>true</enable_temperature_override>
            <disable_fallback>false</disable_fallback>
            <query_band></query_band>
            <dsmain_logging_level>Error</dsmain_logging_level>
            <reblock>false</reblock>
            <run_as_copy>false</run_as_copy>
            <skip_archive>false</skip_archive>
            <skip_stats>false</skip_stats>
            <concurrent_bld_per_tbl>5</concurrent_bld_per_tbl>
        </job_options>
    </dscCreateJob>
  12. Run the job.
    dsc run_job -n R-Syslib
  13. Create a DBC-All restore job for user data, including all children of DBC except SYSLIB and TD_SERVER_DB:
    dsc create_job -n Restore-DBC-All -f RestoreDBCAllJob.xml
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC">
        <job_instance>
            <job_name>Restore-DBC-All</job_name>
            <job_description></job_description>
            <job_type>RESTORE</job_type>
            <job_state>ACTIVE</job_state>
            <auto_retire>false</auto_retire>
            <objectlist>
                <objectinfo>
                    <object_name>DBC</object_name>
                    <object_type>DATABASE</object_type>
                    <object_attribute_list>
                        <includeAll>false</includeAll>
                    </object_attribute_list>
                    <exclude>
                        <excludeobjectinfo>
                            <object_name>SYSLIB</object_name>
                            <object_type>DATABASE</object_type>
                        </excludeobjectinfo>
                        <excludeobjectinfo>
                            <object_name>TD_SERVER_DB</object_name>
                            <object_type>DATABASE</object_type>
                        </excludeobjectinfo>
                    </exclude>
                </objectinfo>
            </objectlist>
            <backup_name>DBC-ALL</backup_name>
            <backup_version>0</backup_version>
            <next_incremental_restore>false</next_incremental_restore>
            <all_backup_objects>true</all_backup_objects>
        </job_instance>
        <source_media>target1</source_media>
        <target_tdpid>abutera</target_tdpid>
        <job_options>
            <enable_temperature_override>true</enable_temperature_override>
            <disable_fallback>false</disable_fallback>
            <query_band></query_band>
            <dsmain_logging_level>Debug</dsmain_logging_level>
            <nowait>true</nowait>
            <reblock>false</reblock>
            <run_as_copy>false</run_as_copy>
            <skip_archive>false</skip_archive>
            <skip_stats>false</skip_stats>
            <concurrent_bld_per_tbl>5</concurrent_bld_per_tbl>
        </job_options>
    </dscCreateJob>
  14. When prompted, enter logon credentials and run the job.
    dsc run_job -n Restore-DBC-All
  15. Create a restore job for the TD_SERVER_DB database:
    dsc create_job -n R-TDSERVER -f R-TDSERVER.xml
    Important: all_backup_objects must be false when processing individual object restore or copy. If all_backup_objects is false and an objectlist is not provided, the job cannot be created.
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC">
        <job_instance>
            <job_name>R-TDSERVER</job_name>
            <job_description></job_description>
            <job_type>RESTORE</job_type>
            <job_state>ACTIVE</job_state>
            <auto_retire>false</auto_retire>
            <objectlist>
                <objectinfo>
                    <object_name>TD_SERVER_DB</object_name>
                    <object_type>DATABASE</object_type>
                    <parent_name>DBC</parent_name>
                    <parent_type>USER</parent_type>
                    <object_attribute_list>
                        <includeAll>false</includeAll>
                    </object_attribute_list>
                </objectinfo>
            </objectlist>
            <backup_name>DBC-ALL</backup_name>
            <backup_version>0</backup_version>
            <all_backup_objects>false</all_backup_objects>
        </job_instance>
        <source_media>target1</source_media>
        <target_tdpid>sdt12687</target_tdpid>
        <job_options>
            <enable_temperature_override>true</enable_temperature_override>
            <disable_fallback>false</disable_fallback>
            <query_band></query_band>
            <dsmain_logging_level>Error</dsmain_logging_level>
            <reblock>false</reblock>
            <run_as_copy>false</run_as_copy>
            <skip_archive>false</skip_archive>
            <skip_stats>false</skip_stats>
            <concurrent_bld_per_tbl>5</concurrent_bld_per_tbl>
        </job_options>
    </dscCreateJob>
  16. Run the job.
    dsc run_job -n R-TDSERVER
  17. On the destination system, start the DIP and run the DIPALL script.
  18. On the destination system, from the DBW console supervisor screen, enable logons for all users.
    enable logons